× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ivangron reported 2009-09-14T21:14:08Z  · last modified 2009-09-14T22:29:13Z

teradata checksum and SetType parsing issue


Priority Low
Complexity Unknown
Component Tools - ER Modeler
Version 08.0

In extracttable.java,

getCheckSum

getCreateSetType

: we parse the creation string to extract the value, problem is we currently parse the string into objects using " ", but you can createa table in many diffrent ways returning

strings like the following

CREATE TABLE CHECK_SUM_DEFAULT\n\tCHECKSUM = DEFAULT (\n\tQITS    TIMESTAMP(6) FORMAT 'YYYY-MM-DDBHH:MI:SS.S(6)' DEFAULT CURRENT_TIMESTAMP(6),\n\tA       CHAR(5) CHAR SET LATIN NOT NULL \n\t)

in this example you can see that the object doesn't break down into the correct peaces do to use of \n\t, in order to create a qualified parser for this we would need to know all of the possible characters that can go into the text and then create a much more complex parser to extract the correct data...

could we fill a bug for teradata to store this information somewhere in a catalog table?

Issue #3151

Closed
Fixed
Resolved 2009-09-14T22:29:13Z
 
 
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