Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3841 LevelDB storage engine
  3. MDEV-4054

LevelDB: Reading by PK prefix does not work (fails with "Table storage engine doesn't have this option")

        Details

        • Type: Technical task
        • Status: Closed
        • Priority: Minor
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: None
        • Labels:

          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

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                psergey Sergei Petrunia added a comment -

                Will be fixed when adding support for range scanning.

                Show
                psergey Sergei Petrunia added a comment - Will be fixed when adding support for range scanning.
                Hide
                Permalink
                psergey Sergei Petrunia added a comment -

                Fixed after the latest changes. Test case added to leveldb.test.

                Show
                psergey Sergei Petrunia added a comment - Fixed after the latest changes. Test case added to leveldb.test.

                  People

                  • Assignee:
                    psergey Sergei Petrunia
                    Reporter:
                    elenst Elena Stepanova
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: