|
SET sql_mode=STRICT_ALL_TABLES;
|
CREATE OR REPLACE TABLE t1 (a INT UNSIGNED NOT NULL);
|
INSERT INTO t1 VALUES (0xFFFFFFFF);
|
CREATE OR REPLACE TABLE t2 AS SELECT a+1 FROM t1;
|
ERROR 1264 (22003): Out of range value for column 'a+1' at row 1
|
Adding LIMIT 0 shows that an INT(11) instead of a BITINT(11) column is created:
CREATE OR REPLACE TABLE t2 AS SELECT a+1 FROM t1 LIMIT 0;
|
DESCRIBE t2;
|
+-------+------------------+------+-----+---------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-------+------------------+------+-----+---------+-------+
|
| a+1 | int(11) unsigned | NO | | 0 | |
|
+-------+------------------+------+-----+---------+-------+
|
|