Derby
  1. Derby
  2. DERBY-499

Expose BOOLEAN datatype to end users

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.1.1.0
    • Fix Version/s: 10.7.1.1
    • Component/s: SQL
    • Labels:
      None

      Description

      Veaceslav Chicu started an email thread on 8 August 2005 titled "boolean type". He was disappointed that Derby doesn't support the ansi BOOLEAN datatype. On closer inspection, Derby does internally support this type but does not expose this support to end users.

      Derby should let users declare table columns of type BOOLEAN. This should be an indexable datatype.

      1. BooleanFS.html
        81 kB
        Rick Hillegas
      2. BooleanType.html
        30 kB
        Rick Hillegas
      3. BooleanType.sxw
        12 kB
        Rick Hillegas
      4. BooleanType.html
        30 kB
        Rick Hillegas
      5. BooleanType.sxw
        12 kB
        Rick Hillegas
      6. bug499_jdk13tests_rev2.diff
        693 kB
        Rick Hillegas
      7. bug499_jdk13tests.diff
        697 kB
        Rick Hillegas
      8. jdk131BooleanFailures.zip
        67 kB
        Kathey Marsden
      9. bug499_rev4.diff
        254 kB
        Rick Hillegas
      10. bug499_rev3.diff
        254 kB
        Rick Hillegas
      11. bug499_rev2.diff
        254 kB
        Rick Hillegas
      12. bug499.diff
        254 kB
        Rick Hillegas
      13. bug499_doc.zip
        583 kB
        Rick Hillegas
      14. BooleanFS.html
        8 kB
        Rick Hillegas

        Issue Links

          Activity

          Gavin made changes -
          Workflow jira [ 12323179 ] Default workflow, editable Closed status [ 12802274 ]
          Gavin made changes -
          Link This issue is depended upon by DERBY-2651 [ DERBY-2651 ]
          Gavin made changes -
          Link This issue blocks DERBY-2651 [ DERBY-2651 ]
          Rick Hillegas made changes -
          Fix Version/s 10.7.1.1 [ 12315564 ]
          Fix Version/s 10.7.1.0 [ 12314971 ]
          Rick Hillegas made changes -
          Status Open [ 1 ] Closed [ 6 ]
          Fix Version/s 10.7.0.0 [ 12314971 ]
          Resolution Fixed [ 1 ]
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-4737 [ DERBY-4737 ]
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-4730 [ DERBY-4730 ]
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-4720 [ DERBY-4720 ]
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-4716 [ DERBY-4716 ]
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-4714 [ DERBY-4714 ]
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-4704 [ DERBY-4704 ]
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-4703 [ DERBY-4703 ]
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-4692 [ DERBY-4692 ]
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-4684 [ DERBY-4684 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-4663 [ DERBY-4663 ]
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-4659 [ DERBY-4659 ]
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-4658 [ DERBY-4658 ]
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-4657 [ DERBY-4657 ]
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-4613 [ DERBY-4613 ]
          Rick Hillegas made changes -
          Link This issue incorporates DERBY-4583 [ DERBY-4583 ]
          Dag H. Wanvik made changes -
          Issue Type New Feature [ 2 ] Improvement [ 4 ]
          Jørgen Løland made changes -
          Link This issue blocks DERBY-2651 [ DERBY-2651 ]
          Rick Hillegas made changes -
          Attachment BooleanFS.html [ 12356975 ]
          Andrew McIntyre made changes -
          Fix Version/s 11.0.0.0 [ 12312083 ]
          Rick Hillegas made changes -
          Attachment BooleanType.html [ 12341983 ]
          Rick Hillegas made changes -
          Attachment BooleanType.sxw [ 12341974 ]
          Rick Hillegas made changes -
          Fix Version/s 11.0.0.0 [ 12312083 ]
          Rick Hillegas made changes -
          Assignee Rick Hillegas [ rhillegas ]
          Rick Hillegas made changes -
          Link This issue relates to DERBY-1029 [ DERBY-1029 ]
          Rick Hillegas made changes -
          Attachment BooleanType.html [ 12334246 ]
          Rick Hillegas made changes -
          Attachment BooleanType.sxw [ 12334245 ]
          Kathey Marsden made changes -
          Link This issue is blocked by DERBY-887 [ DERBY-887 ]
          Kathey Marsden made changes -
          Link This issue is blocked by DERBY-877 [ DERBY-877 ]
          Kathey Marsden made changes -
          Link This issue is blocked by DERBY-877 [ DERBY-877 ]
          Rick Hillegas made changes -
          Attachment bug499_jdk13tests_rev2.diff [ 12321941 ]
          Rick Hillegas made changes -
          Attachment bug499_jdk13tests.diff [ 12321845 ]
          Kathey Marsden made changes -
          Comment [ There are two failures in jdk131 that I think might be related to the patch for this issue.

          The change is that with queries on the sytem tables, before the patch the output had "true"/"false" and now it is "1"/"0".
           I'll attach test output for evaluation.

          derbyall/derbynetclientmats/derbynetmats.fail:jdbcapi/metadata.java
          derbyall/derbynetclientmats/derbynetmats.fail:lang/syscat.sql

          ]
          Kathey Marsden made changes -
          Attachment jdk131BooleanFailures.zip [ 12321796 ]
          Rick Hillegas made changes -
          Attachment bug499_rev4.diff [ 12321479 ]
          Rick Hillegas made changes -
          Attachment bug499_rev3.diff [ 12321472 ]
          Rick Hillegas made changes -
          Attachment bug499_rev2.diff [ 12321468 ]
          Rick Hillegas made changes -
          Attachment bug499.diff [ 12321397 ]
          Rick Hillegas made changes -
          Attachment bug499.diff [ 12321268 ]
          Rick Hillegas made changes -
          Attachment bug499.diff [ 12321268 ]
          Rick Hillegas made changes -
          Attachment bug499.diff [ 12321218 ]
          Rick Hillegas made changes -
          Attachment bug499.diff [ 12321218 ]
          Rick Hillegas made changes -
          Attachment bug499.diff [ 12321174 ]
          Rick Hillegas made changes -
          Attachment bug499_doc.zip [ 12321190 ]
          Rick Hillegas made changes -
          Attachment bug499.diff [ 12321174 ]
          Rick Hillegas made changes -
          Attachment BooleanFS.html [ 12321106 ]
          Rick Hillegas made changes -
          Attachment BooleanFS.html [ 12320832 ]
          Rick Hillegas made changes -
          Attachment BooleanFS.html [ 12320832 ]
          Mike Matrigali made changes -
          Component/s SQL [ 11408 ]
          Rick Hillegas made changes -
          Field Original Value New Value
          Assignee Rick Hillegas [ rhillegas ]
          Rick Hillegas created issue -

            People

            • Assignee:
              Unassigned
              Reporter:
              Rick Hillegas
            • Votes:
              16 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development