[ https://issues.apache.org/jira/browse/DERBY-2605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas closed DERBY-2605. -------------------------------- > 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: 10.3.1.4 > Reporter: Rick Hillegas > Assignee: James F. Adams > Fix For: 10.3.1.4 > > Attachments: d2605_inc_v1.patch, d2605_v1.patch, d2605_v1.stat, > d2605_v2.patch, d2605_v2.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.