mirror of
https://github.com/MariaDB/server.git
synced 2025-04-09 00:35:40 +02:00
11 lines
393 B
Text
11 lines
393 B
Text
SET DEFAULT_STORAGE_ENGINE = 'tokudb';
|
|
DROP TABLE IF EXISTS foo;
|
|
create table foo (a blob, key (a(3)))engine=tokudb;
|
|
insert into foo value ("asfdasdfasdfasdf");
|
|
explain select * from foo where a like 'asf%';
|
|
id select_type table type possible_keys key key_len ref rows Extra
|
|
1 SIMPLE foo range a a 6 NULL 1 Using where
|
|
select * from foo where a like 'asf%';
|
|
a
|
|
asfdasdfasdfasdf
|
|
DROP TABLE foo;
|