Product: Aqua Data Studio
Version: 19.0.0-alpha-49
Build #: 54803
Build Date: 2017-Jun-20 05:00:19 PM
Operating Environment: Linux (4.4.0-64-generic, amd64) / UTF-8 / en / US / Oracle Corporation 1.8.0_102-b14
Memory: Max=704,643,072; Total=469,237,760; Free=331,499,680; CPUs=8
Connect Mysql-5.7
Create table
CREATE TABLE `Test_Auto` (
`c1` bigint(20) NOT NULL,
`c2` text NOT NULL
)
Go
Steps:
Go to table tree node
Right click on Created table `Test_Auto` and select Alter table option.
Alter tab opens
Select `c1` column
Go to options and Select identity "YES"
Go to constraint tab and apply primary key on `c1` column.
Switch to preview SQL tab
Actual Result:
You can see that "Add primary key" script is generated after "Add Auto_increament" script.
Click on Alter button
Displayed error message "Incorrect table definition; there can be only one auto column and it must be defined as a key"
Expected Result:
"Add primary key" script is generated before "Add Auto_increament" script.
NOTE:
A constraint is mandatory for Auto_increament in mysql.
N-issue is not reproduced.