On 9/6/12 9:41 AM, Bryan Pendleton wrote:
So the 'boolean' word definately works, just not in the instance of a
create table as statement.
Yes, that sounds like a bug. Boolean has recently been added to the
DDL language, and this might have been missed.
Right, I agree with Bryan that this is a bug. This limitation was put in
when CREATE TABLE AS SELECT was added. At that time, the BOOLEAN
datatype was still disabled for user tables. Without this limitation,
people could have created user tables with BOOLEAN columns by issuing a
CREATE TABLE AS SELECT against a system table with a BOOLEAN column. I
have logged https://issues.apache.org/jira/browse/DERBY-5918 to track
this issue. I think it should be easy to fix. Thanks for finding this
bug, David.
Regards,
-Rick
Did you try searching JIRA to see if it's a known bug? If not, please
log a bug with your reproduction script.
What else can I now do?
Did you try doing CREATE TABLE first, followed by INSERT INTO newtable
SELECT FROM oldtable?
If INSERT ... SELECT has the same bug, then you'll probably have to
write a short program to do the processing yourself.
thanks,
bryan
