Sorry, it's a bug in the CREATE AS SELECT. For now you'll have to CREATE the second table manually and INSERT into it as you loop throught the SELECT on the first table. I'll look into a fix.