Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6129

Reference Manual gives incorrect datatype for SYSCOLUMNS.COLUMNNAME

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.10.1.1
    • 10.10.2.0
    • Documentation
    • 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;

      Attachments

        1. DERBY-6129.diff
          2 kB
          Camilla Haase
        2. DERBY-6129.stat
          0.2 kB
          Camilla Haase
        3. DERBY-6129.zip
          8 kB
          Camilla Haase
        4. systables.txt
          15 kB
          Camilla Haase

        Activity

          People

            chaase3 Camilla Haase
            rhillegas Richard N. Hillegas
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: