Start a new topic

Invalid DDL with long column names on Informix

[This topic is migrated from our old forums. The original author name has been removed]

There is a problem with DDL generation on Informix when using checks and longer column names. For example, if the following table is created: CREATE TABLE test ( abcdefghijklmno CHAR(1), CHECK (abcdefghijklmno IN ('Y' ,'N' )) ); Then the DDL generated by DbVisualizer looks like: CREATE TABLE test ( abcdefghijklmno CHAR(1), CHECK (abcdefghijklmno IN ('Y' ,'N' )), CHECK ( ) ) Which is obviously wrong. As you add more characters to the column name, all sorts of interesting things get generated in the DDL. :) In this example, the issue does not appear for column names shorter than 15 characters (i.e. abcdefghijklmn works fine). Environment: Informix 11.50.uc5 IBM Informix JDBC Driver 3.50.JC2 DbVisualizer 7.0.4 Windows XP Regards, Ivan

[This reply is migrated from our old forums. The original author name has been removed]

Re: Invalid DDL with long column names on Informix
I can confirm the fix, the DDL looks fine now. Regards, Ivan
[This reply is migrated from our old forums.]

Re: Invalid DDL with long column names on Informix
Hi, This is now fixed in the 7.0.5 version. Best Regards Roger
[This reply is migrated from our old forums.]

Re: Invalid DDL with long column names on Informix
Hi Ivan, Thanks for reporting this. It will be fixed in the next maintenance release. Best Regards, Hans