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: | |
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
[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