|
CREATE TABLE t (a INT, b CHAR(8), KEY(b));
|
INSERT INTO t VALUES (1,'x');
|
ALTER TABLE t MODIFY a DECIMAL(65,10) DEFAULT(-CAST(POW(10,20) AS UNSIGNED));
|
SELECT * FROM t;
|
|
DROP TABLE t;
|
|
10.4 9856bb42
|
CREATE TABLE t (a INT, b CHAR(8), KEY(b));
|
INSERT INTO t VALUES (1,'x');
|
ALTER TABLE t MODIFY a DECIMAL(65,10) DEFAULT(-CAST(POW(10,20) AS UNSIGNED));
|
Warnings:
|
Note 1916 Got overflow when converting '1e20' to UNSIGNED BIGINT. Value truncated
|
Note 1916 Got overflow when converting '1e20' to UNSIGNED BIGINT. Value truncated
|
Note 1916 Got overflow when converting '1e20' to UNSIGNED BIGINT. Value truncated
|
Note 1916 Got overflow when converting '1e20' to UNSIGNED BIGINT. Value truncated
|
Note 1916 Got overflow when converting '1e20' to UNSIGNED BIGINT. Value truncated
|
SELECT * FROM t;
|
a b
|
1.0000000000 x
|
Warnings:
|
Note 1916 Got overflow when converting '1e20' to UNSIGNED BIGINT. Value truncated
|
DROP TABLE t;
|
There are several strange things here.
First, upon ALTER, should it really a Note (not an error), given that it's a strict mode.
Second, why are there five of them upon ALTER, even though there is only one row in the table, and even that row doesn't require default value upon ALTER.
Third and may be the strangest, why is there a warning upon SELECT, select doesn't use DEFAULT.
|