db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James F. Adams (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2605) You can create BOOLEAN columns in 10.3
Date Sun, 13 May 2007 17:37:15 GMT

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

James F. Adams updated DERBY-2605:

    Attachment: d2605_v1.stat

Attached is a patch that addresses the ability to create columns where the data type of the
column is currently for internal use or otherwise not exposed to the user.

I added an isInternalTypeId method to TypeId and defined the following types as being for
internal use:


CreateTableNode was updated to use this method to check the data type of each column.
A new message was added.
A new test was added.

This patch does not address the situation with the VALUES statement desribed by Army.  I am
wondering if the VALUES statement should even be allowed to create rows with invalid decimal

> You can create BOOLEAN columns in 10.3
> --------------------------------------
>                 Key: DERBY-2605
>                 URL: https://issues.apache.org/jira/browse/DERBY-2605
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions:
>            Reporter: Rick Hillegas
>         Assigned To: James F. Adams
>         Attachments: d2605_v1.patch, d2605_v1.stat
> The work on DERBY-64 seems to have opened up a wormhole by which you can create user
tables with BOOLEAN columns. The following script shows how to do this:
> drop table foo;
> create table foo
> as select systemalias from sys.sysaliases with no data;
> rename column foo.systemalias to boolcol;
> alter table foo
>   alter column boolcol null;
> select c.columndatatype
> from sys.syscolumns c, sys.systables t
> where t.tableid=c.referenceid
> and t.tablename='FOO';
> insert into foo( boolcol )
> values
> ( 0 ),
> ( 1 ),
> ( cast (null as int) )
> ;
> select * from foo;

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

View raw message