× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
swapnil.chaudhari(*) reported 2014-02-25T05:07:51Z  · tariqrahiman last modified 2014-03-05T20:31:37Z

In ER diagram, table properties are uneditable for table having column with "text" datatype for Teradata Aster


Priority Low
Complexity Unknown
Component Tools - ER Modeler
Version 14.0
Aqua Data Studio 14.0.8
Build #: 35460
Built on: 2014-Jan-09 08:51:14 AM     
 
Database: Teradata Aster 6
Windows 7:64 bit
 
Step 1: Connect to Teradata Aster 6
 
Step 2: Create a table having column with text datatype.
CREATE TABLE "public"."text_table"  ( 
"col1" varchar(25) NULL,
"col2" int NULL,
"col3" text NULL 
)
DISTRIBUTE BY REPLICATION
STORAGE ROW
GO
 
Step 3:
Right click on "text_table"
Select option "Tools"
Select option "ER Diagram Generator"
"ER Diagram Generator" window opened
Select "text_table"-> Click NEXT
ER diagram generated for "text_table"
 
Step 4: 
Right click on ER diagram of "text_table"
Select "Properties" option
Table properties window opened
 
Step 5: 
Try to make any changes in table (say, add column)
Switch to sql preview tab.
It gives error: /* Column 'col3': invalid length. */
 
Therefore, In ER diagram, we can not make any changes in table having "text" datatype.
This is because, Aster treats text datatype as varchar of undefined length.
1 attachment

Issue #11767

Closed
Fixed
Resolved 2014-02-27T23:44:26Z
 
 
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