db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: Error 42x71:Type de donnÚes 'BOOLEAN' non valide: when doing a Create Table [table] as Select * from [otherTable] with no data
Date Thu, 06 Sep 2012 13:41:54 GMT
> 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.

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.



View raw message