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
same problem with CURRENT_DATE
AFSystemTypeInfo.java is handling the defaultvalue correction. will need some testing currently handling what I could find in the docs...
AFSystemTypeInfo.java is handling the defaultvalue correction. will need some testing currently handling what I could find in the docs...
Issue #3137 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
same problem with CURRENT_DATE