create table t1 (i int, j int, k int, primary key(i,j,k)) engine=LevelDB;

insert into t1 values (1,10,100),(2,20,200);

select * from t1 where i = 1;

ERROR HY000: Table storage engine for 't1' doesn't have this option

select * from t1 where j = 10;

i       j       k

1       10      100

select * from t1 where k = 100;

i       j       k

1       10      100

select * from t1 where i = 1 and j = 10;

ERROR HY000: Table storage engine for 't1' doesn't have this option

select * from t1 where i = 1 and k = 100;

ERROR HY000: Table storage engine for 't1' doesn't have this option

select * from t1 where j = 10 and k = 100;

i       j       k

1       10      100

select * from t1 where i = 1 and j = 10 and k = 100;

i       j       k

1       10      100

--disable_abort_on_error

create table t1 (i int, j int, k int, primary key(i,j,k)) engine=LevelDB;

insert into t1 values (1,10,100),(2,20,200);

select * from t1 where i = 1;

select * from t1 where j = 10;

select * from t1 where k = 100;

select * from t1 where i = 1 and j = 10;

select * from t1 where i = 1 and k = 100;

select * from t1 where j = 10 and k = 100;

select * from t1 where i = 1 and j = 10 and k = 100;

revision-id: psergey@askmonty.org-20130115181447-1jfr200qcuqzp1sr

revno: 4495

branch-nick: mysql-5.6-leveldb