2604
# Bug#57913 large negative number to string conversion functions crash
2605
# Bug#57810 case/when/then : Assertion failed: length || !scale
2607
SELECT '1' IN ('1', SUBSTRING(-9223372036854775809, 1));
2608
'1' IN ('1', SUBSTRING(-9223372036854775809, 1))
2610
SELECT CONVERT(('' IN (REVERSE(CAST(('') AS DECIMAL)), '')), CHAR(3));
2611
CONVERT(('' IN (REVERSE(CAST(('') AS DECIMAL)), '')), CHAR(3))
2614
Warning 1292 Truncated incorrect DECIMAL value: ''
2616
# Bug#58165: "my_empty_string" gets modified and causes LOAD DATA to fail
2619
CREATE TABLE t1 ( a TEXT );
2620
SELECT 'aaaaaaaaaaaaaa' INTO OUTFILE 'bug58165.txt';
2621
SELECT insert( substring_index( 'a', 'a', 'b' ), 1, 0, 'x' );
2622
insert( substring_index( 'a', 'a', 'b' ), 1, 0, 'x' )
2625
Warning 1292 Truncated incorrect INTEGER value: 'b'
2626
LOAD DATA INFILE 'bug58165.txt' INTO TABLE t1;
2603
2631
End of 5.1 tests