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

Syntax Error on ALTER TABLE ENGINE=TokuDB COMPRESSION=TOKUDB_LZMA

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Cannot Reproduce
    • 5.5.33a
    • 5.5.34
    • None
    • 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

            serg Sergei Golubchik
            stephane@skysql.com VAROQUI Stephane
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.