EVOLUTION-MANAGER

Edit File: 4656.result

SET DEFAULT_STORAGE_ENGINE='tokudb'; DROP TABLE IF EXISTS t2; CREATE TABLE `t2` ( `c1` int(11) NOT NULL, `c2` int(10) unsigned DEFAULT NULL, `c3` int(11) DEFAULT NULL, KEY `c2` (`c2`), KEY `c1` (`c1`) ); INSERT INTO t2 (c1,c2,c3) VALUES (-12, 12, 12), (-11, NULL, 11), (-9, 9, 9), (-8, 8, 8), (-7, 7, 7), (-6, 6, 6), (-5, 5, 5), (-4, 4, 4), (-3, 3, 3), (-2147483648, 2, 2), (-2147483648, 1, 1), (50, 50, 10), (-2147483648, 0, 13), (2147483647, 4294967295, 14), (0, 2147483648, 15), (2147483647, 2147483647, 16); SELECT * FROM t2; c1 c2 c3 -12 12 12 -11 NULL 11 -9 9 9 -8 8 8 -7 7 7 -6 6 6 -5 5 5 -4 4 4 -3 3 3 -2147483648 2 2 -2147483648 1 1 50 50 10 -2147483648 0 13 2147483647 4294967295 14 0 2147483648 15 2147483647 2147483647 16 UPDATE t2 SET c1=-2147483648 WHERE c2 >= 0 ORDER BY c2 DESC LIMIT 2; SELECT * FROM t2; c1 c2 c3 -12 12 12 -11 NULL 11 -9 9 9 -8 8 8 -7 7 7 -6 6 6 -5 5 5 -4 4 4 -3 3 3 -2147483648 2 2 -2147483648 1 1 50 50 10 -2147483648 0 13 -2147483648 4294967295 14 -2147483648 2147483648 15 2147483647 2147483647 16 DROP TABLE t2;