Hi, I wish to report a erroneous information returned by DatabaseMetaData.getColumns() method.
This happens with ResultSet's column (7) COLUMN_SIZE and (9) DECIMAL_DIGITS , when DatabaseMetaData.getColumns() inform about a VIEW with columns formed with : coalesce , case or numeric operations over DECIMAL fields.
Suppose
CREATE TABLE A ( f1 DEC(6,3), f2 dec(6,3) ); CREATE VIEW B as ( select ( f1 + f2 ) as f from a;
Then DatabaseMetaData.getColumns() returns:
VIEW B F NUMERIC( 65535 , -65531 )
This error its very molest because if you are trying to do CodeGeneration from DatabaseMetaData.
Any suggestion will be appreciated. Best regards, Dario Fassi