Derby
  1. Derby
  2. DERBY-4720

Allow boolean-valued expressions in select lists

    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

      Description

      When the BOOLEAN datatype was disabled, the grammar was peppered with special checks to make sure that expressions like "a > 10" did not appear in the SELECT list. Perhaps this was done to reduce the number of cases in which BOOLEAN values could be materialized as columns in queries. That is, however, an unsatisfying reason because you could always materialize BOOLEAN columns by selecting from certain system tables. In any event, the SQL grammar allows these expressions in the SELECT list and we should re-enable them as part of exposing BOOLEAN as a full-fledged Derby datatype.

      I intend to re-enable these expressions per the SQL spec. If anyone knows of a reason why this should not be allowed, please speak up. Thanks.

        Issue Links

          Activity

          Rick Hillegas created issue -
          Rick Hillegas made changes -
          Field Original Value New Value
          Assignee Rick Hillegas [ rhillegas ]
          Rick Hillegas made changes -
          Affects Version/s 10.6.1.0 [ 12313727 ]
          Component/s SQL [ 11408 ]
          Rick Hillegas made changes -
          Link This issue is part of DERBY-499 [ DERBY-499 ]
          Rick Hillegas made changes -
          Rick Hillegas made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Fix Version/s 10.7.0.0 [ 12314971 ]
          Resolution Fixed [ 1 ]
          Rick Hillegas made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          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 [ 12514491 ] Default workflow, editable Closed status [ 12800461 ]

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development