Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5097

Syntax Error on ALTER TABLE ENGINE=TokuDB COMPRESSION=TOKUDB_LZMA

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Cannot Reproduce
    • Affects Version/s: 5.5.33a
    • Fix Version/s: 5.5.34
    • Component/s: None
    • Labels:
    • Environment:
      Debian Squeeze

      Description

      The doc state

      The DDL syntax is different. While binaries from Tokutek have the patched SQL parser, TokuDB in MariaDB uses the special Storage Engine API extension. Thus in Tokutek binaries you write CLUSTERED KEY (columns) and, for example, ROW_FORMAT=TOKUDB_LZMA. And in MariaDB you write KEY (columns) CLUSTERING=YES and COMPRESSION=TOKUDB_LZMA.

      But it looks that alter table does not follow documented rules.

      MariaDB [tyrebase4W]> alter table t_price_multi drop index date, add primary key (date,id), engine=tokudb compression=tokudb_lzma;
      ERROR 1911 (HY000): Unknown option 'compression' 

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            stephane@skysql.com VAROQUI Stephane
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: