[jira] Updated: (DERBY-4716) Enable BOOLEAN typed columns

["Rick Hillegas (JIRA)" <ji...@apache.org>]

     [ 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 me.

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: 10.6.1.0
>            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.