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

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

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.6.1.0
    • 10.7.1.1
    • SQL
    • None
    • Patch Available
    • 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.

      Attachments

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

        Issue Links

          Activity

            People

              rhillegas Richard N. Hillegas
              rhillegas Richard N. Hillegas
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: