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

Reference Manual gives incorrect datatype for SYSCOLUMNS.COLUMNNAME

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment