Return
-
Title
Vertica table script is showing an IDENTITY column as an INTEGER -
Description
When viewing the script for a table in a Vertica database, an IDENTITY column is being scripted as INTEGER NOT NULL.Example:1. CREATE TABLE TEST001(ID IDENTITY(1,1),C_1 VARCHAR(25))2. After creating, go to View Details of the table TEST001, the generated script is not correct as below.CREATE TABLE TEST001(ID INTEGER NOT NULL,C_1 VARCHAR (25)) -
Cause
-
Resolution
WORKAROUND
Copy script to Editor and edit accordingly
STATUS
Waiting for fix in a future release of Toad Data Point
-
Defect ID
QAT-13468