#545 default value not returned for column with default value

[Rob Manning]

DatabaseMetaData.getColumns(...) returns null for a column in a table that has a default value. I discovered this while using he SQuirreL SQL Client and compared it to the Sybase ASE 15 driver (both were connected to the same database and catalog, viewing the same table definition). The following table definition was used:

drop table TESTDEFAULT
GO

CREATE TABLE TESTDEFAULT
(
mycol int DEFAULT 0 NOT NULL
)
GO

Rob

[Rob Manning]

SQuirreL SQL Client with two sessions (top=Sybase; bottom=jTDS)

[Rob Manning]

Logged In: YES
user_id=1287991
Originator: YES

File Added: jtds_defval_metadata_bug.png

[momo]

Thank you for reporting this error. It only applies to ASE, for MS servers jTDS provides correct default values.