#19923Table definition in cache_treelist not compliant with MySQL 5.0 strict mode
Description
The table cache_treelist was introduced in revision 3947. The column treelist of type TEXT has a NOT NULL property which breaks MySQL 5 strict mode compatibility.
Removing the NOT NULL property fixes the issue.
- Table structure for table ‘cache_treelist’
#
CREATE TABLE cache_treelist (
md5hash char(32) DEFAULT ‘’ NOT NULL,
pid int(11) DEFAULT ‘0’ NOT NULL,
treelist text NOT NULL,
tstamp int(11) DEFAULT ‘0’ NOT NULL,
expires int(11) unsigned DEFAULT ‘0’ NOT NULL,
PRIMARY KEY (md5hash)
) ENGINE=InnoDB;
(issue imported from #M10282)
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.