[MDEV-5097] Syntax Error on ALTER TABLE ENGINE=TokuDB COMPRESSION=TOKUDB_LZMA Created: 2013-10-03  Updated: 2013-11-07  Resolved: 2013-11-07

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.33a
Fix Version/s: 5.5.34

Type: Bug Priority: Critical
Reporter: VAROQUI Stephane Assignee: Sergei Golubchik
Resolution: Cannot Reproduce Votes: 0
Labels: tokudb
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'



 Comments   
Comment by Sergei Golubchik [ 2013-10-03 ]

I think the problem is that you change the engine and in the same statement set attributes (compression) specific to the new engine. I'd guess that the server looks in the old storage engine to see whether an attribute is supported, not in the new.

Comment by Sergei Golubchik [ 2013-11-07 ]

works for me, no syntax error, the table is altered as expected.

Generated at Thu Feb 08 07:01:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.