Issue Bug Closed

#21616Columns with NOT NULL are created as NULLABLE

Xavier Perseguers 11/19/09, 13:36 updated 11/20/09, 11:23

Description

Extract:

CREATE TABLE cache_pages (
id int(11) unsigned NOT NULL auto_increment,
hash varchar(32) DEFAULT ‘’ NOT NULL,
page_id int(11) unsigned DEFAULT ‘0’ NOT NULL,
…
) ENGINE=InnoDB;

Column id is created as NOT NULL but hash and page_id are created without flag NOT NULL.

(issue imported from #M12670)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.