× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
shubhang.jaiswal reported 2019-01-21T07:15:05Z  · tomconrad last modified 2019-01-21T20:56:41Z

SQL Syntax error when executing create(full) auto generated query-MySQL v 8.0


Dev
Thomas Conrad
tomconrad
QA
Priority Major
Complexity Unknown
Component DB - Teradata
Version 19.5

Platform : Win 8

Connect to MySQL v 8.0 providing valid connection details

-----------------------------------------------------------------------------------------------------------

Expand Databases,expand database named 'harish'  -> expand tables -> select table 'airline' 

Right click on this table -> select 'script object to windows as' ->select Create(full)

In the window with SQL generated , change the table name to a table name which is not present in this DB

Click on execute button.

Verify if the query is successfull executed and a new table is created.

Expected:

A new table should be created.

 

Actula

User gets an error

 

Below is the sql generated

CREATE TABLE aaairline  ( 
   airline_id bigint(20) NULL,
   name       text NULL,
   iata_code  text NULL,
   icao       text NULL,
   callsign   text NULL,
   country    text NULL,
   active     text NULL 
   )
ENGINE = InnoDB
AUTO_INCREMENT = 0
GO
CREATE INDEX Unique D USING BTREE 
   ON aairline(airline_id DESC)
GO



Error post execution of query

>[Error] Script lines: 13-15 ------------------------

 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 'Unique D USING BTREE 
ON aairline(airline_id DESC)' at line 1 

 

Screenshot is attached for further reference.

2 attachments

Issue #15677

Closed
Invalid
Resolved 2019-01-21T20:55:44Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017