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-64-generic, amd64) / UTF-8 / en / US / Oracle Corporation 1.8.0_102-b14
Memory: Max=704,643,072; Total=445,644,800; Free=257,882,968; CPUs=8
Connect Mysql-5.7
Create table with ENGINE = CSV
CREATE TABLE `test_engine_csv` (
`c1` bigint(20) NOT NULL,
`c2` text NOT NULL
)
ENGINE = CSV
CHARACTER SET `utf8`
COLLATE `utf8_general_ci`
AUTO_INCREMENT = 0
GO
Scenario-01
Steps-
Right click on table [test_engine_csv] and select Tools->ER diagram generator.
Select the table and click on next button.
Entity Relationship diagram window opens
In ER,Right click table [test_engine_csv]
Actual Result:
You can see that,New Index,New relationship,New primary key,New Unique key option is enabled for CSV table.
Expected Result:
Add constraint and New Index options should be disabled for CSV table.
Scenario-02
Steps-
Right click on table [test_engine_csv] and select Tools->ER diagram generator.
Select the table and click on next button.
Entity Relationship diagram window opens
Right click on table and select Table Properties option
Table properties window opens
Scenario-02
Actual Result:
You can see that Allow Null option is enabled for CSV table.
Expected Result:
Allow Null option should be disabled for CSV table.
N-issue is not reproduced.