Bug #90827 create table wizard has incorrect "CREATE TABLE" sql
Submitted: 11 May 2018 2:32 Modified: 14 May 2018 11:57
Reporter: Moses Moore Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.11 OS:Linux (Ubuntu 18.04 x86_64)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[11 May 2018 2:32] Moses Moore
Description:
The "Create Table Like..." example tables are missing data types for the columns. 

22:21:41 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: There was an error while applying the SQL script to the database.
22:21:41 [ERR][  GRTDispatcher]: worker: task 'wizard task' has failed with error:.There was an error while applying the SQL script to the database.
22:21:50 [DB1][      SqlEditor]: Auto saving workspace
22:22:00 [ERR][SQL Editor Form]: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time`  NULL)' at line 2
SQL Statement:
CREATE TABLE `test`.`timestamps` (
  `create_time`  NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time`  NULL)

How to repeat:
1. Connect to any database.
2. In 'Schemas' sidebar, under any database, right-click on 'Tables' item.
3. choose "Create Table Like..." and choose any of "timestamps", "user" or "category".
4. Click "apply" to create new table, get error message.

Suggested fix:
Update the three 'wizard task' example tables to include appropriate data types.
[11 May 2018 11:48] Chiranjeevi Battula
Hello Moses Moore,

Thank you for the bug report.
I could not repeat the issue at our end using with MySQL workbench 8.0.11 version.
Could you please provide repeatable steps (exact steps, screenshots etc. - please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.
[11 May 2018 11:49] Chiranjeevi Battula
Screenshot

Attachment: Bug_90827.PNG (image/png, text), 91.27 KiB.

[11 May 2018 11:49] Chiranjeevi Battula
Screenshot

Attachment: Bug_90827_1.PNG (image/png, text), 88.05 KiB.

[11 May 2018 14:38] Moses Moore
please remove other attached image

Attachment: workbench_wizard_problem_fullsize.png (image/png, text), 369.93 KiB.

[14 May 2018 11:57] Chiranjeevi Battula
Hello Moses Moore,

Thank you for the feedback.
I could not repeat the issue at our end using with MySQL workbench 8.0.11 version.
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.

Thanks,
Chiranjeevi.