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] Updated: (DERBY-4716) Enable BOOLEAN typed columns
Date Sat, 26 Jun 2010 16:07:50 GMT

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

Rick Hillegas updated DERBY-4716:

    Attachment: derby-4716-01-ab-enableBooleanColumns.diff

Attaching derby-4716-01-ab-enableBooleanColumns.diff. This is the first increment of enabling
BOOLEAN-typed columns in tables. This patch supports the ability to declare BOOLEAN columns
in CREATE TABLE statements and verifies that casting semantics are correct for INSERTs. Follow-on
patches should address ALTER TABLE and index creation. Regression tests passed cleanly for

One oddity which will have to be addressed in a follow-on patch is this:

1) If you select from an unindexed BOOLEAN column, NULLs sort at the end, as they do for other
Derby datatypes.

2) But if you put an index on the BOOLEAN column, this causes NULLs to sort before other values.

BOOLEAN-valued indexes should follow the sorting conventions of other datatypes. There should
be no backward compatibility issues here because none of the system indexes carry BOOLEAN
columns today.

Touches the following files:


M      java/engine/org/apache/derby/impl/sql/compile/sqlgrammar.jj

Allows BOOLEAN as a column data type. Removes scaffolding put in at the beginning of 10.7
development. That scaffolding added a parameter to the dataTypeDDL() production so that we
could incrementally enable BOOLEAN in different parts of the syntax without enabling BOOLEAN
wholesale everywhere. That parameter is now removed. As of this patch, BOOLEAN is allowed
everywhere that the other system datatypes are allowed--provided that the database level is
10.7 or higher.


M      java/testing/org/apache/derbyTesting/functionTests/tests/lang/BooleanValuesTest.java

Tests for INSERTing various datatypes into BOOLEAN columns.


M      java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/ParameterMetaDataJdbc30Test.java

ParameterMetaData test for INSERTs into BOOLEAN-valued columns.


M      java/testing/org/apache/derbyTesting/functionTests/master/db2Compatibility.out

Canon change because BOOLEAN columns are supported now.

> Enable BOOLEAN typed columns
> ----------------------------
>                 Key: DERBY-4716
>                 URL: https://issues.apache.org/jira/browse/DERBY-4716
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions:
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>         Attachments: derby-4716-01-ab-enableBooleanColumns.diff
> Allow tables to have boolean columns.

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

View raw message