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

Columns of type 'SMALLINT' cannot hold values of type 'BOOLEAN'

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.10.1.1
    • Fix Version/s: 10.10.2.0
    • Component/s: Store
    • Labels:
      None
    • Environment:
      NA
    • Urgency:
      Normal

      Description

      This minor issue is in relation to a bug at Liquibase (https://liquibase.jira.com/browse/CORE-1088) that occurred due to the addition of the boolean type.

      Prior to the boolean type I am assuming that just about everyone would resort to using smallint.Older databases that may have been machine created based on meta-data are not going to be compatible with future code that will now assume boolean is the norm.

      The improvement I am suggesting is that when smallint columns are fed a boolean value that '1' is accepted as 'true' and anything else 'false' (0 would be a good idea), and likewise for retrieval. Although technically correct, throwing an exception seems to be a touch aggressive here as smallint is more than capable of storing a bit.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              andyg Andy Gumbrecht
            • Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: