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-2605) You can create BOOLEAN columns in 10.3
Date Thu, 03 May 2007 14:51:15 GMT
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

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 )
( 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