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] Created: (DERBY-4720) Allow boolean-valued expressions in select lists
Date Mon, 28 Jun 2010 19:55:49 GMT
Allow boolean-valued expressions in select lists

                 Key: DERBY-4720
                 URL: https://issues.apache.org/jira/browse/DERBY-4720
             Project: Derby
          Issue Type: Improvement
            Reporter: Rick Hillegas

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.

View raw message