Aqua Data Studio 15.0.0
Build #: 40180
Built on: 2014-Sep-11 05:33:04 PM
OS: Ubuntu 14.04
Linux (3.13.0-24-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.7.0_60-b19
Memory: Max=3,817,865,216; Total=1,762,656,256; Free=1,000,696,840; CPUs=8
Database: Sybase ASE 15.7
Issue: Sybase ASE- ER Diagram- Table column 'in row' property accepts invalid value
This issue is observed while testing Issue 12484
Please implement 'in row' validation for ER Diagram table too.
Quick steps to observe the Issue:
1. Open Attached ER Daigram file : 1.xed
2. Entity Relationship Diagram window opens, Double click on the table,
3.Table Properties window opens, select 'description' column.
In Column Parameters, 'In Row' value 17000 is shown. which is invalid value.
This 'In Row' value is not in acceptible range of 1 to 16384.
Detailed steps to reproduce the issue:
1. Connect ADS to Sybase ASE 15.7 database.
2. Open Query Analyzer, and create a table using below script
//Create Table script
create table new_titles (
title varchar (80) not null
, type char (12) null
, price money null
, pubdate datetime not null
, description text in row (300)
, notes text in row
, reviews text off row)
3. Right click on this Table, and select Tools->ER Diagram Generator
4. ER Diagram Generator window opens, select table "new_titles", Press 'Next' button.
5. Entity Relationship Diagram window opens, Double click on this table,
Table Properties window opens, select 'description' column.
In Column Parameters, 'In Row' tetbox enter value 17000, Click on 'OK' button to save the changes.
6. Again reopen this table properties, you will observe that In Row value is 17000, which is invalid value.
This 'In Row' value is not in acceptable range of 1 to 16384.
We do not perform validations like these in the ER Modeler. It is up to the discretion of the user to supply the correct range and values. Basically, we do not have restrictions on what values, user enters. Once they generate the SQL script and execute in the database, it will return the correct error message.
You can try in Oracle -> New ER Model -> 12c -> Create a new table and then go to storage and enter String data in the PCTFREE and INITRANS