You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: mysql-test/r/innodb_explain_non_select_all.result
+16-16Lines changed: 16 additions & 16 deletions
Original file line number
Diff line number
Diff line change
@@ -1311,8 +1311,8 @@ EXPLAIN EXTENDED DELETE FROM t1 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
1311
1311
id select_type table type possible_keys key key_len ref rows filtered Extra
1312
1312
1 SIMPLE t1 ALL i NULL NULL NULL 26 100.00 Using where; Using filesort
1313
1313
Warnings:
1314
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1315
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1314
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1315
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1316
1316
# Status of EXPLAIN EXTENDED query
1317
1317
Variable_name Value
1318
1318
FLUSH STATUS;
@@ -1321,10 +1321,10 @@ EXPLAIN EXTENDED SELECT * FROM t1 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
1321
1321
id select_type table type possible_keys key key_len ref rows filtered Extra
1322
1322
1 SIMPLE t1 ALL i NULL NULL NULL 26 100.00 Using where; Using filesort
1323
1323
Warnings:
1324
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1325
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1326
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1327
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1324
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1325
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1326
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1327
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1328
1328
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`i` AS `i` from `test`.`t1` where ((`test`.`t1`.`i` > 10) and (`test`.`t1`.`i` <= 18)) order by `test`.`t1`.`i` limit 5
1329
1329
# Status of EXPLAIN EXTENDED "equivalent" SELECT query execution
1330
1330
Variable_name Value
@@ -1458,7 +1458,7 @@ EXPLAIN EXTENDED DELETE FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
1458
1458
id select_type table type possible_keys key key_len ref rows filtered Extra
1459
1459
1 SIMPLE t2 ALL a NULL NULL NULL 26 100.00 Using where; Using filesort
1460
1460
Warnings:
1461
-
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
1461
+
Warning 1737 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
1462
1462
# Status of EXPLAIN EXTENDED query
1463
1463
Variable_name Value
1464
1464
FLUSH STATUS;
@@ -1509,7 +1509,7 @@ EXPLAIN EXTENDED DELETE FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
1509
1509
id select_type table type possible_keys key key_len ref rows filtered Extra
1510
1510
1 SIMPLE t2 ALL a NULL NULL NULL 26 100.00 Using where; Using filesort
1511
1511
Warnings:
1512
-
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
1512
+
Warning 1737 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
1513
1513
# Status of EXPLAIN EXTENDED query
1514
1514
Variable_name Value
1515
1515
FLUSH STATUS;
@@ -1779,8 +1779,8 @@ EXPLAIN EXTENDED UPDATE t2 SET a = 10 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT
1779
1779
id select_type table type possible_keys key key_len ref rows filtered Extra
1780
1780
1 SIMPLE t2 ALL i NULL NULL NULL 26 100.00 Using where; Using filesort
1781
1781
Warnings:
1782
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1783
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1782
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1783
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1784
1784
# Status of EXPLAIN EXTENDED query
1785
1785
Variable_name Value
1786
1786
FLUSH STATUS;
@@ -1789,10 +1789,10 @@ EXPLAIN EXTENDED SELECT * FROM t2 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT
1789
1789
id select_type table type possible_keys key key_len ref rows filtered Extra
1790
1790
1 SIMPLE t2 ALL i NULL NULL NULL 26 100.00 Using where; Using filesort
1791
1791
Warnings:
1792
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1793
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1794
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1795
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1792
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1793
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1794
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1795
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1796
1796
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`i` AS `i` from `test`.`t2` where ((`test`.`t2`.`i` > 10) and (`test`.`t2`.`i` <= 18)) order by `test`.`t2`.`i` limit 5
1797
1797
# Status of EXPLAIN EXTENDED "equivalent" SELECT query execution
1798
1798
Variable_name Value
@@ -1927,7 +1927,7 @@ EXPLAIN EXTENDED UPDATE t2 SET d = 10 WHERE b = 10 ORDER BY a, c LIMIT 5;
1927
1927
id select_type table type possible_keys key key_len ref rows filtered Extra
1928
1928
1 SIMPLE t2 ALL a NULL NULL NULL 26 100.00 Using where; Using filesort
1929
1929
Warnings:
1930
-
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
1930
+
Warning 1737 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
1931
1931
# Status of EXPLAIN EXTENDED query
1932
1932
Variable_name Value
1933
1933
FLUSH STATUS;
@@ -1978,7 +1978,7 @@ EXPLAIN EXTENDED UPDATE t2 SET d = 10 WHERE b = 10 ORDER BY a, c LIMIT 5;
1978
1978
id select_type table type possible_keys key key_len ref rows filtered Extra
1979
1979
1 SIMPLE t2 ALL a NULL NULL NULL 26 100.00 Using where; Using filesort
1980
1980
Warnings:
1981
-
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
1981
+
Warning 1737 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
Copy file name to clipboardExpand all lines: mysql-test/r/innodb_explain_non_select_none.result
+16-16Lines changed: 16 additions & 16 deletions
Original file line number
Diff line number
Diff line change
@@ -1313,8 +1313,8 @@ EXPLAIN EXTENDED DELETE FROM t1 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
1313
1313
id select_type table type possible_keys key key_len ref rows filtered Extra
1314
1314
1 SIMPLE t1 ALL i NULL NULL NULL 26 100.00 Using where; Using filesort
1315
1315
Warnings:
1316
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1317
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1316
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1317
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1318
1318
# Status of EXPLAIN EXTENDED query
1319
1319
Variable_name Value
1320
1320
FLUSH STATUS;
@@ -1323,10 +1323,10 @@ EXPLAIN EXTENDED SELECT * FROM t1 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
1323
1323
id select_type table type possible_keys key key_len ref rows filtered Extra
1324
1324
1 SIMPLE t1 ALL i NULL NULL NULL 26 100.00 Using where; Using filesort
1325
1325
Warnings:
1326
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1327
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1328
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1329
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1326
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1327
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1328
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1329
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1330
1330
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`i` AS `i` from `test`.`t1` where ((`test`.`t1`.`i` > 10) and (`test`.`t1`.`i` <= 18)) order by `test`.`t1`.`i` limit 5
1331
1331
# Status of EXPLAIN EXTENDED "equivalent" SELECT query execution
1332
1332
Variable_name Value
@@ -1460,7 +1460,7 @@ EXPLAIN EXTENDED DELETE FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
1460
1460
id select_type table type possible_keys key key_len ref rows filtered Extra
1461
1461
1 SIMPLE t2 ALL a NULL NULL NULL 26 100.00 Using where; Using filesort
1462
1462
Warnings:
1463
-
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
1463
+
Warning 1737 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
1464
1464
# Status of EXPLAIN EXTENDED query
1465
1465
Variable_name Value
1466
1466
FLUSH STATUS;
@@ -1511,7 +1511,7 @@ EXPLAIN EXTENDED DELETE FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
1511
1511
id select_type table type possible_keys key key_len ref rows filtered Extra
1512
1512
1 SIMPLE t2 ALL a NULL NULL NULL 26 100.00 Using where; Using filesort
1513
1513
Warnings:
1514
-
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
1514
+
Warning 1737 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
1515
1515
# Status of EXPLAIN EXTENDED query
1516
1516
Variable_name Value
1517
1517
FLUSH STATUS;
@@ -1781,8 +1781,8 @@ EXPLAIN EXTENDED UPDATE t2 SET a = 10 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT
1781
1781
id select_type table type possible_keys key key_len ref rows filtered Extra
1782
1782
1 SIMPLE t2 ALL i NULL NULL NULL 26 100.00 Using where; Using filesort
1783
1783
Warnings:
1784
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1785
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1784
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1785
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1786
1786
# Status of EXPLAIN EXTENDED query
1787
1787
Variable_name Value
1788
1788
FLUSH STATUS;
@@ -1791,10 +1791,10 @@ EXPLAIN EXTENDED SELECT * FROM t2 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT
1791
1791
id select_type table type possible_keys key key_len ref rows filtered Extra
1792
1792
1 SIMPLE t2 ALL i NULL NULL NULL 26 100.00 Using where; Using filesort
1793
1793
Warnings:
1794
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1795
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1796
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1797
-
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1794
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1795
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1796
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1797
+
Warning 1737 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
1798
1798
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`i` AS `i` from `test`.`t2` where ((`test`.`t2`.`i` > 10) and (`test`.`t2`.`i` <= 18)) order by `test`.`t2`.`i` limit 5
1799
1799
# Status of EXPLAIN EXTENDED "equivalent" SELECT query execution
1800
1800
Variable_name Value
@@ -1929,7 +1929,7 @@ EXPLAIN EXTENDED UPDATE t2 SET d = 10 WHERE b = 10 ORDER BY a, c LIMIT 5;
1929
1929
id select_type table type possible_keys key key_len ref rows filtered Extra
1930
1930
1 SIMPLE t2 ALL a NULL NULL NULL 26 100.00 Using where; Using filesort
1931
1931
Warnings:
1932
-
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
1932
+
Warning 1737 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
1933
1933
# Status of EXPLAIN EXTENDED query
1934
1934
Variable_name Value
1935
1935
FLUSH STATUS;
@@ -1980,7 +1980,7 @@ EXPLAIN EXTENDED UPDATE t2 SET d = 10 WHERE b = 10 ORDER BY a, c LIMIT 5;
1980
1980
id select_type table type possible_keys key key_len ref rows filtered Extra
1981
1981
1 SIMPLE t2 ALL a NULL NULL NULL 26 100.00 Using where; Using filesort
1982
1982
Warnings:
1983
-
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
1983
+
Warning 1737 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
0 commit comments