Bug #5966 Table Editor: Invalid SQL syntax for CREATE TABLE with PASSWORD option
Submitted: 7 Oct 2004 21:23 Modified: 5 Nov 2004 23:51
Reporter: Shuichi Tamagawa Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.0.7-beta OS:Windows (Win XP / SP2)
Assigned to: Michael G. Zinner CPU Architecture:Any

[7 Oct 2004 21:23] Shuichi Tamagawa 
Description:
When you create a table with PASSWORD  option it fails because of syntax error. The entered password is not quoted in the executed SQL.

How to repeat:
Right click in the 'Schemata' area and select 'Create New table'.
Enter table name, column name and type.
Click 'Advanced Options' tab.
Enter some characters in 'Table password'.
Click 'Apply changes'.

-> Syntax Error

Suggested fix:
The password should be quoted in the generated SQL.
[8 Oct 2004 12:11] MySQL Verification Team 
Verified with version 1.0.8
[5 Nov 2004 23:51] Michael G. Zinner 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html