Product: Aqua Data Studio
Version: 19.0.0-alpha-53
Build #: 54823
Build Date: 2017-Jun-21 10:07:41 PM
Operating Environment: Linux (4.4.0-81-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_102-b14
Memory: Max=704,643,072; Total=439,877,632; Free=302,069,264; CPUs=8
Steps To Reproduce:-
1. Launch ADS
2. Connect to MySQL 5.7
3. Right click on Database treenode and select Query Analyser.
4. In Query analyser Execute below Script.
Create database naresh
Go
Use naresh
Go
CREATE TABLE t1 (
c2 int(11) NULL
)
ENGINE = InnoDB
AUTO_INCREMENT = 0
GO
CREATE INDEX id_index USING BTREE
ON t1(c2)
COMMENT 'MERGE_THRESHOLD=40'
GO
5. Now Right click on the Created table and Select Tools -> Schema Script Generator.
6. In Script Generator Window, Under Object Types Select Only Tables and Select the created table Checkbox. Then Click on Next.
7. Select Preview tab in Save as option and also Make Sure "Tables: Script full table (Indexes, Triggers)" option is checked. Click on Next
Result:- Script gets generated with Index as well.
8. Click on Previous option 3 times. i.e. Move to Step 6.
9. Select all objects under Object types and Select created table. Click on Next.
Result:- You will observed that "Tables: Script full table (Indexes, Triggers)" option is available in disabled state.
10. Click on Next.
Result:-
Index script is not generated.
Expected Result:-
1. After Step 9, "Tables: Script full table (Indexes, Triggers)" option should be available in enabled state.
2. Also After Step 10, Index Script should get generated.
Observations:-
|
Behaviour in different ADS Builds
|
MySQL versions.
|
|
|
All |
|
ADS 19 alpha-53 |
Y |
|
ADS v18 |
Y |
|
Y :- Issue is reproducible |
|
N :- Issue is not reproducible |
