MySQL Bugs: #76649: Missing modeling preference option "Default Target MySQL Version"

Bug #76649	Missing modeling preference option "Default Target MySQL Version"
Submitted:	10 Apr 2015 8:07	Modified:	10 Apr 2015 12:20
Reporter:	Thomas D	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.2.40	OS:	Linux (3.18.0-kali3-amd64)
Assigned to:		CPU Architecture:	Any
Tags:	missing, modeling, option, target, version

Description:
I am affected by the bug #70125 which makes it impossible to use for instance TIME(N) where N is an integer.

I saw that this bug could be fixed by going into the preferences, and in the tab "Model: MySQL", to change the option "Default Target MySQL Version" to 5.6.

However, this option doesn't appear in my preferences. The only option I have in the tab "Model: MySQL" is a drop down list for selecting the Default Storage Engine, nothing else.

I also looked in all the other tabs, and there is no mention of the SQL Version. According to the documentation (http://dev.mysql.com/doc/workbench/en/wb-preferences-modeling.html), there should be the option "Default Target MySQL Version" in the "Model: MySQL" tab.

How to repeat:
This query runs fine even though the third line is flagged with a syntax error:

CREATE TABLE ParsedLog (
LogDay DATE,
LogTime TIME(3), -- syntax error here
LogType VARCHAR(255),
ClientId VARCHAR(255),
UserId VARCHAR(255)
);

After the table is created, right-clicking on it and selecting "Alter table..." results in the error:

"Error Parsing DDL for `TEST`.`ParsedLog`
There was an error parsing the DDL retrieved from the DBMS."

However, when using TIME instead of TIME(3), it works fine.

Opening the preferences from the "Edit" menu, under the tab "Model: MySQL, the only option available is a drop down list for selecting the Default Storage Engine. There is no way to set the Default Target MySQL Version to 5.6, unlike what is depicted in the documentation (http://dev.mysql.com/doc/workbench/en/wb-preferences-modeling.html).

Here is what I see in the preference tab

Attachment: Untitled.png (image/png, text), 17.30 KiB.

Thank you for the report.
But version 5.2.40 is very old and many bugs were fixed since. Please upgrade to current version 6.2.5/6.3.2, try with it and inform us if problem
still exists. If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

I'm on Kali linux, which is based on Debian Wheezy, and it seems that version 5.2.40 is the latest available (https://packages.debian.org/wheezy/database/mysql-workbench)