DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a INT SIGNED ZEROFILL);
|
INSERT INTO t1 VALUES (-1);
|
SHOW CREATE TABLE t1;
|
+-------+---------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+---------------------------------------------------------------------------------------------------------+
|
| t1 | CREATE TABLE `t1` (
|
`a` int(10) unsigned zerofill DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+---------------------------------------------------------------------------------------------------------+
|
I.e. the "SIGNED" keyword was silently ignored.
The expected behavior is to return an error.
Bug
Major
