db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "A B (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2605) You can create BOOLEAN columns in 10.3
Date Thu, 17 May 2007 23:27:16 GMT

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

A B updated DERBY-2605:
-----------------------

       Derby Info:   (was: [Patch Available])
    Fix Version/s: 10.3.0.0

Thank you for the updated patch, James.  It looks good to me.  I ran derbyall and suites.All
on SUSE Linux with no new failures, so I went ahead and committed d2605_v2.patch with svn
commit #  539164:

  URL: http://svn.apache.org/viewvc?view=rev&rev=539164

I can't tell from the comments if there is another patch coming or not, so I'm not marking
this issue as "resolved" yet.  If you are done, please feel free to resolve it on your own...

Thanks again for addressing this issue!

> 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.0.0
>            Reporter: Rick Hillegas
>         Assigned To: James F. Adams
>             Fix For: 10.3.0.0
>
>         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.


Mime
View raw message