Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.4.2
-
None
-
2020-4, 2020-5
Description
Consider the following:
CREATE TABLE utest1 (ukey INT, c1 TINYINT UNSIGNED, c2 SMALLINT UNSIGNED, c3 INT UNSIGNED, c4 BIGINT UNSIGNED)engine=columnstore;
INSERT INTO utest1 VALUES (3,54,3766,27483646,922336854775806), (4,254,65534,4294967294,1846744073709551614),(5,255,65535,4294967295,18446744073709551615),(6,1255,165535,14294967295,118446744073709551615);
c1 TINYINT will be out of range, so we expect:
ERROR 1264 (22003): Out of range value for column 'c2' at row 4
which is what we get. But if you run the same insert again:
ERROR 1264 (22003): CAL0001: