Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
10.10.1.1
-
None
-
Normal
Description
The Reference Manual says that SYSCOLUMNS.COLUMNNAME has datatype CHAR(128). It's actual datatype is VARCHAR(128). It's probably worth running the following script to confirm the datatypes of all catalog columns described by the Reference Manual:
connect 'jdbc:derby:memory:db;create=true';
select cast(t.tablename as varchar( 20 )), cast(c.columnname as varchar(20)), c.columndatatype
from sys.syscolumns c, sys.systables t
where t.tablename like 'SYS%'
and t.tableid = c.referenceid
order by t.tablename, c.columnname;