-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 1.4.2
-
Component/s: ExeMgr
-
Labels:None
-
Sprint:2020-4, 2020-5
-
Epic/Theme:
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: