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

LevelDB: indexes on text/blob fields are not allowed

    XMLWordPrintable

Details

    • Technical task
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • None
    • None
    • None

    Description

      I'm not sure whether it's supposed to be supported, but now it isn't (works with InnoDB though):

      mysql> create table t1 (pk int primary key, t text, key(t(256))) engine=leveldb;
      ERROR 1073 (42000): BLOB column 't' can't be used in key specification with the used table type
       
      mysql> create table t1 (pk int primary key, t text, key(t(256))) engine=innodb;
      Query OK, 0 rows affected (0.33 sec)
       
      mysql> create table t2 (pk int primary key, b blob, key(b(256))) engine=leveldb;
      ERROR 1073 (42000): BLOB column 'b' can't be used in key specification with the used table type
       
      mysql> create table t2 (pk int primary key, b blob, key(b(256))) engine=innodb;
      Query OK, 0 rows affected (0.10 sec)
       

      revision-id: psergey@askmonty.org-20130125200959-a7gq7phbaiajqs12
      revno: 4519
      branch-nick: mysql-5.6-leveldb

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.