Details
-
Technical task
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
-
None
-
None
Description
Test output:
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
|
Test case:
--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
|