5.7 mtr auto increment INSERT failed: 1264: Out of range value for column

Description

Happens in tests:
tokudb.auto_increment_boundary

tokudb.auto_increment

tokudb.type_decimal : At line 167: query 'insert into t1 values ("+111111111.11"),("111111111.11"),("-11111111.11")' failed: 1264: Out of range value for column 'a' at row 1
tokudb.type_float : At line 22: query 'insert into t1 values(10,10),(1e+5,1e+5),(1234567890,1234567890),(1e+10,1e+10),(1e+15,1e+15),(1e+20,1e+20),(1e+50,1e+50),(1e+150,1e+150)' failed: 1264: Out of range value for column 'f1' at row 7

tokudb.type_newdecimal : At line 57: query 'insert into t1 value (10000), (1.1e10), ("11111"), (100000.1)' failed: 1264: Out of range value for column 'a' at row 1

tokudb.type_temporal_fractional : At line 169: query 'INSERT INTO t1 VALUES (9999999999999999999999.1), (999999.1)' failed: 1264: Out of range value for column 'a' at row 1

tokudb.type_uint : At line 14: query 'insert into t1 values (-1)' failed: 1264: Out of range value for column 'this' at row 1

What was a warning is now an SQL error when boundaries are hit, tests need re-written to handle and expect the error in boundary situations.

Environment

None

Activity

Show:
George Lorch
January 4, 2016, 8:55 PM

Assignee

George Lorch

Reporter

George Lorch

Labels

External issue ID

None

Freshdesk Tickets

None

Fix versions

Affects versions

Priority

Major
Configure