× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2009-09-11T19:18:09Z  · last modified 2009-09-18T22:31:01Z

Default timestamp CURRENT_TIMESTAMP Teradata


Priority Low
Complexity Unknown
Component App - Visual Editing
Version 08.0

ADS Build 8.0.0 Beta 2.13
Teradata
10.168.11.40

User - Ivan

Created a table with the following script


CREATE SET TABLE CUR_TIMESTAMP_TEST, QUEUE, FALLBACK,
NO BEFORE JOURNAL,
NO AFTER JOURNAL (
col_1 TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
col_2 INTEGER,
col_3 INTEGER)
PRIMARY INDEX (col_2, col_3)
GO

I Script back the table and then CURRENT_TIMESTAMP is changed to CURRENT  TIMESTAMP. When I try to rename the table and execute the script ADS displays error

>[Error] Script lines: 10-19 ------------------------
 [Teradata Database] [TeraJDBC 13.00.00.06] [Error 3706] [SQLState 42000] Syntax error: expected something between the 'DEFAULT' keyword and the 'Current' keyword. 


CREATE SET TABLE CUR_TIMESTAMP_TEST_2 ,
    QUEUE,
    FALLBACK,
    LOG (
    col_1    TIMESTAMP(6) FORMAT 'YYYY-MM-DDBHH:MI:SS.S(6)' NOT NULL DEFAULT Current TimeStamp(6),
    col_2    INTEGER FORMAT '-(10)9' NULL,
    col_3    INTEGER FORMAT '-(10)9' NULL
    )
GO

Issue #3137

Closed
Fixed
Resolved 2009-09-18T22:31:01Z
 
 
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