Bug #88339 Can't create datetime/timestamp with microsecond precission
Submitted: 3 Nov 2017 4:21 Modified: 3 Nov 2017 14:23
Reporter: Takim Parulasbawa Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.3.9 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[3 Nov 2017 4:21] Takim Parulasbawa
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\encarta\AppData\Roaming\MySQL\Workbench\log\wb.log]

Using table designer, i can't create any datetime/timestamp field with microsecond precisson.
I can create it using SQL script successfully, but when I alter the table using table designer, I get DDL error and lead to sql script editor.

How to repeat:
1. Create New table using table editor (gui).
2. Add a field name and put DATETIME(6) under Datatype column.
3. Click Apply
[3 Nov 2017 8:39] MySQL Verification Team
datetime 0

Attachment: 0datetime.png (image/png, text), 152.90 KiB.

[3 Nov 2017 8:40] MySQL Verification Team
datetime 1

Attachment: 1datetime.png (image/png, text), 168.74 KiB.

[3 Nov 2017 8:40] MySQL Verification Team
datetime 2

Attachment: 2datetime.png (image/png, text), 34.47 KiB.

[3 Nov 2017 8:41] MySQL Verification Team
Thank you for the bug report. See attached screenshots.
[3 Nov 2017 14:13] Takim Parulasbawa
Create new table using designer/gui

Attachment: datetime_create_gui.png (image/png, text), 53.58 KiB.

[3 Nov 2017 14:17] Takim Parulasbawa
Create new table using workbench sql script-1

Attachment: datetime_create_SQL.png (image/png, text), 42.19 KiB.

[3 Nov 2017 14:22] Takim Parulasbawa
Table is created using command line interface. Try to alter using workbench

Attachment: alter_table_using_cli.png (image/png, text), 29.61 KiB.

[3 Nov 2017 14:23] Takim Parulasbawa
Hello,
I've add screenshot of my test. I use MySQL Workbench 6.3.9