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

LevelDB: UPDATE/DELETE by a multi-part PK does not work (fails with "Table storage engine doesn't have this option")

        Details

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

          Description

          After the last changes SELECT by a multi-part key works, but UPDATE doesn't.

          Test output:

          create table t1 (i int, j int, k int, primary key(i,j,k), a varchar(8)) engine=LevelDB;
insert into t1 values (1,10,100,''),(2,20,200,'');
select * from t1 where i = 1 and j = 10 and k = 100;
i       j       k       a
1       10      100
update t1 set a = 'updated' where i = 1 and j = 10 and k = 100;
ERROR HY000: Table storage engine for 't1' doesn't have this option

          Test case:

          create table t1 (i int, j int, k int, primary key(i,j,k), a varchar(8)) engine=LevelDB;
insert into t1 values (1,10,100,''),(2,20,200,'');
select * from t1 where i = 1 and j = 10 and k = 100;
update t1 set a = 'updated' 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

                Hide
                Permalink
                psergey Sergei Petrunia added a comment -

                Fixed with the latest changes.

                Show
                psergey Sergei Petrunia added a comment - Fixed with the latest changes.

                  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: