MySQL Bugs: #76518: Error Parsing DDL: support of third-party ROW

Bug #76518	Error Parsing DDL: support of third-party ROW_FORMATS
Submitted:	28 Mar 2015 10:37	Modified:	13 Apr 2015 10:16
Reporter:	Mykola Ulianytskyi	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.3.2	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
Hello

1. Select table on Schemas panel
2. Alter Table...
3. Error:

Error Parsing DDL for `manuals`.`manuals`
There was an error while parsing the DDL retrieved from the server.
Do you want to view the DDL or cancel processing it?

CREATE TABLE `docs` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
 ...
) ENGINE=TokuDB AUTO_INCREMENT=9954 DEFAULT CHARSET=latin1 ROW_FORMAT=TOKUDB_LZMA$$

Please add support of third-party TokuDB row_formats (TOKUDB_LZMA, TOKUDB_ZLIB, TOKUDB_QUICKLZ, TOKUDB_UNCOMPRESSED).

Thank you!

--
With best regards,
Mykola

How to repeat:
Always

Hello!

Thank you for the report.

Thanks,
Umesh

TokuDB support patch

Attachment: mysql-workbench-community-6.3.2-tokudb.patch (text/x-patch), 13.54 KiB.

Hi

I have written a small patch for MySQL Workbench 6.3.2.

It adds TokuDB support to mysql.parser (grammar) and sql.parser.

The patch doesn't change Table Editor's GUI.

Please include it to Workbench.

Thank you

# tar -xvzf mysql-workbench-community-6.3.2-src.tar.gz
# cd mysql-workbench-community-6.3.2-src
# patch -p1 < ../mysql-workbench-community-6.3.2-tokudb.patch

# pushd library/sql.parser
# bash generate_parser
# popd

# cmake ...

--
With best regards,
Mykola Ulianytskyi

"library/sql.parser/Parser generation course.txt" was used as hint for patch creation.

If the support for TokuDB requires a language extension which is not compatible with MySQL then we cannot add it. Such a table definition wouldn't even run successfully against a MySQL server. And MySQL Workbench only works for MySQL servers, hence the name.