× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
abhishekj(*) reported 2014-05-03T08:57:55Z  · tariqrahiman last modified 2014-12-08T20:23:01Z

Vertica: Add Data type "long varchar" for Create Table GUI and ER Modeler


Priority Low
Complexity Unknown
Component DB - Vertica
Version 16.0
ADS Version: 15.0.0-dev-263
Build #: 37662
Build Date: 2014-May-01 05:25:32 PM
 
Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / US / Oracle Corporation 1.7.0_51-b13
Memory: Max=954,728,448;  Total=423,624,704;  Free=195,817,656;  CPUs=8
Database: Vertica 7.0.0
 
Steps to Reproduce:
 
1.Connect to Vertica Database.
 
2.Create the following Table:
 
3.  CREATE TABLE public.a1  ( 
    col1 long varchar 
      )
    GO
    
4. Go to table tree node,select table a1,right click on it and select option Tools,from Tools-->Select option ER Diagram.
 
5. From ER Diagram window select option Tables,from Object Pane select table a1
 
6.Go to Model Pane in ER -Diagram Windiw.
 
7.Select table a1,right click on it and select option Table Properties.
 
   Here it is observed that the data type "long varchar" appears to be greyed out and we cannot do any kind of operations on it.
 
    Please Refer to screenshot table_properties.jpeh
 
 
1 attachment

Issue #12030

Closed
Fixed
Resolved 2014-11-05T19:12:39Z
 
 
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