Derby
  1. Derby
  2. DERBY-4613

Make client driver treat BOOLEAN columns the same way as the embedded driver does.

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.6.1.0
    • Fix Version/s: 10.7.1.1
    • Component/s: SQL
    • Labels:
      None
    • Issue & fix info:
      Patch Available
    • Bug behavior facts:
      Embedded/Client difference, Seen in production, Wrong query result

      Description

      The only operation currently allowed on BOOLEAN columns is to select them from the system tables. For instance, the following query selects BOOLEAN values:

      select systemalias from sys.sysaliases;

      There are discrepancies in how the embedded and client drivers handle these BOOLEAN columns. The embedded behavior is correct and the client behavior should conform. I will attach a spec describing what needs to be done.

      1. derby-4613-01-ac-correctBehavior.diff
        33 kB
        Rick Hillegas
      2. derby-4613-01-ab-correctBehavior.diff
        29 kB
        Rick Hillegas
      3. ASF.LICENSE.NOT.GRANTED--derby-4613-fs.html
        24 kB
        Rick Hillegas

        Issue Links

          Activity

          Rick Hillegas created issue -
          Rick Hillegas made changes -
          Field Original Value New Value
          Link This issue is part of DERBY-499 [ DERBY-499 ]
          Rick Hillegas made changes -
          Attachment derby-4613-fs.html [ 12441542 ]
          Rick Hillegas made changes -
          Attachment derby-4613-01-ab-correctBehavior.diff [ 12444141 ]
          Rick Hillegas made changes -
          Assignee Rick Hillegas [ rhillegas ]
          Rick Hillegas made changes -
          Issue & fix info [Patch Available]
          Rick Hillegas made changes -
          Attachment derby-4613-01-ac-correctBehavior.diff [ 12444234 ]
          Rick Hillegas made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          Fix Version/s 10.7.0.0 [ 12314971 ]
          Rick Hillegas made changes -
          Fix Version/s 10.7.1.1 [ 12315564 ]
          Fix Version/s 10.7.1.0 [ 12314971 ]
          Gavin made changes -
          Workflow jira [ 12508218 ] Default workflow, editable Closed status [ 12800463 ]

            People

            • Assignee:
              Rick Hillegas
              Reporter:
              Rick Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development