Bug #109499 cannot create tables due to an error when executing SQL query.
Submitted: 29 Dec 2022 18:10 Modified: 30 Jan 2023 6:44
Reporter: Ransika Jayasooriya Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.29 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: MySQL Verification Team CPU Architecture:Any
Tags: WBBugReporter

[29 Dec 2022 18:10] Ransika Jayasooriya
Description:
23:15:01 [INF][        WQE.net]: SQL IDE UI is ready
23:15:21 [ERR][SQL Editor Form]: Unable to create db_mgmt_SSHConnectionRef object
23:15:51 [INF][ Canvas backend]: Found OpenGL version for this view: 4.5.0 - Build 25.20.100.6518
23:16:55 [INF][            grt]: Fetching schema list.	
23:16:55 [INF][            grt]: OK	
23:16:56 [INF][DbMySQLSQLExport]: 
SQL Script Export Completed
23:16:57 [INF][            grt]: Executing SQL script in server	
23:16:57 [ERR][            grt]: 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 ')
ENGINE = InnoDB' at line 5
SQL Code:
        -- -----------------------------------------------------
        -- Table `stuep`.`admin`
        -- -----------------------------------------------------
        CREATE TABLE IF NOT EXISTS `stuep`.`admin` (
        )
        ENGINE = InnoDB
	
23:16:57 [INF][            grt]: SQL script execution finished: statements: 5 succeeded, 1 failed
	
23:16:57 [INF][            grt]: Fetching back view definitions in final form.	
23:16:57 [INF][            grt]: Nothing to fetch	
23:18:07 [INF][            grt]: Executing SQL script in server	
23:18:07 [ERR][            grt]: 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 ')
ENGINE = InnoDB' at line 5
SQL Code:
        -- -----------------------------------------------------
        -- Table `stuep`.`admin`
        -- -----------------------------------------------------
        CREATE TABLE IF NOT EXISTS `stuep`.`admin` (
        )
        ENGINE = InnoDB
	
23:18:07 [INF][            grt]: SQL script execution finished: statements: 5 succeeded, 1 failed
	
23:18:07 [INF][            grt]: Fetching back view definitions in final form.	
23:18:07 [INF][            grt]: Nothing to fetch	
23:21:37 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: There was an error while applying the SQL script to the database.
23:21:37 [ERR][  GRTDispatcher]: worker: task 'wizard task' has failed with error:.There was an error while applying the SQL script to the database.
23:22:35 [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 ')' at line 2
SQL Statement:
CREATE TABLE `sep`.`admin` (
)

23:26:13 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: There was an error while applying the SQL script to the database.
23:26:13 [ERR][  GRTDispatcher]: worker: task 'wizard task' has failed with error:.There was an error while applying the SQL script to the database.
23:26:26 [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 ')' at line 2
SQL Statement:
CREATE TABLE `mirka`.`falcons` (
)

23:26:38 [INF][SQL Editor Form]: Opened connection 'Local instance MySQL80' to MySQL Community Server - GPL version 8.0.29
23:34:12 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: There was an error while applying the SQL script to the database.
23:34:12 [ERR][  GRTDispatcher]: worker: task 'wizard task' has failed with error:.There was an error while applying the SQL script to the database.
23:34:42 [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 ')' at line 2
SQL Statement:
CREATE TABLE `sep`.`admin` (
)

How to repeat:
I cannot create any Tables due to this bug.
[30 Dec 2022 6:44] MySQL Verification Team
Hello Ransika,

Thank you for the bug report.
Could you please provide create table statements to reproduce this issue at our end?

Regards,
Ashwini Patil
[31 Jan 2023 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".