Derby
  1. Derby
  2. DERBY-1742

SYSTEMALIAS column of type BOOLEAN in SYS.SYSALIASES is created with the incorrect maximun length of 0

    Details

    • Type: Task Task
    • Status: Open
    • Priority: Trivial Trivial
    • Resolution: Unresolved
    • Affects Version/s: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1
    • Fix Version/s: None
    • Component/s: SQL
    • Urgency:
      Normal

      Description

      Boolean type's correct maximum width is 1.

      Seen by the COLUMN_SIZE column from DatabaseMetaData.getColumns returning 0 instead of 1.

      Caused by passing a 0 instead of a 1 in SYSAliasesRowFactory, will be fixed by DERBY-1734, which stops
      code like this passing in information that is redundant (and hence a chance for it to be wrong).

      Don't believe ir has any affect on the runtime behaviour of the system, adding this issue to investigate if an upgrade fix is required
      or just leave it at the wrong value for old databases.

        Issue Links

          Activity

          Daniel John Debrunner created issue -
          Daniel John Debrunner made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-1745 [ DERBY-1745 ]
          Hide
          Knut Anders Hatlen added a comment -

          Triaged for 10.5.2. Description says that it is an investigation, so changing issue type from Bug to Task.

          Show
          Knut Anders Hatlen added a comment - Triaged for 10.5.2. Description says that it is an investigation, so changing issue type from Bug to Task.
          Knut Anders Hatlen made changes -
          Issue Type Bug [ 1 ] Task [ 3 ]
          Urgency Normal
          Mamta A. Satoor made changes -
          Labels derby_triage10_11
          Gavin made changes -
          Workflow jira [ 12382144 ] Default workflow, editable Closed status [ 12801782 ]

            People

            • Assignee:
              Unassigned
              Reporter:
              Daniel John Debrunner
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:

                Development