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. thanks, bryan
