DROP TABLE IF EXISTS t1,t2,t3,t4,t5; CREATE TABLE t1(c1 TINYINT UNSIGNED NOT NULL, c2 TINYINT NULL, c3 SMALLINT, c4 MEDIUMINT , c5 INT, c6 INTEGER, c7 BIGINT); CREATE TABLE t2(c1 TINYINT UNSIGNED NOT NULL, c2 TINYINT NULL, c3 SMALLINT, c4 MEDIUMINT , c5 INT, c6 INTEGER, c7 BIGINT, PRIMARY KEY(c1,c6)); CREATE TABLE t3(c1 TINYINT UNSIGNED NOT NULL, c2 TINYINT NULL, c3 SMALLINT, c4 MEDIUMINT , c5 INT, c6 INTEGER, c7 BIGINT, index idx(c2,c7)); INSERT INTO t1 VALUES(101,-102,103,104,105,106,107),(108,-109,110,111,112,113,114),(115,-116,117,118,119,120,121),(122,-123,124,125,126,127,128); INSERT INTO t2 VALUES(101,-102,103,104,105,106,107),(108,-109,110,111,112,113,114),(115,-116,117,118,119,120,121),(122,-123,124,125,126,127,128); INSERT INTO t3 VALUES(101,-102,103,104,105,106,107),(108,-109,110,111,112,113,114),(115,-116,117,118,119,120,121),(122,-123,124,125,126,127,128); INSERT INTO t2 VALUES(108,-109,110,111,112,101,114),(108,-109,110,111,112,102,114),(102,-109,110,111,112,113,114),(103,-109,110,111,112,113,114); INSERT INTO t3 VALUES(101,-102,103,104,105,106,101),(101,-102,103,104,105,106,102),(101,-103,103,104,105,106,107),(101,-104,103,104,105,106,107); INSERT INTO t1 VALUES(105,NULL,102,103,104,105,106); INSERT INTO t2 VALUES(105,NULL,102,103,104,105,106); INSERT INTO t3 VALUES(105,NULL,102,103,104,105,106); INSERT INTO t1 VALUES('','',17,18,19,20,21); Warnings: Warning 1366 Incorrect integer value: '' for column 'c1' at row 1 Warning 1366 Incorrect integer value: '' for column 'c2' at row 1 INSERT INTO t2 VALUES('','',17,18,19,20,21); Warnings: Warning 1366 Incorrect integer value: '' for column 'c1' at row 1 Warning 1366 Incorrect integer value: '' for column 'c2' at row 1 INSERT INTO t3 VALUES('','',17,18,19,20,21); Warnings: Warning 1366 Incorrect integer value: '' for column 'c1' at row 1 Warning 1366 Incorrect integer value: '' for column 'c2' at row 1 INSERT INTO t1 VALUES(-1,124,22,23,24,25,26); Warnings: Warning 1264 Out of range value for column 'c1' at row 1 INSERT INTO t2 VALUES(-1,124,22,23,24,25,26); Warnings: Warning 1264 Out of range value for column 'c1' at row 1 INSERT INTO t3 VALUES(-1,124,22,23,24,25,26); Warnings: Warning 1264 Out of range value for column 'c1' at row 1 INSERT INTO t1 VALUES(0,124,27,28,29,30,31); INSERT INTO t2 VALUES(0,124,27,28,29,30,31); INSERT INTO t3 VALUES(0,124,27,28,29,30,31); INSERT INTO t1 VALUES(0,0,32,32,34,35,36); INSERT INTO t2 VALUES(0,0,32,32,34,35,36); INSERT INTO t3 VALUES(0,0,32,32,34,35,36); INSERT INTO t1 VALUES('101.34 a','a',37,38,39,40,41); Warnings: Warning 1265 Data truncated for column 'c1' at row 1 Warning 1366 Incorrect integer value: 'a' for column 'c2' at row 1 INSERT INTO t2 VALUES('101.34 a','a',37,38,39,40,41); Warnings: Warning 1265 Data truncated for column 'c1' at row 1 Warning 1366 Incorrect integer value: 'a' for column 'c2' at row 1 INSERT INTO t3 VALUES('101.34 a','a',37,38,39,40,41); Warnings: Warning 1265 Data truncated for column 'c1' at row 1 Warning 1366 Incorrect integer value: 'a' for column 'c2' at row 1 SELECT * FROM t1; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 0 32 32 34 35 36 0 124 22 23 24 25 26 0 124 27 28 29 30 31 101 -102 103 104 105 106 107 101 0 37 38 39 40 41 105 NULL 102 103 104 105 106 108 -109 110 111 112 113 114 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) as max_value, sum(c1) as sum, avg(c1) as avg FROM t1; total_rows min_value max_value sum avg 10 0 122 652 65.2000 SELECT count(*) as total_rows, min(c2) as min_value, max(c2) as max_value, sum(c2) as sum, avg(c2) as avg FROM t1; total_rows min_value max_value sum avg 10 -123 124 -202 -22.4444 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) as max_value, sum(c1) as sum, avg(c1) as avg FROM t2; total_rows min_value max_value sum avg 14 0 122 1073 76.6429 SELECT count(*) as total_rows, min(c2) as min_value, max(c2) as max_value, sum(c2) as sum, avg(c2) as avg FROM t2; total_rows min_value max_value sum avg 14 -123 124 -638 -49.0769 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) as max_value, sum(c1) as sum, avg(c1) as avg FROM t3; total_rows min_value max_value sum avg 14 0 122 1056 75.4286 SELECT count(*) as total_rows, min(c2) as min_value, max(c2) as max_value, sum(c2) as sum, avg(c2) as avg FROM t3; total_rows min_value max_value sum avg 14 -123 124 -613 -47.1538 SELECT * FROM t2 /* comment1 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 0 32 32 34 35 36 0 124 22 23 24 25 26 0 124 27 28 29 30 31 101 -102 103 104 105 106 107 101 0 37 38 39 40 41 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 108 -109 110 111 112 101 114 108 -109 110 111 112 102 114 108 -109 110 111 112 113 114 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) FROM t2; total_rows min_value max(c1) 14 0 122 SELECT * FROM t2 WHERE c2 = 102 /* comment2 */; c1 c2 c3 c4 c5 c6 c7 SELECT c1,c6 FROM t2 /* comment3 */; c1 c6 0 20 0 25 0 30 0 35 101 106 101 40 102 113 103 113 105 105 108 101 108 102 108 113 115 120 122 127 SELECT c1,c6 FROM t2 ORDER BY c1,c6 DESC /* comment5 */; c1 c6 0 35 0 30 0 25 0 20 101 106 101 40 102 113 103 113 105 105 108 113 108 102 108 101 115 120 122 127 SELECT * FROM t2 ORDER BY c1,c6 LIMIT 2 /* comment6 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 SELECT * FROM t2 ORDER BY c1,c6 DESC LIMIT 2 /* comment7 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 SELECT * FROM t2 WHERE c1 = 108 ORDER BY c1,c6 /* comment8 */; c1 c2 c3 c4 c5 c6 c7 108 -109 110 111 112 101 114 108 -109 110 111 112 102 114 108 -109 110 111 112 113 114 SELECT * FROM t2 WHERE c1 = 108 ORDER BY c1,c6 LIMIT 2 /* comment9 */; c1 c2 c3 c4 c5 c6 c7 108 -109 110 111 112 101 114 108 -109 110 111 112 102 114 SELECT * FROM t2 WHERE c1 = 108 ORDER BY c1,c6 DESC /* comment30 */; c1 c2 c3 c4 c5 c6 c7 108 -109 110 111 112 113 114 108 -109 110 111 112 102 114 108 -109 110 111 112 101 114 SELECT * FROM t2 WHERE c1 = 108 ORDER BY c1,c6 DESC LIMIT 2 /* comment31 */; c1 c2 c3 c4 c5 c6 c7 108 -109 110 111 112 113 114 108 -109 110 111 112 102 114 SELECT * FROM t2 WHERE c1 <> 108 ORDER BY c1,c6 /* comment10 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 0 124 27 28 29 30 31 0 0 32 32 34 35 36 101 0 37 38 39 40 41 101 -102 103 104 105 106 107 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT * FROM t2 WHERE c1 <> 108 ORDER BY c1,c6 LIMIT 2 /* comment11 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 SELECT * FROM t2 WHERE c1 > 108 ORDER BY c1,c6 /* comment12 */; c1 c2 c3 c4 c5 c6 c7 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT * FROM t2 WHERE c1 > 108 ORDER BY c1,c6 LIMIT 2 /* comment13 */; c1 c2 c3 c4 c5 c6 c7 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT * FROM t2 WHERE c1 >= 108 ORDER BY c1,c6 /* comment14 */; c1 c2 c3 c4 c5 c6 c7 108 -109 110 111 112 101 114 108 -109 110 111 112 102 114 108 -109 110 111 112 113 114 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT * FROM t2 WHERE c1 >= 108 ORDER BY c1,c6 LIMIT 2 /* comment15 */; c1 c2 c3 c4 c5 c6 c7 108 -109 110 111 112 101 114 108 -109 110 111 112 102 114 SELECT * FROM t2 WHERE c1 < 108 ORDER BY c1,c6 /* comment16 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 0 124 27 28 29 30 31 0 0 32 32 34 35 36 101 0 37 38 39 40 41 101 -102 103 104 105 106 107 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 SELECT * FROM t2 WHERE c1 < 108 ORDER BY c1,c6 LIMIT 2 /* comment17 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 SELECT * FROM t2 WHERE c1 <= 108 ORDER BY c1,c6 /* comment18 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 0 124 27 28 29 30 31 0 0 32 32 34 35 36 101 0 37 38 39 40 41 101 -102 103 104 105 106 107 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 108 -109 110 111 112 101 114 108 -109 110 111 112 102 114 108 -109 110 111 112 113 114 SELECT * FROM t2 WHERE c1 <= 108 ORDER BY c1,c6 LIMIT 2 /* comment19 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 SELECT * FROM t2 WHERE c1 <=> 108 ORDER BY c1,c6 /* comment20 */; c1 c2 c3 c4 c5 c6 c7 108 -109 110 111 112 101 114 108 -109 110 111 112 102 114 108 -109 110 111 112 113 114 SELECT * FROM t2 WHERE c1 <=> 108 ORDER BY c1,c6 LIMIT 2 /* comment21 */; c1 c2 c3 c4 c5 c6 c7 108 -109 110 111 112 101 114 108 -109 110 111 112 102 114 SELECT * FROM t2 WHERE c1 BETWEEN 101 AND 115 ORDER BY c1,c6 /* comment22 */; c1 c2 c3 c4 c5 c6 c7 101 0 37 38 39 40 41 101 -102 103 104 105 106 107 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 108 -109 110 111 112 101 114 108 -109 110 111 112 102 114 108 -109 110 111 112 113 114 115 -116 117 118 119 120 121 SELECT * FROM t2 WHERE c1 BETWEEN 101 AND 115 ORDER BY c1,c6 LIMIT 2 /* comment23 */; c1 c2 c3 c4 c5 c6 c7 101 0 37 38 39 40 41 101 -102 103 104 105 106 107 SELECT * FROM t2 WHERE c1 IN (101,115) ORDER BY c1,c6 /* comment24 */; c1 c2 c3 c4 c5 c6 c7 101 0 37 38 39 40 41 101 -102 103 104 105 106 107 115 -116 117 118 119 120 121 SELECT * FROM t2 WHERE c1 IN (101,115) ORDER BY c1,c6 LIMIT 2 /* comment25 */; c1 c2 c3 c4 c5 c6 c7 101 0 37 38 39 40 41 101 -102 103 104 105 106 107 SELECT * FROM t2 WHERE c1 >= 101 AND c1 < 115 AND c6 = 113 ORDER BY c1,c6 #comment26; c1 c2 c3 c4 c5 c6 c7 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 108 -109 110 111 112 113 114 SELECT * FROM t2 WHERE c1 >= 101 AND c1 < 115 AND c6 = 113 ORDER BY c1,c6 LIMIT 2 #comment27; c1 c2 c3 c4 c5 c6 c7 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 SELECT * FROM t2 WHERE c1 IS NULL ORDER BY c1,c6 /* comment28 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t2 WHERE c1 IS NULL ORDER BY c1,c6 LIMIT 2 /* comment29 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t2 WHERE c1 IS NOT NULL ORDER BY c1,c6 /* comment28 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 0 124 27 28 29 30 31 0 0 32 32 34 35 36 101 0 37 38 39 40 41 101 -102 103 104 105 106 107 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 108 -109 110 111 112 101 114 108 -109 110 111 112 102 114 108 -109 110 111 112 113 114 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT * FROM t2 WHERE c1 IS NOT NULL ORDER BY c1,c6 LIMIT 2 /* comment29 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 SELECT * FROM t2 WHERE c1 <> 108 ORDER BY c1,c6 DESC /* comment32 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 0 124 22 23 24 25 26 0 0 17 18 19 20 21 101 -102 103 104 105 106 107 101 0 37 38 39 40 41 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT * FROM t2 WHERE c1 <> 108 ORDER BY c1,c6 DESC LIMIT 2 /* comment33 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 SELECT * FROM t2 WHERE c1 > 108 ORDER BY c1,c6 DESC /* comment34 */; c1 c2 c3 c4 c5 c6 c7 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT * FROM t2 WHERE c1 > 108 ORDER BY c1,c6 DESC LIMIT 2 /* comment35 */; c1 c2 c3 c4 c5 c6 c7 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT * FROM t2 WHERE c1 >= 108 ORDER BY c1,c6 DESC /* comment36 */; c1 c2 c3 c4 c5 c6 c7 108 -109 110 111 112 113 114 108 -109 110 111 112 102 114 108 -109 110 111 112 101 114 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT * FROM t2 WHERE c1 >= 108 ORDER BY c1,c6 DESC LIMIT 2 /* comment37 */; c1 c2 c3 c4 c5 c6 c7 108 -109 110 111 112 113 114 108 -109 110 111 112 102 114 SELECT * FROM t2 WHERE c1 < 108 ORDER BY c1,c6 DESC /* comment38 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 0 124 22 23 24 25 26 0 0 17 18 19 20 21 101 -102 103 104 105 106 107 101 0 37 38 39 40 41 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 SELECT * FROM t2 WHERE c1 < 108 ORDER BY c1,c6 DESC LIMIT 2 /* comment39 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 SELECT * FROM t2 WHERE c1 <= 108 ORDER BY c1,c6 DESC /* comment40 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 0 124 22 23 24 25 26 0 0 17 18 19 20 21 101 -102 103 104 105 106 107 101 0 37 38 39 40 41 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 108 -109 110 111 112 113 114 108 -109 110 111 112 102 114 108 -109 110 111 112 101 114 SELECT * FROM t2 WHERE c1 <= 108 ORDER BY c1,c6 DESC LIMIT 2 /* comment41 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 SELECT * FROM t2 WHERE c1 <=> 108 ORDER BY c1,c6 DESC /* comment42 */; c1 c2 c3 c4 c5 c6 c7 108 -109 110 111 112 113 114 108 -109 110 111 112 102 114 108 -109 110 111 112 101 114 SELECT * FROM t2 WHERE c1 <=> 108 ORDER BY c1,c6 DESC LIMIT 2 /* comment43 */; c1 c2 c3 c4 c5 c6 c7 108 -109 110 111 112 113 114 108 -109 110 111 112 102 114 SELECT * FROM t2 WHERE c1 BETWEEN 101 AND 115 ORDER BY c1,c6 DESC /* comment44 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 107 101 0 37 38 39 40 41 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 108 -109 110 111 112 113 114 108 -109 110 111 112 102 114 108 -109 110 111 112 101 114 115 -116 117 118 119 120 121 SELECT * FROM t2 WHERE c1 BETWEEN 101 AND 115 ORDER BY c1,c6 DESC LIMIT 2 /* comment45 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 107 101 0 37 38 39 40 41 SELECT * FROM t2 WHERE c1 IN (101,115) ORDER BY c1,c6 DESC /* comment46 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 107 101 0 37 38 39 40 41 115 -116 117 118 119 120 121 SELECT * FROM t2 WHERE c1 IN (101,115) ORDER BY c1,c6 DESC LIMIT 2 /* comment47 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 107 101 0 37 38 39 40 41 SELECT * FROM t2 WHERE c1 >= 101 AND c1 < 115 AND c6 = 113 ORDER BY c1,c6 DESC #comment48; c1 c2 c3 c4 c5 c6 c7 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 108 -109 110 111 112 113 114 SELECT * FROM t2 WHERE c1 >= 101 AND c1 < 115 AND c6 = 113 ORDER BY c1,c6 DESC LIMIT 2 #comment49; c1 c2 c3 c4 c5 c6 c7 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 SELECT * FROM t2 WHERE c1 IS NULL ORDER BY c1,c6 DESC /* comment50 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t2 WHERE c1 IS NULL ORDER BY c1,c6 DESC LIMIT 2 /* comment51 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t2 WHERE c1 IS NOT NULL ORDER BY c1,c6 DESC /* comment50 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 0 124 22 23 24 25 26 0 0 17 18 19 20 21 101 -102 103 104 105 106 107 101 0 37 38 39 40 41 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 108 -109 110 111 112 113 114 108 -109 110 111 112 102 114 108 -109 110 111 112 101 114 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT * FROM t2 WHERE c1 IS NOT NULL ORDER BY c1,c6 DESC LIMIT 2 /* comment51 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 SELECT * FROM t2 /* comment1 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 0 32 32 34 35 36 0 124 22 23 24 25 26 0 124 27 28 29 30 31 101 -102 103 104 105 106 107 101 0 37 38 39 40 41 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 108 -109 110 111 112 101 114 108 -109 110 111 112 102 114 108 -109 110 111 112 113 114 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) FROM t2; total_rows min_value max(c1) 14 0 122 SELECT * FROM t2 WHERE c2 = 102 /* comment2 */; c1 c2 c3 c4 c5 c6 c7 SELECT c1,c6 FROM t2 /* comment3 */; c1 c6 0 20 0 25 0 30 0 35 101 106 101 40 102 113 103 113 105 105 108 101 108 102 108 113 115 120 122 127 SELECT c1,c6 FROM t2 ORDER BY c1,c6 DESC /* comment5 */; c1 c6 0 35 0 30 0 25 0 20 101 106 101 40 102 113 103 113 105 105 108 113 108 102 108 101 115 120 122 127 SELECT * FROM t2 ORDER BY c1,c6 LIMIT 2 /* comment6 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 SELECT * FROM t2 ORDER BY c1,c6 DESC LIMIT 2 /* comment7 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 SELECT * FROM t2 WHERE c1 = 0 ORDER BY c1,c6 /* comment8 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 0 124 27 28 29 30 31 0 0 32 32 34 35 36 SELECT * FROM t2 WHERE c1 = 0 ORDER BY c1,c6 LIMIT 2 /* comment9 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 SELECT * FROM t2 WHERE c1 = 0 ORDER BY c1,c6 DESC /* comment30 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 0 124 22 23 24 25 26 0 0 17 18 19 20 21 SELECT * FROM t2 WHERE c1 = 0 ORDER BY c1,c6 DESC LIMIT 2 /* comment31 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 SELECT * FROM t2 WHERE c1 <> 0 ORDER BY c1,c6 /* comment10 */; c1 c2 c3 c4 c5 c6 c7 101 0 37 38 39 40 41 101 -102 103 104 105 106 107 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 108 -109 110 111 112 101 114 108 -109 110 111 112 102 114 108 -109 110 111 112 113 114 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT * FROM t2 WHERE c1 <> 0 ORDER BY c1,c6 LIMIT 2 /* comment11 */; c1 c2 c3 c4 c5 c6 c7 101 0 37 38 39 40 41 101 -102 103 104 105 106 107 SELECT * FROM t2 WHERE c1 > 0 ORDER BY c1,c6 /* comment12 */; c1 c2 c3 c4 c5 c6 c7 101 0 37 38 39 40 41 101 -102 103 104 105 106 107 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 108 -109 110 111 112 101 114 108 -109 110 111 112 102 114 108 -109 110 111 112 113 114 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT * FROM t2 WHERE c1 > 0 ORDER BY c1,c6 LIMIT 2 /* comment13 */; c1 c2 c3 c4 c5 c6 c7 101 0 37 38 39 40 41 101 -102 103 104 105 106 107 SELECT * FROM t2 WHERE c1 >= 0 ORDER BY c1,c6 /* comment14 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 0 124 27 28 29 30 31 0 0 32 32 34 35 36 101 0 37 38 39 40 41 101 -102 103 104 105 106 107 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 108 -109 110 111 112 101 114 108 -109 110 111 112 102 114 108 -109 110 111 112 113 114 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT * FROM t2 WHERE c1 >= 0 ORDER BY c1,c6 LIMIT 2 /* comment15 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 SELECT * FROM t2 WHERE c1 < 0 ORDER BY c1,c6 /* comment16 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t2 WHERE c1 < 0 ORDER BY c1,c6 LIMIT 2 /* comment17 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t2 WHERE c1 <= 0 ORDER BY c1,c6 /* comment18 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 0 124 27 28 29 30 31 0 0 32 32 34 35 36 SELECT * FROM t2 WHERE c1 <= 0 ORDER BY c1,c6 LIMIT 2 /* comment19 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 SELECT * FROM t2 WHERE c1 <=> 0 ORDER BY c1,c6 /* comment20 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 0 124 27 28 29 30 31 0 0 32 32 34 35 36 SELECT * FROM t2 WHERE c1 <=> 0 ORDER BY c1,c6 LIMIT 2 /* comment21 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 SELECT * FROM t2 WHERE c1 BETWEEN 0 AND 115 ORDER BY c1,c6 /* comment22 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 0 124 27 28 29 30 31 0 0 32 32 34 35 36 101 0 37 38 39 40 41 101 -102 103 104 105 106 107 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 108 -109 110 111 112 101 114 108 -109 110 111 112 102 114 108 -109 110 111 112 113 114 115 -116 117 118 119 120 121 SELECT * FROM t2 WHERE c1 BETWEEN 0 AND 115 ORDER BY c1,c6 LIMIT 2 /* comment23 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 SELECT * FROM t2 WHERE c1 IN (0,115) ORDER BY c1,c6 /* comment24 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 0 124 27 28 29 30 31 0 0 32 32 34 35 36 115 -116 117 118 119 120 121 SELECT * FROM t2 WHERE c1 IN (0,115) ORDER BY c1,c6 LIMIT 2 /* comment25 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 SELECT * FROM t2 WHERE c1 >= 0 AND c1 < 115 AND c6 = 113 ORDER BY c1,c6 #comment26; c1 c2 c3 c4 c5 c6 c7 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 108 -109 110 111 112 113 114 SELECT * FROM t2 WHERE c1 >= 0 AND c1 < 115 AND c6 = 113 ORDER BY c1,c6 LIMIT 2 #comment27; c1 c2 c3 c4 c5 c6 c7 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 SELECT * FROM t2 WHERE c1 IS NULL ORDER BY c1,c6 /* comment28 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t2 WHERE c1 IS NULL ORDER BY c1,c6 LIMIT 2 /* comment29 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t2 WHERE c1 IS NOT NULL ORDER BY c1,c6 /* comment28 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 0 124 27 28 29 30 31 0 0 32 32 34 35 36 101 0 37 38 39 40 41 101 -102 103 104 105 106 107 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 108 -109 110 111 112 101 114 108 -109 110 111 112 102 114 108 -109 110 111 112 113 114 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT * FROM t2 WHERE c1 IS NOT NULL ORDER BY c1,c6 LIMIT 2 /* comment29 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 124 22 23 24 25 26 SELECT * FROM t2 WHERE c1 <> 0 ORDER BY c1,c6 DESC /* comment32 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 107 101 0 37 38 39 40 41 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 108 -109 110 111 112 113 114 108 -109 110 111 112 102 114 108 -109 110 111 112 101 114 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT * FROM t2 WHERE c1 <> 0 ORDER BY c1,c6 DESC LIMIT 2 /* comment33 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 107 101 0 37 38 39 40 41 SELECT * FROM t2 WHERE c1 > 0 ORDER BY c1,c6 DESC /* comment34 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 107 101 0 37 38 39 40 41 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 108 -109 110 111 112 113 114 108 -109 110 111 112 102 114 108 -109 110 111 112 101 114 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT * FROM t2 WHERE c1 > 0 ORDER BY c1,c6 DESC LIMIT 2 /* comment35 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 107 101 0 37 38 39 40 41 SELECT * FROM t2 WHERE c1 >= 0 ORDER BY c1,c6 DESC /* comment36 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 0 124 22 23 24 25 26 0 0 17 18 19 20 21 101 -102 103 104 105 106 107 101 0 37 38 39 40 41 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 108 -109 110 111 112 113 114 108 -109 110 111 112 102 114 108 -109 110 111 112 101 114 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT * FROM t2 WHERE c1 >= 0 ORDER BY c1,c6 DESC LIMIT 2 /* comment37 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 SELECT * FROM t2 WHERE c1 < 0 ORDER BY c1,c6 DESC /* comment38 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t2 WHERE c1 < 0 ORDER BY c1,c6 DESC LIMIT 2 /* comment39 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t2 WHERE c1 <= 0 ORDER BY c1,c6 DESC /* comment40 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 0 124 22 23 24 25 26 0 0 17 18 19 20 21 SELECT * FROM t2 WHERE c1 <= 0 ORDER BY c1,c6 DESC LIMIT 2 /* comment41 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 SELECT * FROM t2 WHERE c1 <=> 0 ORDER BY c1,c6 DESC /* comment42 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 0 124 22 23 24 25 26 0 0 17 18 19 20 21 SELECT * FROM t2 WHERE c1 <=> 0 ORDER BY c1,c6 DESC LIMIT 2 /* comment43 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 SELECT * FROM t2 WHERE c1 BETWEEN 0 AND 115 ORDER BY c1,c6 DESC /* comment44 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 0 124 22 23 24 25 26 0 0 17 18 19 20 21 101 -102 103 104 105 106 107 101 0 37 38 39 40 41 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 108 -109 110 111 112 113 114 108 -109 110 111 112 102 114 108 -109 110 111 112 101 114 115 -116 117 118 119 120 121 SELECT * FROM t2 WHERE c1 BETWEEN 0 AND 115 ORDER BY c1,c6 DESC LIMIT 2 /* comment45 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 SELECT * FROM t2 WHERE c1 IN (0,115) ORDER BY c1,c6 DESC /* comment46 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 0 124 22 23 24 25 26 0 0 17 18 19 20 21 115 -116 117 118 119 120 121 SELECT * FROM t2 WHERE c1 IN (0,115) ORDER BY c1,c6 DESC LIMIT 2 /* comment47 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 SELECT * FROM t2 WHERE c1 >= 0 AND c1 < 115 AND c6 = 113 ORDER BY c1,c6 DESC #comment48; c1 c2 c3 c4 c5 c6 c7 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 108 -109 110 111 112 113 114 SELECT * FROM t2 WHERE c1 >= 0 AND c1 < 115 AND c6 = 113 ORDER BY c1,c6 DESC LIMIT 2 #comment49; c1 c2 c3 c4 c5 c6 c7 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 SELECT * FROM t2 WHERE c1 IS NULL ORDER BY c1,c6 DESC /* comment50 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t2 WHERE c1 IS NULL ORDER BY c1,c6 DESC LIMIT 2 /* comment51 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t2 WHERE c1 IS NOT NULL ORDER BY c1,c6 DESC /* comment50 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 0 124 22 23 24 25 26 0 0 17 18 19 20 21 101 -102 103 104 105 106 107 101 0 37 38 39 40 41 102 -109 110 111 112 113 114 103 -109 110 111 112 113 114 105 NULL 102 103 104 105 106 108 -109 110 111 112 113 114 108 -109 110 111 112 102 114 108 -109 110 111 112 101 114 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT * FROM t2 WHERE c1 IS NOT NULL ORDER BY c1,c6 DESC LIMIT 2 /* comment51 */; c1 c2 c3 c4 c5 c6 c7 0 0 32 32 34 35 36 0 124 27 28 29 30 31 SELECT * FROM t3 /* comment1 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 0 32 32 34 35 36 0 124 22 23 24 25 26 0 124 27 28 29 30 31 101 -102 103 104 105 106 101 101 -102 103 104 105 106 102 101 -102 103 104 105 106 107 101 -103 103 104 105 106 107 101 -104 103 104 105 106 107 101 0 37 38 39 40 41 105 NULL 102 103 104 105 106 108 -109 110 111 112 113 114 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT count(*) as total_rows, min(c2) as min_value, max(c2) FROM t3; total_rows min_value max(c2) 14 -123 124 SELECT * FROM t3 WHERE c1 = 108 /* comment2 */; c1 c2 c3 c4 c5 c6 c7 108 -109 110 111 112 113 114 SELECT c2,c7 FROM t3 /* comment3 */; c2 c7 -102 101 -102 102 -102 107 -103 107 -104 107 -109 114 -116 121 -123 128 0 21 0 36 0 41 124 26 124 31 NULL 106 SELECT c2,c7 FROM t3 ORDER BY c2,c7 DESC /* comment5 */; c2 c7 NULL 106 -123 128 -116 121 -109 114 -104 107 -103 107 -102 107 -102 102 -102 101 0 41 0 36 0 21 124 31 124 26 SELECT * FROM t3 ORDER BY c2,c7 LIMIT 2 /* comment6 */; c1 c2 c3 c4 c5 c6 c7 105 NULL 102 103 104 105 106 122 -123 124 125 126 127 128 SELECT * FROM t3 ORDER BY c2,c7 DESC LIMIT 2 /* comment7 */; c1 c2 c3 c4 c5 c6 c7 105 NULL 102 103 104 105 106 122 -123 124 125 126 127 128 SELECT * FROM t3 WHERE c2 = -102 ORDER BY c2,c7 /* comment8 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 101 101 -102 103 104 105 106 102 101 -102 103 104 105 106 107 SELECT * FROM t3 WHERE c2 = -102 ORDER BY c2,c7 LIMIT 2 /* comment9 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 101 101 -102 103 104 105 106 102 SELECT * FROM t3 WHERE c2 = -102 ORDER BY c2,c7 DESC /* comment30 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 107 101 -102 103 104 105 106 102 101 -102 103 104 105 106 101 SELECT * FROM t3 WHERE c2 = -102 ORDER BY c2,c7 DESC LIMIT 2 /* comment31 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 107 101 -102 103 104 105 106 102 SELECT * FROM t3 WHERE c2 <> -102 ORDER BY c2,c7 /* comment10 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 108 -109 110 111 112 113 114 101 -104 103 104 105 106 107 101 -103 103 104 105 106 107 0 0 17 18 19 20 21 0 0 32 32 34 35 36 101 0 37 38 39 40 41 0 124 22 23 24 25 26 0 124 27 28 29 30 31 SELECT * FROM t3 WHERE c2 <> -102 ORDER BY c2,c7 LIMIT 2 /* comment11 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 SELECT * FROM t3 WHERE c2 > -102 ORDER BY c2,c7 /* comment12 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 0 32 32 34 35 36 101 0 37 38 39 40 41 0 124 22 23 24 25 26 0 124 27 28 29 30 31 SELECT * FROM t3 WHERE c2 > -102 ORDER BY c2,c7 LIMIT 2 /* comment13 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 0 32 32 34 35 36 SELECT * FROM t3 WHERE c2 >= -102 ORDER BY c2,c7 /* comment14 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 101 101 -102 103 104 105 106 102 101 -102 103 104 105 106 107 0 0 17 18 19 20 21 0 0 32 32 34 35 36 101 0 37 38 39 40 41 0 124 22 23 24 25 26 0 124 27 28 29 30 31 SELECT * FROM t3 WHERE c2 >= -102 ORDER BY c2,c7 LIMIT 2 /* comment15 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 101 101 -102 103 104 105 106 102 SELECT * FROM t3 WHERE c2 < -102 ORDER BY c2,c7 /* comment16 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 108 -109 110 111 112 113 114 101 -104 103 104 105 106 107 101 -103 103 104 105 106 107 SELECT * FROM t3 WHERE c2 < -102 ORDER BY c2,c7 LIMIT 2 /* comment17 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 SELECT * FROM t3 WHERE c2 <= -102 ORDER BY c2,c7 /* comment18 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 108 -109 110 111 112 113 114 101 -104 103 104 105 106 107 101 -103 103 104 105 106 107 101 -102 103 104 105 106 101 101 -102 103 104 105 106 102 101 -102 103 104 105 106 107 SELECT * FROM t3 WHERE c2 <= -102 ORDER BY c2,c7 LIMIT 2 /* comment19 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 SELECT * FROM t3 WHERE c2 <=> -102 ORDER BY c2,c7 /* comment20 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 101 101 -102 103 104 105 106 102 101 -102 103 104 105 106 107 SELECT * FROM t3 WHERE c2 <=> -102 ORDER BY c2,c7 LIMIT 2 /* comment21 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 101 101 -102 103 104 105 106 102 SELECT * FROM t3 WHERE c2 BETWEEN -123 AND 0 ORDER BY c2,c7 /* comment22 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 108 -109 110 111 112 113 114 101 -104 103 104 105 106 107 101 -103 103 104 105 106 107 101 -102 103 104 105 106 101 101 -102 103 104 105 106 102 101 -102 103 104 105 106 107 0 0 17 18 19 20 21 0 0 32 32 34 35 36 101 0 37 38 39 40 41 SELECT * FROM t3 WHERE c2 BETWEEN -123 AND 0 ORDER BY c2,c7 LIMIT 2 /* comment23 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 SELECT * FROM t3 WHERE c2 IN (-123,0) ORDER BY c2,c7 /* comment24 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 0 0 17 18 19 20 21 0 0 32 32 34 35 36 101 0 37 38 39 40 41 SELECT * FROM t3 WHERE c2 IN (-123,0) ORDER BY c2,c7 LIMIT 2 /* comment25 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 0 0 17 18 19 20 21 SELECT * FROM t3 WHERE c2 >= -123 AND c2 < 0 AND c7 = 121 ORDER BY c2,c7 #comment26; c1 c2 c3 c4 c5 c6 c7 115 -116 117 118 119 120 121 SELECT * FROM t3 WHERE c2 >= -123 AND c2 < 0 AND c7 = 121 ORDER BY c2,c7 LIMIT 2 #comment27; c1 c2 c3 c4 c5 c6 c7 115 -116 117 118 119 120 121 SELECT * FROM t3 WHERE c2 IS NULL ORDER BY c2,c7 /* comment28 */; c1 c2 c3 c4 c5 c6 c7 105 NULL 102 103 104 105 106 SELECT * FROM t3 WHERE c2 IS NULL ORDER BY c2,c7 LIMIT 2 /* comment29 */; c1 c2 c3 c4 c5 c6 c7 105 NULL 102 103 104 105 106 SELECT * FROM t3 WHERE c2 IS NOT NULL ORDER BY c2,c7 /* comment28 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 108 -109 110 111 112 113 114 101 -104 103 104 105 106 107 101 -103 103 104 105 106 107 101 -102 103 104 105 106 101 101 -102 103 104 105 106 102 101 -102 103 104 105 106 107 0 0 17 18 19 20 21 0 0 32 32 34 35 36 101 0 37 38 39 40 41 0 124 22 23 24 25 26 0 124 27 28 29 30 31 SELECT * FROM t3 WHERE c2 IS NOT NULL ORDER BY c2,c7 LIMIT 2 /* comment29 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 SELECT * FROM t3 WHERE c2 <> -102 ORDER BY c2,c7 DESC /* comment32 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 108 -109 110 111 112 113 114 101 -104 103 104 105 106 107 101 -103 103 104 105 106 107 101 0 37 38 39 40 41 0 0 32 32 34 35 36 0 0 17 18 19 20 21 0 124 27 28 29 30 31 0 124 22 23 24 25 26 SELECT * FROM t3 WHERE c2 <> -102 ORDER BY c2,c7 DESC LIMIT 2 /* comment33 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 SELECT * FROM t3 WHERE c2 > -102 ORDER BY c2,c7 DESC /* comment34 */; c1 c2 c3 c4 c5 c6 c7 101 0 37 38 39 40 41 0 0 32 32 34 35 36 0 0 17 18 19 20 21 0 124 27 28 29 30 31 0 124 22 23 24 25 26 SELECT * FROM t3 WHERE c2 > -102 ORDER BY c2,c7 DESC LIMIT 2 /* comment35 */; c1 c2 c3 c4 c5 c6 c7 101 0 37 38 39 40 41 0 0 32 32 34 35 36 SELECT * FROM t3 WHERE c2 >= -102 ORDER BY c2,c7 DESC /* comment36 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 107 101 -102 103 104 105 106 102 101 -102 103 104 105 106 101 101 0 37 38 39 40 41 0 0 32 32 34 35 36 0 0 17 18 19 20 21 0 124 27 28 29 30 31 0 124 22 23 24 25 26 SELECT * FROM t3 WHERE c2 >= -102 ORDER BY c2,c7 DESC LIMIT 2 /* comment37 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 107 101 -102 103 104 105 106 102 SELECT * FROM t3 WHERE c2 < -102 ORDER BY c2,c7 DESC /* comment38 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 108 -109 110 111 112 113 114 101 -104 103 104 105 106 107 101 -103 103 104 105 106 107 SELECT * FROM t3 WHERE c2 < -102 ORDER BY c2,c7 DESC LIMIT 2 /* comment39 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 SELECT * FROM t3 WHERE c2 <= -102 ORDER BY c2,c7 DESC /* comment40 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 108 -109 110 111 112 113 114 101 -104 103 104 105 106 107 101 -103 103 104 105 106 107 101 -102 103 104 105 106 107 101 -102 103 104 105 106 102 101 -102 103 104 105 106 101 SELECT * FROM t3 WHERE c2 <= -102 ORDER BY c2,c7 DESC LIMIT 2 /* comment41 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 SELECT * FROM t3 WHERE c2 <=> -102 ORDER BY c2,c7 DESC /* comment42 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 107 101 -102 103 104 105 106 102 101 -102 103 104 105 106 101 SELECT * FROM t3 WHERE c2 <=> -102 ORDER BY c2,c7 DESC LIMIT 2 /* comment43 */; c1 c2 c3 c4 c5 c6 c7 101 -102 103 104 105 106 107 101 -102 103 104 105 106 102 SELECT * FROM t3 WHERE c2 BETWEEN -123 AND 0 ORDER BY c2,c7 DESC /* comment44 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 108 -109 110 111 112 113 114 101 -104 103 104 105 106 107 101 -103 103 104 105 106 107 101 -102 103 104 105 106 107 101 -102 103 104 105 106 102 101 -102 103 104 105 106 101 101 0 37 38 39 40 41 0 0 32 32 34 35 36 0 0 17 18 19 20 21 SELECT * FROM t3 WHERE c2 BETWEEN -123 AND 0 ORDER BY c2,c7 DESC LIMIT 2 /* comment45 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 SELECT * FROM t3 WHERE c2 IN (-123,0) ORDER BY c2,c7 DESC /* comment46 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 101 0 37 38 39 40 41 0 0 32 32 34 35 36 0 0 17 18 19 20 21 SELECT * FROM t3 WHERE c2 IN (-123,0) ORDER BY c2,c7 DESC LIMIT 2 /* comment47 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 101 0 37 38 39 40 41 SELECT * FROM t3 WHERE c2 >= -123 AND c2 < 0 AND c7 = 121 ORDER BY c2,c7 DESC #comment48; c1 c2 c3 c4 c5 c6 c7 115 -116 117 118 119 120 121 SELECT * FROM t3 WHERE c2 >= -123 AND c2 < 0 AND c7 = 121 ORDER BY c2,c7 DESC LIMIT 2 #comment49; c1 c2 c3 c4 c5 c6 c7 115 -116 117 118 119 120 121 SELECT * FROM t3 WHERE c2 IS NULL ORDER BY c2,c7 DESC /* comment50 */; c1 c2 c3 c4 c5 c6 c7 105 NULL 102 103 104 105 106 SELECT * FROM t3 WHERE c2 IS NULL ORDER BY c2,c7 DESC LIMIT 2 /* comment51 */; c1 c2 c3 c4 c5 c6 c7 105 NULL 102 103 104 105 106 SELECT * FROM t3 WHERE c2 IS NOT NULL ORDER BY c2,c7 DESC /* comment50 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 108 -109 110 111 112 113 114 101 -104 103 104 105 106 107 101 -103 103 104 105 106 107 101 -102 103 104 105 106 107 101 -102 103 104 105 106 102 101 -102 103 104 105 106 101 101 0 37 38 39 40 41 0 0 32 32 34 35 36 0 0 17 18 19 20 21 0 124 27 28 29 30 31 0 124 22 23 24 25 26 SELECT * FROM t3 WHERE c2 IS NOT NULL ORDER BY c2,c7 DESC LIMIT 2 /* comment51 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 SELECT * FROM t3 /* comment1 */; c1 c2 c3 c4 c5 c6 c7 0 0 17 18 19 20 21 0 0 32 32 34 35 36 0 124 22 23 24 25 26 0 124 27 28 29 30 31 101 -102 103 104 105 106 101 101 -102 103 104 105 106 102 101 -102 103 104 105 106 107 101 -103 103 104 105 106 107 101 -104 103 104 105 106 107 101 0 37 38 39 40 41 105 NULL 102 103 104 105 106 108 -109 110 111 112 113 114 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 SELECT count(*) as total_rows, min(c2) as min_value, max(c2) FROM t3; total_rows min_value max(c2) 14 -123 124 SELECT * FROM t3 WHERE c1 = 108 /* comment2 */; c1 c2 c3 c4 c5 c6 c7 108 -109 110 111 112 113 114 SELECT c2,c7 FROM t3 /* comment3 */; c2 c7 -102 101 -102 102 -102 107 -103 107 -104 107 -109 114 -116 121 -123 128 0 21 0 36 0 41 124 26 124 31 NULL 106 SELECT c2,c7 FROM t3 ORDER BY c2,c7 DESC /* comment5 */; c2 c7 NULL 106 -123 128 -116 121 -109 114 -104 107 -103 107 -102 107 -102 102 -102 101 0 41 0 36 0 21 124 31 124 26 SELECT * FROM t3 ORDER BY c2,c7 LIMIT 2 /* comment6 */; c1 c2 c3 c4 c5 c6 c7 105 NULL 102 103 104 105 106 122 -123 124 125 126 127 128 SELECT * FROM t3 ORDER BY c2,c7 DESC LIMIT 2 /* comment7 */; c1 c2 c3 c4 c5 c6 c7 105 NULL 102 103 104 105 106 122 -123 124 125 126 127 128 SELECT * FROM t3 WHERE c2 = NULL ORDER BY c2,c7 /* comment8 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 = NULL ORDER BY c2,c7 LIMIT 2 /* comment9 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 = NULL ORDER BY c2,c7 DESC /* comment30 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 = NULL ORDER BY c2,c7 DESC LIMIT 2 /* comment31 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 <> NULL ORDER BY c2,c7 /* comment10 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 <> NULL ORDER BY c2,c7 LIMIT 2 /* comment11 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 > NULL ORDER BY c2,c7 /* comment12 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 > NULL ORDER BY c2,c7 LIMIT 2 /* comment13 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 >= NULL ORDER BY c2,c7 /* comment14 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 >= NULL ORDER BY c2,c7 LIMIT 2 /* comment15 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 < NULL ORDER BY c2,c7 /* comment16 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 < NULL ORDER BY c2,c7 LIMIT 2 /* comment17 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 <= NULL ORDER BY c2,c7 /* comment18 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 <= NULL ORDER BY c2,c7 LIMIT 2 /* comment19 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 <=> NULL ORDER BY c2,c7 /* comment20 */; c1 c2 c3 c4 c5 c6 c7 105 NULL 102 103 104 105 106 SELECT * FROM t3 WHERE c2 <=> NULL ORDER BY c2,c7 LIMIT 2 /* comment21 */; c1 c2 c3 c4 c5 c6 c7 105 NULL 102 103 104 105 106 SELECT * FROM t3 WHERE c2 BETWEEN NULL AND -123 ORDER BY c2,c7 /* comment22 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 BETWEEN NULL AND -123 ORDER BY c2,c7 LIMIT 2 /* comment23 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 IN (NULL,-123) ORDER BY c2,c7 /* comment24 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 SELECT * FROM t3 WHERE c2 IN (NULL,-123) ORDER BY c2,c7 LIMIT 2 /* comment25 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 SELECT * FROM t3 WHERE c2 >= NULL AND c2 < -123 AND c7 = 121 ORDER BY c2,c7 #comment26; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 >= NULL AND c2 < -123 AND c7 = 121 ORDER BY c2,c7 LIMIT 2 #comment27; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 IS NULL ORDER BY c2,c7 /* comment28 */; c1 c2 c3 c4 c5 c6 c7 105 NULL 102 103 104 105 106 SELECT * FROM t3 WHERE c2 IS NULL ORDER BY c2,c7 LIMIT 2 /* comment29 */; c1 c2 c3 c4 c5 c6 c7 105 NULL 102 103 104 105 106 SELECT * FROM t3 WHERE c2 IS NOT NULL ORDER BY c2,c7 /* comment28 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 108 -109 110 111 112 113 114 101 -104 103 104 105 106 107 101 -103 103 104 105 106 107 101 -102 103 104 105 106 101 101 -102 103 104 105 106 102 101 -102 103 104 105 106 107 0 0 17 18 19 20 21 0 0 32 32 34 35 36 101 0 37 38 39 40 41 0 124 22 23 24 25 26 0 124 27 28 29 30 31 SELECT * FROM t3 WHERE c2 IS NOT NULL ORDER BY c2,c7 LIMIT 2 /* comment29 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 SELECT * FROM t3 WHERE c2 <> NULL ORDER BY c2,c7 DESC /* comment32 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 <> NULL ORDER BY c2,c7 DESC LIMIT 2 /* comment33 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 > NULL ORDER BY c2,c7 DESC /* comment34 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 > NULL ORDER BY c2,c7 DESC LIMIT 2 /* comment35 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 >= NULL ORDER BY c2,c7 DESC /* comment36 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 >= NULL ORDER BY c2,c7 DESC LIMIT 2 /* comment37 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 < NULL ORDER BY c2,c7 DESC /* comment38 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 < NULL ORDER BY c2,c7 DESC LIMIT 2 /* comment39 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 <= NULL ORDER BY c2,c7 DESC /* comment40 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 <= NULL ORDER BY c2,c7 DESC LIMIT 2 /* comment41 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 <=> NULL ORDER BY c2,c7 DESC /* comment42 */; c1 c2 c3 c4 c5 c6 c7 105 NULL 102 103 104 105 106 SELECT * FROM t3 WHERE c2 <=> NULL ORDER BY c2,c7 DESC LIMIT 2 /* comment43 */; c1 c2 c3 c4 c5 c6 c7 105 NULL 102 103 104 105 106 SELECT * FROM t3 WHERE c2 BETWEEN NULL AND -123 ORDER BY c2,c7 DESC /* comment44 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 BETWEEN NULL AND -123 ORDER BY c2,c7 DESC LIMIT 2 /* comment45 */; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 IN (NULL,-123) ORDER BY c2,c7 DESC /* comment46 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 SELECT * FROM t3 WHERE c2 IN (NULL,-123) ORDER BY c2,c7 DESC LIMIT 2 /* comment47 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 SELECT * FROM t3 WHERE c2 >= NULL AND c2 < -123 AND c7 = 121 ORDER BY c2,c7 DESC #comment48; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 >= NULL AND c2 < -123 AND c7 = 121 ORDER BY c2,c7 DESC LIMIT 2 #comment49; c1 c2 c3 c4 c5 c6 c7 SELECT * FROM t3 WHERE c2 IS NULL ORDER BY c2,c7 DESC /* comment50 */; c1 c2 c3 c4 c5 c6 c7 105 NULL 102 103 104 105 106 SELECT * FROM t3 WHERE c2 IS NULL ORDER BY c2,c7 DESC LIMIT 2 /* comment51 */; c1 c2 c3 c4 c5 c6 c7 105 NULL 102 103 104 105 106 SELECT * FROM t3 WHERE c2 IS NOT NULL ORDER BY c2,c7 DESC /* comment50 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 108 -109 110 111 112 113 114 101 -104 103 104 105 106 107 101 -103 103 104 105 106 107 101 -102 103 104 105 106 107 101 -102 103 104 105 106 102 101 -102 103 104 105 106 101 101 0 37 38 39 40 41 0 0 32 32 34 35 36 0 0 17 18 19 20 21 0 124 27 28 29 30 31 0 124 22 23 24 25 26 SELECT * FROM t3 WHERE c2 IS NOT NULL ORDER BY c2,c7 DESC LIMIT 2 /* comment51 */; c1 c2 c3 c4 c5 c6 c7 122 -123 124 125 126 127 128 115 -116 117 118 119 120 121 SELECT c2 FROM t3 GROUP BY c2; c2 -102 -103 -104 -109 -116 -123 0 124 NULL SELECT DISTINCT c2 FROM t3; c2 -102 -103 -104 -109 -116 -123 0 124 NULL SELECT c2,MIN(c7) FROM t3 GROUP BY c2; c2 MIN(c7) -102 101 -103 107 -104 107 -109 114 -116 121 -123 128 0 21 124 26 NULL 106 CREATE TABLE t4(c1 TINYINT SIGNED NOT NULL AUTO_INCREMENT, c2 TINYINT UNSIGNED NULL, c3 TINYINT UNSIGNED NOT NULL, c4 SMALLINT , c5 MEDIUMINT, c6 INT, c7 INTEGER, c8 BIGINT, PRIMARY KEY(c1), UNIQUE INDEX idx(c2,c3)); CREATE TABLE t5(c1 TINYINT UNSIGNED NOT NULL AUTO_INCREMENT, c2 TINYINT SIGNED NULL, c3 TINYINT SIGNED NOT NULL, c4 SMALLINT, c5 MEDIUMINT, c6 INT, c7 INTEGER, c8 BIGINT, PRIMARY KEY(c1,c2), UNIQUE INDEX(c3)); INSERT INTO t4 VALUES(-101,102,103,104,105,106,107,108),(-108,109,110,111,112,113,114,115); INSERT INTO t5 VALUES(101,-102,-103,-104,105,106,107,108),(108,-109,-110,111,112,113,114,115); INSERT INTO t4 VALUES(0,32,33,34,35,36,37,38); INSERT INTO t5 VALUES(0,-32,-32,33,34,35,36,37); INSERT INTO t4(c1,c3,c4) VALUES(NULL,104,LAST_INSERT_ID()); INSERT INTO t5(c1,c3,c4) VALUES(NULL,-104,LAST_INSERT_ID()); INSERT INTO t4 VALUES('','',17,18,19,20,21,22); Warnings: Warning 1366 Incorrect integer value: '' for column 'c1' at row 1 Warning 1366 Incorrect integer value: '' for column 'c2' at row 1 INSERT INTO t5 VALUES('','',-17,18,19,20,21,22); Warnings: Warning 1366 Incorrect integer value: '' for column 'c1' at row 1 Warning 1366 Incorrect integer value: '' for column 'c2' at row 1 INSERT INTO t4 VALUES('102.34 a','a','a',37,38,39,40,41); Warnings: Warning 1265 Data truncated for column 'c1' at row 1 Warning 1366 Incorrect integer value: 'a' for column 'c2' at row 1 Warning 1366 Incorrect integer value: 'a' for column 'c3' at row 1 INSERT INTO t5 VALUES('102.34 a','a','a',37,38,39,40,41); Warnings: Warning 1265 Data truncated for column 'c1' at row 1 Warning 1366 Incorrect integer value: 'a' for column 'c2' at row 1 Warning 1366 Incorrect integer value: 'a' for column 'c3' at row 1 INSERT INTO t4 VALUES(4,7,8,9,10,11,12,13); INSERT INTO t5 VALUES(-1,-1,-1,8,9,10,11,12); Warnings: Warning 1264 Out of range value for column 'c1' at row 1 INSERT INTO t4(c2,c3,c4,c5,c6,c7,c8) VALUES(101,102,104,105,106,107,108),(108,109,111,112,113,114,115),(115,116,118,119,120,121,122),(122,123,125,126,127,128,128); INSERT INTO t5(c2,c3,c4,c5,c6,c7,c8) VALUES(-101,-102,104,105,106,107,108),(-108,-109,111,112,113,114,115),(-115,-116,118,119,120,121,122),(-122,-123,125,126,127,128,128); SELECT count(*) as total_rows, min(c1) as min_value, max(c1) as max_value, sum(c1) as sum, avg(c1) as avg FROM t4; total_rows min_value max_value sum avg 11 -108 106 321 29.1818 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) as max_value, sum(c1) as sum, avg(c1) as avg FROM t5; total_rows min_value max_value sum avg 11 101 116 1211 110.0909 SELECT * FROM t4 /* comment1 */; c1 c2 c3 c4 c5 c6 c7 c8 -101 102 103 104 105 106 107 108 -108 109 110 111 112 113 114 115 1 32 33 34 35 36 37 38 102 0 0 37 38 39 40 41 103 101 102 104 105 106 107 108 104 108 109 111 112 113 114 115 105 115 116 118 119 120 121 122 106 122 123 125 126 127 128 128 2 NULL 104 109 NULL NULL NULL NULL 3 0 17 18 19 20 21 22 4 7 8 9 10 11 12 13 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) FROM t4; total_rows min_value max(c1) 11 -108 106 SELECT * FROM t4 WHERE c4 = 104 /* comment2 */; c1 c2 c3 c4 c5 c6 c7 c8 -101 102 103 104 105 106 107 108 103 101 102 104 105 106 107 108 SELECT c1 FROM t4 /* comment3 */; c1 -101 -108 1 102 103 104 105 106 2 3 4 SELECT c1 FROM t4 ORDER BY c1 DESC /* comment5 */; c1 106 105 104 103 102 4 3 2 1 -101 -108 SELECT * FROM t4 ORDER BY c1 LIMIT 2 /* comment6 */; c1 c2 c3 c4 c5 c6 c7 c8 -108 109 110 111 112 113 114 115 -101 102 103 104 105 106 107 108 SELECT * FROM t4 ORDER BY c1 DESC LIMIT 2 /* comment7 */; c1 c2 c3 c4 c5 c6 c7 c8 106 122 123 125 126 127 128 128 105 115 116 118 119 120 121 122 SELECT * FROM t4 WHERE c1 = 1 ORDER BY c1 /* comment8 */; c1 c2 c3 c4 c5 c6 c7 c8 1 32 33 34 35 36 37 38 SELECT * FROM t4 WHERE c1 = 1 ORDER BY c1 LIMIT 2 /* comment9 */; c1 c2 c3 c4 c5 c6 c7 c8 1 32 33 34 35 36 37 38 SELECT * FROM t4 WHERE c1 = 1 ORDER BY c1 DESC /* comment30 */; c1 c2 c3 c4 c5 c6 c7 c8 1 32 33 34 35 36 37 38 SELECT * FROM t4 WHERE c1 = 1 ORDER BY c1 DESC LIMIT 2 /* comment31 */; c1 c2 c3 c4 c5 c6 c7 c8 1 32 33 34 35 36 37 38 SELECT * FROM t4 WHERE c1 <> 1 ORDER BY c1 /* comment10 */; c1 c2 c3 c4 c5 c6 c7 c8 -108 109 110 111 112 113 114 115 -101 102 103 104 105 106 107 108 2 NULL 104 109 NULL NULL NULL NULL 3 0 17 18 19 20 21 22 4 7 8 9 10 11 12 13 102 0 0 37 38 39 40 41 103 101 102 104 105 106 107 108 104 108 109 111 112 113 114 115 105 115 116 118 119 120 121 122 106 122 123 125 126 127 128 128 SELECT * FROM t4 WHERE c1 <> 1 ORDER BY c1 LIMIT 2 /* comment11 */; c1 c2 c3 c4 c5 c6 c7 c8 -108 109 110 111 112 113 114 115 -101 102 103 104 105 106 107 108 SELECT * FROM t4 WHERE c1 > 1 ORDER BY c1 /* comment12 */; c1 c2 c3 c4 c5 c6 c7 c8 2 NULL 104 109 NULL NULL NULL NULL 3 0 17 18 19 20 21 22 4 7 8 9 10 11 12 13 102 0 0 37 38 39 40 41 103 101 102 104 105 106 107 108 104 108 109 111 112 113 114 115 105 115 116 118 119 120 121 122 106 122 123 125 126 127 128 128 SELECT * FROM t4 WHERE c1 > 1 ORDER BY c1 LIMIT 2 /* comment13 */; c1 c2 c3 c4 c5 c6 c7 c8 2 NULL 104 109 NULL NULL NULL NULL 3 0 17 18 19 20 21 22 SELECT * FROM t4 WHERE c1 >= 1 ORDER BY c1 /* comment14 */; c1 c2 c3 c4 c5 c6 c7 c8 1 32 33 34 35 36 37 38 2 NULL 104 109 NULL NULL NULL NULL 3 0 17 18 19 20 21 22 4 7 8 9 10 11 12 13 102 0 0 37 38 39 40 41 103 101 102 104 105 106 107 108 104 108 109 111 112 113 114 115 105 115 116 118 119 120 121 122 106 122 123 125 126 127 128 128 SELECT * FROM t4 WHERE c1 >= 1 ORDER BY c1 LIMIT 2 /* comment15 */; c1 c2 c3 c4 c5 c6 c7 c8 1 32 33 34 35 36 37 38 2 NULL 104 109 NULL NULL NULL NULL SELECT * FROM t4 WHERE c1 < 1 ORDER BY c1 /* comment16 */; c1 c2 c3 c4 c5 c6 c7 c8 -108 109 110 111 112 113 114 115 -101 102 103 104 105 106 107 108 SELECT * FROM t4 WHERE c1 < 1 ORDER BY c1 LIMIT 2 /* comment17 */; c1 c2 c3 c4 c5 c6 c7 c8 -108 109 110 111 112 113 114 115 -101 102 103 104 105 106 107 108 SELECT * FROM t4 WHERE c1 <= 1 ORDER BY c1 /* comment18 */; c1 c2 c3 c4 c5 c6 c7 c8 -108 109 110 111 112 113 114 115 -101 102 103 104 105 106 107 108 1 32 33 34 35 36 37 38 SELECT * FROM t4 WHERE c1 <= 1 ORDER BY c1 LIMIT 2 /* comment19 */; c1 c2 c3 c4 c5 c6 c7 c8 -108 109 110 111 112 113 114 115 -101 102 103 104 105 106 107 108 SELECT * FROM t4 WHERE c1 <=> 1 ORDER BY c1 /* comment20 */; c1 c2 c3 c4 c5 c6 c7 c8 1 32 33 34 35 36 37 38 SELECT * FROM t4 WHERE c1 <=> 1 ORDER BY c1 LIMIT 2 /* comment21 */; c1 c2 c3 c4 c5 c6 c7 c8 1 32 33 34 35 36 37 38 SELECT * FROM t4 WHERE c1 BETWEEN -101 AND 4 ORDER BY c1 /* comment22 */; c1 c2 c3 c4 c5 c6 c7 c8 -101 102 103 104 105 106 107 108 1 32 33 34 35 36 37 38 2 NULL 104 109 NULL NULL NULL NULL 3 0 17 18 19 20 21 22 4 7 8 9 10 11 12 13 SELECT * FROM t4 WHERE c1 BETWEEN -101 AND 4 ORDER BY c1 LIMIT 2 /* comment23 */; c1 c2 c3 c4 c5 c6 c7 c8 -101 102 103 104 105 106 107 108 1 32 33 34 35 36 37 38 SELECT * FROM t4 WHERE c1 IN (-101,4) ORDER BY c1 /* comment24 */; c1 c2 c3 c4 c5 c6 c7 c8 -101 102 103 104 105 106 107 108 4 7 8 9 10 11 12 13 SELECT * FROM t4 WHERE c1 IN (-101,4) ORDER BY c1 LIMIT 2 /* comment25 */; c1 c2 c3 c4 c5 c6 c7 c8 -101 102 103 104 105 106 107 108 4 7 8 9 10 11 12 13 SELECT * FROM t4 WHERE c1 >= -101 AND c1 < 4 AND c3 = 109 ORDER BY c1 #comment26; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 >= -101 AND c1 < 4 AND c3 = 109 ORDER BY c1 LIMIT 2 #comment27; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 IS NULL ORDER BY c1 /* comment28 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 IS NULL ORDER BY c1 LIMIT 2 /* comment29 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 IS NOT NULL ORDER BY c1 /* comment28 */; c1 c2 c3 c4 c5 c6 c7 c8 -108 109 110 111 112 113 114 115 -101 102 103 104 105 106 107 108 1 32 33 34 35 36 37 38 2 NULL 104 109 NULL NULL NULL NULL 3 0 17 18 19 20 21 22 4 7 8 9 10 11 12 13 102 0 0 37 38 39 40 41 103 101 102 104 105 106 107 108 104 108 109 111 112 113 114 115 105 115 116 118 119 120 121 122 106 122 123 125 126 127 128 128 SELECT * FROM t4 WHERE c1 IS NOT NULL ORDER BY c1 LIMIT 2 /* comment29 */; c1 c2 c3 c4 c5 c6 c7 c8 -108 109 110 111 112 113 114 115 -101 102 103 104 105 106 107 108 SELECT * FROM t4 WHERE c1 <> 1 ORDER BY c1 DESC /* comment32 */; c1 c2 c3 c4 c5 c6 c7 c8 106 122 123 125 126 127 128 128 105 115 116 118 119 120 121 122 104 108 109 111 112 113 114 115 103 101 102 104 105 106 107 108 102 0 0 37 38 39 40 41 4 7 8 9 10 11 12 13 3 0 17 18 19 20 21 22 2 NULL 104 109 NULL NULL NULL NULL -101 102 103 104 105 106 107 108 -108 109 110 111 112 113 114 115 SELECT * FROM t4 WHERE c1 <> 1 ORDER BY c1 DESC LIMIT 2 /* comment33 */; c1 c2 c3 c4 c5 c6 c7 c8 106 122 123 125 126 127 128 128 105 115 116 118 119 120 121 122 SELECT * FROM t4 WHERE c1 > 1 ORDER BY c1 DESC /* comment34 */; c1 c2 c3 c4 c5 c6 c7 c8 106 122 123 125 126 127 128 128 105 115 116 118 119 120 121 122 104 108 109 111 112 113 114 115 103 101 102 104 105 106 107 108 102 0 0 37 38 39 40 41 4 7 8 9 10 11 12 13 3 0 17 18 19 20 21 22 2 NULL 104 109 NULL NULL NULL NULL SELECT * FROM t4 WHERE c1 > 1 ORDER BY c1 DESC LIMIT 2 /* comment35 */; c1 c2 c3 c4 c5 c6 c7 c8 106 122 123 125 126 127 128 128 105 115 116 118 119 120 121 122 SELECT * FROM t4 WHERE c1 >= 1 ORDER BY c1 DESC /* comment36 */; c1 c2 c3 c4 c5 c6 c7 c8 106 122 123 125 126 127 128 128 105 115 116 118 119 120 121 122 104 108 109 111 112 113 114 115 103 101 102 104 105 106 107 108 102 0 0 37 38 39 40 41 4 7 8 9 10 11 12 13 3 0 17 18 19 20 21 22 2 NULL 104 109 NULL NULL NULL NULL 1 32 33 34 35 36 37 38 SELECT * FROM t4 WHERE c1 >= 1 ORDER BY c1 DESC LIMIT 2 /* comment37 */; c1 c2 c3 c4 c5 c6 c7 c8 106 122 123 125 126 127 128 128 105 115 116 118 119 120 121 122 SELECT * FROM t4 WHERE c1 < 1 ORDER BY c1 DESC /* comment38 */; c1 c2 c3 c4 c5 c6 c7 c8 -101 102 103 104 105 106 107 108 -108 109 110 111 112 113 114 115 SELECT * FROM t4 WHERE c1 < 1 ORDER BY c1 DESC LIMIT 2 /* comment39 */; c1 c2 c3 c4 c5 c6 c7 c8 -101 102 103 104 105 106 107 108 -108 109 110 111 112 113 114 115 SELECT * FROM t4 WHERE c1 <= 1 ORDER BY c1 DESC /* comment40 */; c1 c2 c3 c4 c5 c6 c7 c8 1 32 33 34 35 36 37 38 -101 102 103 104 105 106 107 108 -108 109 110 111 112 113 114 115 SELECT * FROM t4 WHERE c1 <= 1 ORDER BY c1 DESC LIMIT 2 /* comment41 */; c1 c2 c3 c4 c5 c6 c7 c8 1 32 33 34 35 36 37 38 -101 102 103 104 105 106 107 108 SELECT * FROM t4 WHERE c1 <=> 1 ORDER BY c1 DESC /* comment42 */; c1 c2 c3 c4 c5 c6 c7 c8 1 32 33 34 35 36 37 38 SELECT * FROM t4 WHERE c1 <=> 1 ORDER BY c1 DESC LIMIT 2 /* comment43 */; c1 c2 c3 c4 c5 c6 c7 c8 1 32 33 34 35 36 37 38 SELECT * FROM t4 WHERE c1 BETWEEN -101 AND 4 ORDER BY c1 DESC /* comment44 */; c1 c2 c3 c4 c5 c6 c7 c8 4 7 8 9 10 11 12 13 3 0 17 18 19 20 21 22 2 NULL 104 109 NULL NULL NULL NULL 1 32 33 34 35 36 37 38 -101 102 103 104 105 106 107 108 SELECT * FROM t4 WHERE c1 BETWEEN -101 AND 4 ORDER BY c1 DESC LIMIT 2 /* comment45 */; c1 c2 c3 c4 c5 c6 c7 c8 4 7 8 9 10 11 12 13 3 0 17 18 19 20 21 22 SELECT * FROM t4 WHERE c1 IN (-101,4) ORDER BY c1 DESC /* comment46 */; c1 c2 c3 c4 c5 c6 c7 c8 4 7 8 9 10 11 12 13 -101 102 103 104 105 106 107 108 SELECT * FROM t4 WHERE c1 IN (-101,4) ORDER BY c1 DESC LIMIT 2 /* comment47 */; c1 c2 c3 c4 c5 c6 c7 c8 4 7 8 9 10 11 12 13 -101 102 103 104 105 106 107 108 SELECT * FROM t4 WHERE c1 >= -101 AND c1 < 4 AND c3 = 109 ORDER BY c1 DESC #comment48; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 >= -101 AND c1 < 4 AND c3 = 109 ORDER BY c1 DESC LIMIT 2 #comment49; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 IS NULL ORDER BY c1 DESC /* comment50 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 IS NULL ORDER BY c1 DESC LIMIT 2 /* comment51 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 IS NOT NULL ORDER BY c1 DESC /* comment50 */; c1 c2 c3 c4 c5 c6 c7 c8 106 122 123 125 126 127 128 128 105 115 116 118 119 120 121 122 104 108 109 111 112 113 114 115 103 101 102 104 105 106 107 108 102 0 0 37 38 39 40 41 4 7 8 9 10 11 12 13 3 0 17 18 19 20 21 22 2 NULL 104 109 NULL NULL NULL NULL 1 32 33 34 35 36 37 38 -101 102 103 104 105 106 107 108 -108 109 110 111 112 113 114 115 SELECT * FROM t4 WHERE c1 IS NOT NULL ORDER BY c1 DESC LIMIT 2 /* comment51 */; c1 c2 c3 c4 c5 c6 c7 c8 106 122 123 125 126 127 128 128 105 115 116 118 119 120 121 122 SELECT * FROM t4 /* comment1 */; c1 c2 c3 c4 c5 c6 c7 c8 -101 102 103 104 105 106 107 108 -108 109 110 111 112 113 114 115 1 32 33 34 35 36 37 38 102 0 0 37 38 39 40 41 103 101 102 104 105 106 107 108 104 108 109 111 112 113 114 115 105 115 116 118 119 120 121 122 106 122 123 125 126 127 128 128 2 NULL 104 109 NULL NULL NULL NULL 3 0 17 18 19 20 21 22 4 7 8 9 10 11 12 13 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) FROM t4; total_rows min_value max(c1) 11 -108 106 SELECT * FROM t4 WHERE c4 = 104 /* comment2 */; c1 c2 c3 c4 c5 c6 c7 c8 -101 102 103 104 105 106 107 108 103 101 102 104 105 106 107 108 SELECT c1 FROM t4 /* comment3 */; c1 -101 -108 1 102 103 104 105 106 2 3 4 SELECT c1 FROM t4 ORDER BY c1 DESC /* comment5 */; c1 106 105 104 103 102 4 3 2 1 -101 -108 SELECT * FROM t4 ORDER BY c1 LIMIT 2 /* comment6 */; c1 c2 c3 c4 c5 c6 c7 c8 -108 109 110 111 112 113 114 115 -101 102 103 104 105 106 107 108 SELECT * FROM t4 ORDER BY c1 DESC LIMIT 2 /* comment7 */; c1 c2 c3 c4 c5 c6 c7 c8 106 122 123 125 126 127 128 128 105 115 116 118 119 120 121 122 SELECT * FROM t4 WHERE c1 = 0 ORDER BY c1 /* comment8 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 = 0 ORDER BY c1 LIMIT 2 /* comment9 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 = 0 ORDER BY c1 DESC /* comment30 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 = 0 ORDER BY c1 DESC LIMIT 2 /* comment31 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 <> 0 ORDER BY c1 /* comment10 */; c1 c2 c3 c4 c5 c6 c7 c8 -108 109 110 111 112 113 114 115 -101 102 103 104 105 106 107 108 1 32 33 34 35 36 37 38 2 NULL 104 109 NULL NULL NULL NULL 3 0 17 18 19 20 21 22 4 7 8 9 10 11 12 13 102 0 0 37 38 39 40 41 103 101 102 104 105 106 107 108 104 108 109 111 112 113 114 115 105 115 116 118 119 120 121 122 106 122 123 125 126 127 128 128 SELECT * FROM t4 WHERE c1 <> 0 ORDER BY c1 LIMIT 2 /* comment11 */; c1 c2 c3 c4 c5 c6 c7 c8 -108 109 110 111 112 113 114 115 -101 102 103 104 105 106 107 108 SELECT * FROM t4 WHERE c1 > 0 ORDER BY c1 /* comment12 */; c1 c2 c3 c4 c5 c6 c7 c8 1 32 33 34 35 36 37 38 2 NULL 104 109 NULL NULL NULL NULL 3 0 17 18 19 20 21 22 4 7 8 9 10 11 12 13 102 0 0 37 38 39 40 41 103 101 102 104 105 106 107 108 104 108 109 111 112 113 114 115 105 115 116 118 119 120 121 122 106 122 123 125 126 127 128 128 SELECT * FROM t4 WHERE c1 > 0 ORDER BY c1 LIMIT 2 /* comment13 */; c1 c2 c3 c4 c5 c6 c7 c8 1 32 33 34 35 36 37 38 2 NULL 104 109 NULL NULL NULL NULL SELECT * FROM t4 WHERE c1 >= 0 ORDER BY c1 /* comment14 */; c1 c2 c3 c4 c5 c6 c7 c8 1 32 33 34 35 36 37 38 2 NULL 104 109 NULL NULL NULL NULL 3 0 17 18 19 20 21 22 4 7 8 9 10 11 12 13 102 0 0 37 38 39 40 41 103 101 102 104 105 106 107 108 104 108 109 111 112 113 114 115 105 115 116 118 119 120 121 122 106 122 123 125 126 127 128 128 SELECT * FROM t4 WHERE c1 >= 0 ORDER BY c1 LIMIT 2 /* comment15 */; c1 c2 c3 c4 c5 c6 c7 c8 1 32 33 34 35 36 37 38 2 NULL 104 109 NULL NULL NULL NULL SELECT * FROM t4 WHERE c1 < 0 ORDER BY c1 /* comment16 */; c1 c2 c3 c4 c5 c6 c7 c8 -108 109 110 111 112 113 114 115 -101 102 103 104 105 106 107 108 SELECT * FROM t4 WHERE c1 < 0 ORDER BY c1 LIMIT 2 /* comment17 */; c1 c2 c3 c4 c5 c6 c7 c8 -108 109 110 111 112 113 114 115 -101 102 103 104 105 106 107 108 SELECT * FROM t4 WHERE c1 <= 0 ORDER BY c1 /* comment18 */; c1 c2 c3 c4 c5 c6 c7 c8 -108 109 110 111 112 113 114 115 -101 102 103 104 105 106 107 108 SELECT * FROM t4 WHERE c1 <= 0 ORDER BY c1 LIMIT 2 /* comment19 */; c1 c2 c3 c4 c5 c6 c7 c8 -108 109 110 111 112 113 114 115 -101 102 103 104 105 106 107 108 SELECT * FROM t4 WHERE c1 <=> 0 ORDER BY c1 /* comment20 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 <=> 0 ORDER BY c1 LIMIT 2 /* comment21 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 BETWEEN -101 AND 4 ORDER BY c1 /* comment22 */; c1 c2 c3 c4 c5 c6 c7 c8 -101 102 103 104 105 106 107 108 1 32 33 34 35 36 37 38 2 NULL 104 109 NULL NULL NULL NULL 3 0 17 18 19 20 21 22 4 7 8 9 10 11 12 13 SELECT * FROM t4 WHERE c1 BETWEEN -101 AND 4 ORDER BY c1 LIMIT 2 /* comment23 */; c1 c2 c3 c4 c5 c6 c7 c8 -101 102 103 104 105 106 107 108 1 32 33 34 35 36 37 38 SELECT * FROM t4 WHERE c1 IN (-101,4) ORDER BY c1 /* comment24 */; c1 c2 c3 c4 c5 c6 c7 c8 -101 102 103 104 105 106 107 108 4 7 8 9 10 11 12 13 SELECT * FROM t4 WHERE c1 IN (-101,4) ORDER BY c1 LIMIT 2 /* comment25 */; c1 c2 c3 c4 c5 c6 c7 c8 -101 102 103 104 105 106 107 108 4 7 8 9 10 11 12 13 SELECT * FROM t4 WHERE c1 >= -101 AND c1 < 4 AND c3 = 109 ORDER BY c1 #comment26; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 >= -101 AND c1 < 4 AND c3 = 109 ORDER BY c1 LIMIT 2 #comment27; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 IS NULL ORDER BY c1 /* comment28 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 IS NULL ORDER BY c1 LIMIT 2 /* comment29 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 IS NOT NULL ORDER BY c1 /* comment28 */; c1 c2 c3 c4 c5 c6 c7 c8 -108 109 110 111 112 113 114 115 -101 102 103 104 105 106 107 108 1 32 33 34 35 36 37 38 2 NULL 104 109 NULL NULL NULL NULL 3 0 17 18 19 20 21 22 4 7 8 9 10 11 12 13 102 0 0 37 38 39 40 41 103 101 102 104 105 106 107 108 104 108 109 111 112 113 114 115 105 115 116 118 119 120 121 122 106 122 123 125 126 127 128 128 SELECT * FROM t4 WHERE c1 IS NOT NULL ORDER BY c1 LIMIT 2 /* comment29 */; c1 c2 c3 c4 c5 c6 c7 c8 -108 109 110 111 112 113 114 115 -101 102 103 104 105 106 107 108 SELECT * FROM t4 WHERE c1 <> 0 ORDER BY c1 DESC /* comment32 */; c1 c2 c3 c4 c5 c6 c7 c8 106 122 123 125 126 127 128 128 105 115 116 118 119 120 121 122 104 108 109 111 112 113 114 115 103 101 102 104 105 106 107 108 102 0 0 37 38 39 40 41 4 7 8 9 10 11 12 13 3 0 17 18 19 20 21 22 2 NULL 104 109 NULL NULL NULL NULL 1 32 33 34 35 36 37 38 -101 102 103 104 105 106 107 108 -108 109 110 111 112 113 114 115 SELECT * FROM t4 WHERE c1 <> 0 ORDER BY c1 DESC LIMIT 2 /* comment33 */; c1 c2 c3 c4 c5 c6 c7 c8 106 122 123 125 126 127 128 128 105 115 116 118 119 120 121 122 SELECT * FROM t4 WHERE c1 > 0 ORDER BY c1 DESC /* comment34 */; c1 c2 c3 c4 c5 c6 c7 c8 106 122 123 125 126 127 128 128 105 115 116 118 119 120 121 122 104 108 109 111 112 113 114 115 103 101 102 104 105 106 107 108 102 0 0 37 38 39 40 41 4 7 8 9 10 11 12 13 3 0 17 18 19 20 21 22 2 NULL 104 109 NULL NULL NULL NULL 1 32 33 34 35 36 37 38 SELECT * FROM t4 WHERE c1 > 0 ORDER BY c1 DESC LIMIT 2 /* comment35 */; c1 c2 c3 c4 c5 c6 c7 c8 106 122 123 125 126 127 128 128 105 115 116 118 119 120 121 122 SELECT * FROM t4 WHERE c1 >= 0 ORDER BY c1 DESC /* comment36 */; c1 c2 c3 c4 c5 c6 c7 c8 106 122 123 125 126 127 128 128 105 115 116 118 119 120 121 122 104 108 109 111 112 113 114 115 103 101 102 104 105 106 107 108 102 0 0 37 38 39 40 41 4 7 8 9 10 11 12 13 3 0 17 18 19 20 21 22 2 NULL 104 109 NULL NULL NULL NULL 1 32 33 34 35 36 37 38 SELECT * FROM t4 WHERE c1 >= 0 ORDER BY c1 DESC LIMIT 2 /* comment37 */; c1 c2 c3 c4 c5 c6 c7 c8 106 122 123 125 126 127 128 128 105 115 116 118 119 120 121 122 SELECT * FROM t4 WHERE c1 < 0 ORDER BY c1 DESC /* comment38 */; c1 c2 c3 c4 c5 c6 c7 c8 -101 102 103 104 105 106 107 108 -108 109 110 111 112 113 114 115 SELECT * FROM t4 WHERE c1 < 0 ORDER BY c1 DESC LIMIT 2 /* comment39 */; c1 c2 c3 c4 c5 c6 c7 c8 -101 102 103 104 105 106 107 108 -108 109 110 111 112 113 114 115 SELECT * FROM t4 WHERE c1 <= 0 ORDER BY c1 DESC /* comment40 */; c1 c2 c3 c4 c5 c6 c7 c8 -101 102 103 104 105 106 107 108 -108 109 110 111 112 113 114 115 SELECT * FROM t4 WHERE c1 <= 0 ORDER BY c1 DESC LIMIT 2 /* comment41 */; c1 c2 c3 c4 c5 c6 c7 c8 -101 102 103 104 105 106 107 108 -108 109 110 111 112 113 114 115 SELECT * FROM t4 WHERE c1 <=> 0 ORDER BY c1 DESC /* comment42 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 <=> 0 ORDER BY c1 DESC LIMIT 2 /* comment43 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 BETWEEN -101 AND 4 ORDER BY c1 DESC /* comment44 */; c1 c2 c3 c4 c5 c6 c7 c8 4 7 8 9 10 11 12 13 3 0 17 18 19 20 21 22 2 NULL 104 109 NULL NULL NULL NULL 1 32 33 34 35 36 37 38 -101 102 103 104 105 106 107 108 SELECT * FROM t4 WHERE c1 BETWEEN -101 AND 4 ORDER BY c1 DESC LIMIT 2 /* comment45 */; c1 c2 c3 c4 c5 c6 c7 c8 4 7 8 9 10 11 12 13 3 0 17 18 19 20 21 22 SELECT * FROM t4 WHERE c1 IN (-101,4) ORDER BY c1 DESC /* comment46 */; c1 c2 c3 c4 c5 c6 c7 c8 4 7 8 9 10 11 12 13 -101 102 103 104 105 106 107 108 SELECT * FROM t4 WHERE c1 IN (-101,4) ORDER BY c1 DESC LIMIT 2 /* comment47 */; c1 c2 c3 c4 c5 c6 c7 c8 4 7 8 9 10 11 12 13 -101 102 103 104 105 106 107 108 SELECT * FROM t4 WHERE c1 >= -101 AND c1 < 4 AND c3 = 109 ORDER BY c1 DESC #comment48; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 >= -101 AND c1 < 4 AND c3 = 109 ORDER BY c1 DESC LIMIT 2 #comment49; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 IS NULL ORDER BY c1 DESC /* comment50 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 IS NULL ORDER BY c1 DESC LIMIT 2 /* comment51 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t4 WHERE c1 IS NOT NULL ORDER BY c1 DESC /* comment50 */; c1 c2 c3 c4 c5 c6 c7 c8 106 122 123 125 126 127 128 128 105 115 116 118 119 120 121 122 104 108 109 111 112 113 114 115 103 101 102 104 105 106 107 108 102 0 0 37 38 39 40 41 4 7 8 9 10 11 12 13 3 0 17 18 19 20 21 22 2 NULL 104 109 NULL NULL NULL NULL 1 32 33 34 35 36 37 38 -101 102 103 104 105 106 107 108 -108 109 110 111 112 113 114 115 SELECT * FROM t4 WHERE c1 IS NOT NULL ORDER BY c1 DESC LIMIT 2 /* comment51 */; c1 c2 c3 c4 c5 c6 c7 c8 106 122 123 125 126 127 128 128 105 115 116 118 119 120 121 122 SELECT * FROM t5 /* comment1 */; c1 c2 c3 c4 c5 c6 c7 c8 101 -102 -103 -104 105 106 107 108 102 0 0 37 38 39 40 41 108 -109 -110 111 112 113 114 115 109 -32 -32 33 34 35 36 37 110 0 -104 2 NULL NULL NULL NULL 111 0 -17 18 19 20 21 22 112 -1 -1 8 9 10 11 12 113 -101 -102 104 105 106 107 108 114 -108 -109 111 112 113 114 115 115 -115 -116 118 119 120 121 122 116 -122 -123 125 126 127 128 128 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) FROM t5; total_rows min_value max(c1) 11 101 116 SELECT * FROM t5 WHERE c5 = 112 /* comment2 */; c1 c2 c3 c4 c5 c6 c7 c8 108 -109 -110 111 112 113 114 115 114 -108 -109 111 112 113 114 115 SELECT c1 FROM t5 /* comment3 */; c1 101 102 108 109 110 111 112 113 114 115 116 SELECT c1 FROM t5 ORDER BY c1 DESC /* comment5 */; c1 116 115 114 113 112 111 110 109 108 102 101 SELECT * FROM t5 ORDER BY c1 LIMIT 2 /* comment6 */; c1 c2 c3 c4 c5 c6 c7 c8 101 -102 -103 -104 105 106 107 108 102 0 0 37 38 39 40 41 SELECT * FROM t5 ORDER BY c1 DESC LIMIT 2 /* comment7 */; c1 c2 c3 c4 c5 c6 c7 c8 116 -122 -123 125 126 127 128 128 115 -115 -116 118 119 120 121 122 SELECT * FROM t5 WHERE c1 = 109 ORDER BY c1 /* comment8 */; c1 c2 c3 c4 c5 c6 c7 c8 109 -32 -32 33 34 35 36 37 SELECT * FROM t5 WHERE c1 = 109 ORDER BY c1 LIMIT 2 /* comment9 */; c1 c2 c3 c4 c5 c6 c7 c8 109 -32 -32 33 34 35 36 37 SELECT * FROM t5 WHERE c1 = 109 ORDER BY c1 DESC /* comment30 */; c1 c2 c3 c4 c5 c6 c7 c8 109 -32 -32 33 34 35 36 37 SELECT * FROM t5 WHERE c1 = 109 ORDER BY c1 DESC LIMIT 2 /* comment31 */; c1 c2 c3 c4 c5 c6 c7 c8 109 -32 -32 33 34 35 36 37 SELECT * FROM t5 WHERE c1 <> 109 ORDER BY c1 /* comment10 */; c1 c2 c3 c4 c5 c6 c7 c8 101 -102 -103 -104 105 106 107 108 102 0 0 37 38 39 40 41 108 -109 -110 111 112 113 114 115 110 0 -104 2 NULL NULL NULL NULL 111 0 -17 18 19 20 21 22 112 -1 -1 8 9 10 11 12 113 -101 -102 104 105 106 107 108 114 -108 -109 111 112 113 114 115 115 -115 -116 118 119 120 121 122 116 -122 -123 125 126 127 128 128 SELECT * FROM t5 WHERE c1 <> 109 ORDER BY c1 LIMIT 2 /* comment11 */; c1 c2 c3 c4 c5 c6 c7 c8 101 -102 -103 -104 105 106 107 108 102 0 0 37 38 39 40 41 SELECT * FROM t5 WHERE c1 > 109 ORDER BY c1 /* comment12 */; c1 c2 c3 c4 c5 c6 c7 c8 110 0 -104 2 NULL NULL NULL NULL 111 0 -17 18 19 20 21 22 112 -1 -1 8 9 10 11 12 113 -101 -102 104 105 106 107 108 114 -108 -109 111 112 113 114 115 115 -115 -116 118 119 120 121 122 116 -122 -123 125 126 127 128 128 SELECT * FROM t5 WHERE c1 > 109 ORDER BY c1 LIMIT 2 /* comment13 */; c1 c2 c3 c4 c5 c6 c7 c8 110 0 -104 2 NULL NULL NULL NULL 111 0 -17 18 19 20 21 22 SELECT * FROM t5 WHERE c1 >= 109 ORDER BY c1 /* comment14 */; c1 c2 c3 c4 c5 c6 c7 c8 109 -32 -32 33 34 35 36 37 110 0 -104 2 NULL NULL NULL NULL 111 0 -17 18 19 20 21 22 112 -1 -1 8 9 10 11 12 113 -101 -102 104 105 106 107 108 114 -108 -109 111 112 113 114 115 115 -115 -116 118 119 120 121 122 116 -122 -123 125 126 127 128 128 SELECT * FROM t5 WHERE c1 >= 109 ORDER BY c1 LIMIT 2 /* comment15 */; c1 c2 c3 c4 c5 c6 c7 c8 109 -32 -32 33 34 35 36 37 110 0 -104 2 NULL NULL NULL NULL SELECT * FROM t5 WHERE c1 < 109 ORDER BY c1 /* comment16 */; c1 c2 c3 c4 c5 c6 c7 c8 101 -102 -103 -104 105 106 107 108 102 0 0 37 38 39 40 41 108 -109 -110 111 112 113 114 115 SELECT * FROM t5 WHERE c1 < 109 ORDER BY c1 LIMIT 2 /* comment17 */; c1 c2 c3 c4 c5 c6 c7 c8 101 -102 -103 -104 105 106 107 108 102 0 0 37 38 39 40 41 SELECT * FROM t5 WHERE c1 <= 109 ORDER BY c1 /* comment18 */; c1 c2 c3 c4 c5 c6 c7 c8 101 -102 -103 -104 105 106 107 108 102 0 0 37 38 39 40 41 108 -109 -110 111 112 113 114 115 109 -32 -32 33 34 35 36 37 SELECT * FROM t5 WHERE c1 <= 109 ORDER BY c1 LIMIT 2 /* comment19 */; c1 c2 c3 c4 c5 c6 c7 c8 101 -102 -103 -104 105 106 107 108 102 0 0 37 38 39 40 41 SELECT * FROM t5 WHERE c1 <=> 109 ORDER BY c1 /* comment20 */; c1 c2 c3 c4 c5 c6 c7 c8 109 -32 -32 33 34 35 36 37 SELECT * FROM t5 WHERE c1 <=> 109 ORDER BY c1 LIMIT 2 /* comment21 */; c1 c2 c3 c4 c5 c6 c7 c8 109 -32 -32 33 34 35 36 37 SELECT * FROM t5 WHERE c1 BETWEEN 0 AND 112 ORDER BY c1 /* comment22 */; c1 c2 c3 c4 c5 c6 c7 c8 101 -102 -103 -104 105 106 107 108 102 0 0 37 38 39 40 41 108 -109 -110 111 112 113 114 115 109 -32 -32 33 34 35 36 37 110 0 -104 2 NULL NULL NULL NULL 111 0 -17 18 19 20 21 22 112 -1 -1 8 9 10 11 12 SELECT * FROM t5 WHERE c1 BETWEEN 0 AND 112 ORDER BY c1 LIMIT 2 /* comment23 */; c1 c2 c3 c4 c5 c6 c7 c8 101 -102 -103 -104 105 106 107 108 102 0 0 37 38 39 40 41 SELECT * FROM t5 WHERE c1 IN (0,112) ORDER BY c1 /* comment24 */; c1 c2 c3 c4 c5 c6 c7 c8 112 -1 -1 8 9 10 11 12 SELECT * FROM t5 WHERE c1 IN (0,112) ORDER BY c1 LIMIT 2 /* comment25 */; c1 c2 c3 c4 c5 c6 c7 c8 112 -1 -1 8 9 10 11 12 SELECT * FROM t5 WHERE c1 >= 0 AND c1 < 112 AND c2 = -108 ORDER BY c1 #comment26; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t5 WHERE c1 >= 0 AND c1 < 112 AND c2 = -108 ORDER BY c1 LIMIT 2 #comment27; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t5 WHERE c1 IS NULL ORDER BY c1 /* comment28 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t5 WHERE c1 IS NULL ORDER BY c1 LIMIT 2 /* comment29 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t5 WHERE c1 IS NOT NULL ORDER BY c1 /* comment28 */; c1 c2 c3 c4 c5 c6 c7 c8 101 -102 -103 -104 105 106 107 108 102 0 0 37 38 39 40 41 108 -109 -110 111 112 113 114 115 109 -32 -32 33 34 35 36 37 110 0 -104 2 NULL NULL NULL NULL 111 0 -17 18 19 20 21 22 112 -1 -1 8 9 10 11 12 113 -101 -102 104 105 106 107 108 114 -108 -109 111 112 113 114 115 115 -115 -116 118 119 120 121 122 116 -122 -123 125 126 127 128 128 SELECT * FROM t5 WHERE c1 IS NOT NULL ORDER BY c1 LIMIT 2 /* comment29 */; c1 c2 c3 c4 c5 c6 c7 c8 101 -102 -103 -104 105 106 107 108 102 0 0 37 38 39 40 41 SELECT * FROM t5 WHERE c1 <> 109 ORDER BY c1 DESC /* comment32 */; c1 c2 c3 c4 c5 c6 c7 c8 116 -122 -123 125 126 127 128 128 115 -115 -116 118 119 120 121 122 114 -108 -109 111 112 113 114 115 113 -101 -102 104 105 106 107 108 112 -1 -1 8 9 10 11 12 111 0 -17 18 19 20 21 22 110 0 -104 2 NULL NULL NULL NULL 108 -109 -110 111 112 113 114 115 102 0 0 37 38 39 40 41 101 -102 -103 -104 105 106 107 108 SELECT * FROM t5 WHERE c1 <> 109 ORDER BY c1 DESC LIMIT 2 /* comment33 */; c1 c2 c3 c4 c5 c6 c7 c8 116 -122 -123 125 126 127 128 128 115 -115 -116 118 119 120 121 122 SELECT * FROM t5 WHERE c1 > 109 ORDER BY c1 DESC /* comment34 */; c1 c2 c3 c4 c5 c6 c7 c8 116 -122 -123 125 126 127 128 128 115 -115 -116 118 119 120 121 122 114 -108 -109 111 112 113 114 115 113 -101 -102 104 105 106 107 108 112 -1 -1 8 9 10 11 12 111 0 -17 18 19 20 21 22 110 0 -104 2 NULL NULL NULL NULL SELECT * FROM t5 WHERE c1 > 109 ORDER BY c1 DESC LIMIT 2 /* comment35 */; c1 c2 c3 c4 c5 c6 c7 c8 116 -122 -123 125 126 127 128 128 115 -115 -116 118 119 120 121 122 SELECT * FROM t5 WHERE c1 >= 109 ORDER BY c1 DESC /* comment36 */; c1 c2 c3 c4 c5 c6 c7 c8 116 -122 -123 125 126 127 128 128 115 -115 -116 118 119 120 121 122 114 -108 -109 111 112 113 114 115 113 -101 -102 104 105 106 107 108 112 -1 -1 8 9 10 11 12 111 0 -17 18 19 20 21 22 110 0 -104 2 NULL NULL NULL NULL 109 -32 -32 33 34 35 36 37 SELECT * FROM t5 WHERE c1 >= 109 ORDER BY c1 DESC LIMIT 2 /* comment37 */; c1 c2 c3 c4 c5 c6 c7 c8 116 -122 -123 125 126 127 128 128 115 -115 -116 118 119 120 121 122 SELECT * FROM t5 WHERE c1 < 109 ORDER BY c1 DESC /* comment38 */; c1 c2 c3 c4 c5 c6 c7 c8 108 -109 -110 111 112 113 114 115 102 0 0 37 38 39 40 41 101 -102 -103 -104 105 106 107 108 SELECT * FROM t5 WHERE c1 < 109 ORDER BY c1 DESC LIMIT 2 /* comment39 */; c1 c2 c3 c4 c5 c6 c7 c8 108 -109 -110 111 112 113 114 115 102 0 0 37 38 39 40 41 SELECT * FROM t5 WHERE c1 <= 109 ORDER BY c1 DESC /* comment40 */; c1 c2 c3 c4 c5 c6 c7 c8 109 -32 -32 33 34 35 36 37 108 -109 -110 111 112 113 114 115 102 0 0 37 38 39 40 41 101 -102 -103 -104 105 106 107 108 SELECT * FROM t5 WHERE c1 <= 109 ORDER BY c1 DESC LIMIT 2 /* comment41 */; c1 c2 c3 c4 c5 c6 c7 c8 109 -32 -32 33 34 35 36 37 108 -109 -110 111 112 113 114 115 SELECT * FROM t5 WHERE c1 <=> 109 ORDER BY c1 DESC /* comment42 */; c1 c2 c3 c4 c5 c6 c7 c8 109 -32 -32 33 34 35 36 37 SELECT * FROM t5 WHERE c1 <=> 109 ORDER BY c1 DESC LIMIT 2 /* comment43 */; c1 c2 c3 c4 c5 c6 c7 c8 109 -32 -32 33 34 35 36 37 SELECT * FROM t5 WHERE c1 BETWEEN 0 AND 112 ORDER BY c1 DESC /* comment44 */; c1 c2 c3 c4 c5 c6 c7 c8 112 -1 -1 8 9 10 11 12 111 0 -17 18 19 20 21 22 110 0 -104 2 NULL NULL NULL NULL 109 -32 -32 33 34 35 36 37 108 -109 -110 111 112 113 114 115 102 0 0 37 38 39 40 41 101 -102 -103 -104 105 106 107 108 SELECT * FROM t5 WHERE c1 BETWEEN 0 AND 112 ORDER BY c1 DESC LIMIT 2 /* comment45 */; c1 c2 c3 c4 c5 c6 c7 c8 112 -1 -1 8 9 10 11 12 111 0 -17 18 19 20 21 22 SELECT * FROM t5 WHERE c1 IN (0,112) ORDER BY c1 DESC /* comment46 */; c1 c2 c3 c4 c5 c6 c7 c8 112 -1 -1 8 9 10 11 12 SELECT * FROM t5 WHERE c1 IN (0,112) ORDER BY c1 DESC LIMIT 2 /* comment47 */; c1 c2 c3 c4 c5 c6 c7 c8 112 -1 -1 8 9 10 11 12 SELECT * FROM t5 WHERE c1 >= 0 AND c1 < 112 AND c2 = -108 ORDER BY c1 DESC #comment48; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t5 WHERE c1 >= 0 AND c1 < 112 AND c2 = -108 ORDER BY c1 DESC LIMIT 2 #comment49; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t5 WHERE c1 IS NULL ORDER BY c1 DESC /* comment50 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t5 WHERE c1 IS NULL ORDER BY c1 DESC LIMIT 2 /* comment51 */; c1 c2 c3 c4 c5 c6 c7 c8 SELECT * FROM t5 WHERE c1 IS NOT NULL ORDER BY c1 DESC /* comment50 */; c1 c2 c3 c4 c5 c6 c7 c8 116 -122 -123 125 126 127 128 128 115 -115 -116 118 119 120 121 122 114 -108 -109 111 112 113 114 115 113 -101 -102 104 105 106 107 108 112 -1 -1 8 9 10 11 12 111 0 -17 18 19 20 21 22 110 0 -104 2 NULL NULL NULL NULL 109 -32 -32 33 34 35 36 37 108 -109 -110 111 112 113 114 115 102 0 0 37 38 39 40 41 101 -102 -103 -104 105 106 107 108 SELECT * FROM t5 WHERE c1 IS NOT NULL ORDER BY c1 DESC LIMIT 2 /* comment51 */; c1 c2 c3 c4 c5 c6 c7 c8 116 -122 -123 125 126 127 128 128 115 -115 -116 118 119 120 121 122 SELECT * FROM t4 WHERE c1=1 OR c2=109; c1 c2 c3 c4 c5 c6 c7 c8 -108 109 110 111 112 113 114 115 1 32 33 34 35 36 37 38 SELECT c2 FROM t4 GROUP BY c2; c2 0 101 102 108 109 115 122 32 7 NULL SELECT DISTINCT c2 FROM t4; c2 0 101 102 108 109 115 122 32 7 NULL SELECT c2,MIN(c3) FROM t4 GROUP BY c2; c2 MIN(c3) 0 0 101 102 102 103 108 109 109 110 115 116 122 123 32 33 7 8 NULL 104 INSERT INTO t2(c1) VALUES(NULL); ERROR 23000: Column 'c1' cannot be null INSERT INTO t3 VALUES(NULL,1,2,3,4,5,6); ERROR 23000: Column 'c1' cannot be null INSERT INTO t4(c3) VALUES(NULL); ERROR 23000: Column 'c3' cannot be null INSERT INTO t5(c3) VALUES(NULL); ERROR 23000: Column 'c3' cannot be null INSERT INTO t4(c1,c3) VALUES(-101,105) /*throws error as the row with c1=-101 exists */; ERROR 23000: Duplicate entry '-101' for key 'PRIMARY' INSERT INTO t2(c1,c6) VALUES(101,106) /*throws error as the row with c1=101,c6=106 exists */; ERROR 23000: Duplicate entry '101-106' for key 'PRIMARY' INSERT INTO t5(c1,c2,c3) VALUES(101,-102,4) /*throws error as the row with c1=101,c2=-102 exists */; ERROR 23000: Duplicate entry '101--102' for key 'PRIMARY' INSERT INTO t5(c3) VALUES(-103) /*throws error as the row with c3=-103 exists */; ERROR 23000: Duplicate entry '-103' for key 'c3' INSERT INTO t4(c2,c3) VALUES(102,103) /*throws error as the row with c2=102,c3=103 exists */; ERROR 23000: Duplicate entry '102-103' for key 'idx' CREATE TABLE t6(c1 TINYINT UNSIGNED NOT NULL, c2 TINYINT NULL, c3 SMALLINT, c4 MEDIUMINT , c5 INT, c6 INTEGER, c7 BIGINT); INSERT INTO t6 SELECT * FROM t2 where c1 >= 109; SELECT * FROM t6; c1 c2 c3 c4 c5 c6 c7 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 TRUNCATE TABLE t6; INSERT INTO t6 SELECT * FROM t3 where c2 <= -116; SELECT * FROM t6; c1 c2 c3 c4 c5 c6 c7 115 -116 117 118 119 120 121 122 -123 124 125 126 127 128 TRUNCATE TABLE t6; CREATE TABLE t7(c1 TINYINT UNSIGNED NOT NULL PRIMARY KEY, c2 TINYINT NULL, c3 SMALLINT, c4 MEDIUMINT , c5 INT, c6 INTEGER, c7 BIGINT); CREATE TABLE t8(c1 TINYINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, c2 TINYINT NULL, c3 SMALLINT, c4 MEDIUMINT , c5 INT, c6 INTEGER, c7 BIGINT); INSERT INTO t6 VALUES(1,-2,2,2,2,2,2),(1,-3,3,3,3,3,3); INSERT INTO t7(c1) SELECT t6.c1 FROM t6 LIMIT 1; SELECT * FROM t7; c1 c2 c3 c4 c5 c6 c7 1 NULL NULL NULL NULL NULL NULL INSERT INTO t8(c1) SELECT t6.c1 FROM t6 LIMIT 1; SELECT * FROM t8; c1 c2 c3 c4 c5 c6 c7 1 NULL NULL NULL NULL NULL NULL INSERT INTO t7(c1) SELECT t6.c1 FROM t6 /* throws error as t6 contains duplicate rows for c1=1 */; ERROR 23000: Duplicate entry '1' for key 'PRIMARY' INSERT INTO t8(c1) SELECT t6.c1 FROM t6 /* throws error as t6 contains duplicate rows for c1=1 */; ERROR 23000: Duplicate entry '1' for key 'PRIMARY' TRUNCATE TABLE t6; INSERT INTO t6 VALUES(5,-1,1,1,1,1,1),(6,-2,2,2,2,2,2),(0,-4,4,4,4,4,4),(NULL,-5,5,5,5,5,5); Warnings: Warning 1048 Column 'c1' cannot be null INSERT INTO t8 SELECT * FROM t6; SELECT LAST_INSERT_ID() AS last_insert_id; last_insert_id 7 SELECT * FROM t8; c1 c2 c3 c4 c5 c6 c7 1 NULL NULL NULL NULL NULL NULL 5 -1 1 1 1 1 1 6 -2 2 2 2 2 2 7 -4 4 4 4 4 4 8 -5 5 5 5 5 5 TRUNCATE TABLE t8; INSERT INTO t8(c2) SELECT c2 FROM t6 WHERE c1 >= 6; SELECT * FROM t8; c1 c2 c3 c4 c5 c6 c7 1 -2 NULL NULL NULL NULL NULL DROP TABLE t6,t7,t8; INSERT INTO t2 SET c3=5,c4=6; Warnings: Warning 1364 Field 'c1' doesn't have a default value SET SQL_MODE=STRICT_ALL_TABLES; INSERT INTO t2 SET c3=5,c4=6; ERROR HY000: Field 'c1' doesn't have a default value SET SQL_MODE=''; INSERT INTO t1 VALUES(0,-128,1,2,3,4,5),(255,127,6,7,8,9,10); INSERT INTO t2 VALUES(0,-128,1,2,3,4,5),(255,127,6,7,8,9,10); INSERT INTO t3 VALUES(0,-128,1,2,3,4,5),(255,127,6,7,8,9,10); INSERT INTO t4 VALUES(-128,0,1,2,3,4,5,5),(127,255,6,7,8,9,10,10); INSERT INTO t5 VALUES(0,-128,1,2,3,4,5,5),(255,127,6,7,8,9,10,10); INSERT INTO t4(c2,c3) VALUES(31,32) /* tries to increment out of range */; ERROR 23000: Duplicate entry '127' for key 'PRIMARY' INSERT INTO t5(c2,c3) VALUES(33,34) /* tries to increment out of range */; Warnings: Warning 1264 Out of range value for column 'c1' at row 1 SELECT * FROM t4; c1 c2 c3 c4 c5 c6 c7 c8 -101 102 103 104 105 106 107 108 -108 109 110 111 112 113 114 115 -128 0 1 2 3 4 5 5 1 32 33 34 35 36 37 38 102 0 0 37 38 39 40 41 103 101 102 104 105 106 107 108 104 108 109 111 112 113 114 115 105 115 116 118 119 120 121 122 106 122 123 125 126 127 128 128 127 255 6 7 8 9 10 10 2 NULL 104 109 NULL NULL NULL NULL 3 0 17 18 19 20 21 22 4 7 8 9 10 11 12 13 SELECT * FROM t5; c1 c2 c3 c4 c5 c6 c7 c8 101 -102 -103 -104 105 106 107 108 102 0 0 37 38 39 40 41 108 -109 -110 111 112 113 114 115 109 -32 -32 33 34 35 36 37 110 0 -104 2 NULL NULL NULL NULL 111 0 -17 18 19 20 21 22 112 -1 -1 8 9 10 11 12 113 -101 -102 104 105 106 107 108 114 -108 -109 111 112 113 114 115 115 -115 -116 118 119 120 121 122 116 -122 -123 125 126 127 128 128 117 -128 1 2 3 4 5 5 255 127 6 7 8 9 10 10 255 33 34 NULL NULL NULL NULL NULL drop table t1,t2,t3,t4,t5;