Bug #46704 Automatically insert quotes if date inserted

• Submitted: 13 Aug 2009 19:58
• Modified: 18 Aug 2009 16:56
• Reporter: Anton Danilchenko
• Status: Won't fix
• Category: MySQL Workbench
• Severity: S2 (Serious)
• Version: 5.1.16
• OS: Linux (Ubuntu x64)
• CPU Architecture: Any

[13 Aug 2009 19:58] Anton Danilchenko

Description:
If date present as 2009-08-13 - bad, but if '2009-08-13' - this good.

P.S. Also propose to show calendar for select date or type date from keyboard.

How to repeat:
Create table with DATE column. Go to table propetries on tab "Inserts" and create new row. In opened window edit date column value. This date value not automatically quoted as string - this bad.

Suggested fix:
Automatically quote date columns as string column.
Also quote DateTime columns.

[13 Aug 2009 20:01] Anton Danilchenko

I propose not show quotes (and not insert it) into editable table. This quotes automatically insert on press OK.

[13 Aug 2009 21:24] MySQL Verification Team

Thank you for the bug report.

[17 Aug 2009 9:21] Johannes Taxacher

thanks for the report, but we decided to simplify quoting in editors to only apply quotes automatically to text-type-columns.

[18 Aug 2009 16:56] Anton Danilchenko

Please not show quotes, but automatically insert it in next step (on show sql query).