db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Closed: (DERBY-4720) Allow boolean-valued expressions in select lists
Date Tue, 13 Jul 2010 19:00:57 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Rick Hillegas closed DERBY-4720.
--------------------------------


> Allow boolean-valued expressions in select lists
> ------------------------------------------------
>
>                 Key: DERBY-4720
>                 URL: https://issues.apache.org/jira/browse/DERBY-4720
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.6.1.0
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>             Fix For: 10.7.0.0
>
>         Attachments: derby-4720-01-ac-allowBooleanExpressions.diff
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message