CREATE TABLE AS SELECT statement doesn't respect NOT NULL constraint

[shawnzhu]

Given table with any column contains NOT NULL constraint
When trying to create a new table via statement CREATE TABLE AS SELECT
Then the create table contains the very column but no constraint NOT NULL