3500 horst.hunger@stripped 2011-11-21
Disabled automatic validation due to Python problems on some PB machines.
modified:
mysql-test/r/innodb_explain_json_non_select_all.result
mysql-test/r/innodb_explain_json_non_select_none.result
mysql-test/r/myisam_explain_json_non_select_all.result
mysql-test/r/myisam_explain_json_non_select_none.result
mysql-test/t/innodb_explain_json_non_select_all.test
mysql-test/t/innodb_explain_json_non_select_none.test
mysql-test/t/myisam_explain_json_non_select_all.test
mysql-test/t/myisam_explain_json_non_select_none.test
3499 horst.hunger@stripped 2011-11-18
Fixed 2 bugs: in regluar expression and call od validator on Windows.
modified:
mysql-test/include/explain_utils.inc
=== modified file 'mysql-test/r/innodb_explain_json_non_select_all.result'
--- a/mysql-test/r/innodb_explain_json_non_select_all.result 2011-11-16 15:09:45 +0000
+++ b/mysql-test/r/innodb_explain_json_non_select_all.result 2011-11-21 11:46:42 +0000
@@ -34,12 +34,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a < 10;
@@ -66,12 +60,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` < 10)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -117,12 +105,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a < 10;
@@ -149,12 +131,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` < 10)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -200,12 +176,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a = 1;
@@ -232,12 +202,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` = 1)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -302,12 +266,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, t2 WHERE t1.a = 1;
@@ -350,12 +308,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t2`.`b` AS `b` from `test`.`t1` join `test`.`t2` where (`test`.`t1`.`a` = 1)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -432,12 +384,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 t11, (SELECT * FROM t2) t12 WHERE t11.a = 1;
@@ -491,12 +437,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,`t12`.`b` AS `b` from `test`.`t1` `t11` join (/* select#2 */ select `test`.`t2`.`b` AS `b` from `test`.`t2`) `t12` where (`test`.`t11`.`a` = 1)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -565,12 +505,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE 1 IN (SELECT 1 FROM t2 WHERE t2.b < 3);
@@ -614,12 +548,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` semi join (`test`.`t2`) where (`test`.`t2`.`b` < 3)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -690,12 +618,6 @@ EXPLAIN
}
Warnings:
Note 1276 Field or reference 'test.t1.a' of SELECT #2 was resolved in SELECT #1
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a IN (SELECT b FROM t2 WHERE t1.a < 3);
@@ -742,12 +664,6 @@ EXPLAIN
Warnings:
Note 1276 Field or reference 'test.t1.a' of SELECT #2 was resolved in SELECT #1
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` semi join (`test`.`t2`) where ((`test`.`t2`.`b` = `test`.`t1`.`a`) and (`test`.`t1`.`a` < 3))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -827,12 +743,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, t2 WHERE a IN (SELECT b FROM t2 WHERE t2.b < 3);
@@ -889,12 +799,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t2`.`b` AS `b` from `test`.`t1` semi join (`test`.`t2`) join `test`.`t2` where ((`test`.`t2`.`b` = `test`.`t1`.`a`) and (`test`.`t1`.`a` < 3))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 3
@@ -968,12 +872,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 t11, (SELECT * FROM t2) t12;
@@ -1024,12 +922,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,`t12`.`b` AS `b` from `test`.`t1` `t11` join (/* select#2 */ select `test`.`t2`.`b` AS `b` from `test`.`t2`) `t12`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -1105,12 +997,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 t11, (SELECT 1 FROM DUAL) t12;
@@ -1160,12 +1046,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,'1' AS `1` from `test`.`t1` `t11`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -1245,12 +1125,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 t11, (SELECT * FROM t2) t12 WHERE t11.a > 1;
@@ -1304,12 +1178,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,`t12`.`b` AS `b` from `test`.`t1` `t11` join (/* select#2 */ select `test`.`t2`.`b` AS `b` from `test`.`t2`) `t12` where (`test`.`t11`.`a` > 1)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -1357,12 +1225,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a > 1 LIMIT 1;
@@ -1389,12 +1251,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` > 1) limit 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -1436,12 +1292,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE 0;
@@ -1464,12 +1314,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where 0
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
# Status of testing query execution:
@@ -1504,12 +1348,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE 0;
@@ -1532,12 +1370,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where 0
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
# Status of testing query execution:
@@ -1580,12 +1412,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a = 3;
@@ -1614,12 +1440,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select '3' AS `a`,'3' AS `b` from `test`.`t1` where 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 4
@@ -1665,12 +1485,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a < 3;
@@ -1702,12 +1516,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1` where (`test`.`t1`.`a` < 3)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 9
@@ -1751,12 +1559,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE t1.a > 0 ORDER BY t1.a;
@@ -1788,12 +1590,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` > 0) order by `test`.`t1`.`a`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -1836,12 +1632,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE t1.a > 0 ORDER BY t1.a;
@@ -1873,12 +1663,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` > 0) order by `test`.`t1`.`a`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -1927,12 +1711,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE (@a:= a) ORDER BY a LIMIT 1;
@@ -1963,12 +1741,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (@a:=`test`.`t1`.`a`) order by `test`.`t1`.`a` limit 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -2015,12 +1787,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 ORDER BY a ASC, b ASC LIMIT 1;
@@ -2048,12 +1814,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b`,`test`.`t1`.`c` AS `c` from `test`.`t1` order by `test`.`t1`.`a`,`test`.`t1`.`b` limit 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -2138,12 +1898,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1,t2,t3 WHERE a1=a2 AND b2=a3 AND b1=b3;
@@ -2204,12 +1958,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a1` AS `a1`,`test`.`t1`.`b1` AS `b1`,`test`.`t2`.`a2` AS `a2`,`test`.`t2`.`b2` AS `b2`,`test`.`t3`.`a3` AS `a3`,`test`.`t3`.`b3` AS `b3` from `test`.`t1` join `test`.`t2` join `test`.`t3` where ((`test`.`t3`.`b3` = `test`.`t1`.`b1`) and (`test`.`t3`.`a3` = `test`.`t2`.`b2`) and (`test`.`t2`.`a2` = `test`.`t1`.`a1`))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -2279,12 +2027,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a IN (SELECT a FROM t2);
@@ -2326,12 +2068,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` semi join (`test`.`t2`) where (`test`.`t2`.`a` = `test`.`t1`.`a`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -2399,12 +2135,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a1 IN (SELECT a2 FROM t2 WHERE a2 > 2);
@@ -2449,12 +2179,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a1` AS `a1` from `test`.`t1` where <in_optimizer>(`test`.`t1`.`a1`,<exists>(/* select#2 */ select 1 from `test`.`t2` where ((`test`.`t2`.`a2` > 2) and (<cache>(`test`.`t1`.`a1`) = `test`.`t2`.`a2`))))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 6
@@ -2518,12 +2242,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a1 IN (SELECT a2 FROM t2 WHERE a2 > 2);
@@ -2565,12 +2283,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a1` AS `a1` from `test`.`t1` semi join (`test`.`t2`) where ((`test`.`t2`.`a2` > 2) and (`test`.`t1`.`a1` = `test`.`t2`.`a2`))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -2613,12 +2325,6 @@ EXPLAIN
"filtered": 100
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -2642,12 +2348,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i`,`test`.`t1`.`j` AS `j` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -2690,12 +2390,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -2719,12 +2413,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i`,`test`.`t1`.`j` AS `j` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -2779,12 +2467,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -2814,12 +2496,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -2863,12 +2539,6 @@ EXPLAIN
"filtered": 100
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -2892,12 +2562,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -2941,12 +2605,6 @@ EXPLAIN
"filtered": 100
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -2970,12 +2628,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -3016,12 +2668,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of testing query execution:
Variable_name Value
Handler_write 1
@@ -3054,12 +2700,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of testing query execution:
Variable_name Value
Handler_write 1
@@ -3103,12 +2743,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
@@ -3139,12 +2773,6 @@ EXPLAIN
}
Warnings:
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
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 5
@@ -3199,12 +2827,6 @@ EXPLAIN
Warnings:
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
@@ -3242,12 +2864,6 @@ Warning 1713 Cannot use range access on
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
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
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -3305,12 +2921,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -3339,12 +2949,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -3404,12 +3008,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -3439,12 +3037,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -3501,12 +3093,6 @@ EXPLAIN
}
Warnings:
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -3535,12 +3121,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -3602,12 +3182,6 @@ EXPLAIN
}
Warnings:
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -3635,12 +3209,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd 1
@@ -3695,12 +3263,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE key1 < 13 or key2 < 14 ORDER BY key1;
@@ -3730,12 +3292,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`i` AS `i`,`test`.`t2`.`key1` AS `key1`,`test`.`t2`.`key2` AS `key2` from `test`.`t2` where ((`test`.`t2`.`key1` < 13) or (`test`.`t2`.`key2` < 14)) order by `test`.`t2`.`key1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -3794,12 +3350,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE i > 10 AND i <= 18 ORDER BY i DESC LIMIT 5;
@@ -3830,12 +3380,6 @@ EXPLAIN
}
Warnings:
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` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 5
@@ -3885,12 +3429,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 ORDER BY a, b DESC LIMIT 5;
@@ -3918,12 +3456,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c` from `test`.`t2` order by `test`.`t2`.`a`,`test`.`t2`.`b` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -3980,12 +3512,6 @@ EXPLAIN
"filtered": "X"
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 ORDER BY a DESC, b DESC LIMIT 5;
@@ -4012,12 +3538,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c` from `test`.`t2` order by `test`.`t2`.`a` desc,`test`.`t2`.`b` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 3
@@ -4072,12 +3592,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
@@ -4108,12 +3622,6 @@ EXPLAIN
}
Warnings:
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
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 5
@@ -4171,12 +3679,6 @@ EXPLAIN
Warnings:
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
@@ -4214,12 +3716,6 @@ Warning 1713 Cannot use range access on
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
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
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -4277,12 +3773,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -4311,12 +3801,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -4377,12 +3861,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -4412,12 +3890,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -4475,12 +3947,6 @@ EXPLAIN
}
Warnings:
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -4509,12 +3975,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -4575,12 +4035,6 @@ EXPLAIN
}
Warnings:
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -4608,12 +4062,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd 1
@@ -4667,12 +4115,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE key1 < 13 or key2 < 14 ORDER BY key1;
@@ -4702,12 +4144,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`i` AS `i`,`test`.`t2`.`key1` AS `key1`,`test`.`t2`.`key2` AS `key2` from `test`.`t2` where ((`test`.`t2`.`key1` < 13) or (`test`.`t2`.`key2` < 14)) order by `test`.`t2`.`key1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -4767,12 +4203,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE i > 10 AND i <= 18 ORDER BY i DESC LIMIT 5;
@@ -4803,12 +4233,6 @@ EXPLAIN
}
Warnings:
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` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 5
@@ -4859,12 +4283,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 ORDER BY a, b DESC LIMIT 5;
@@ -4892,12 +4310,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c` from `test`.`t2` order by `test`.`t2`.`a`,`test`.`t2`.`b` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -4957,12 +4369,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 ORDER BY a DESC, b DESC LIMIT 5;
@@ -4989,12 +4395,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c` from `test`.`t2` order by `test`.`t2`.`a` desc,`test`.`t2`.`b` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 3
@@ -5052,12 +4452,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE c1_idx = 'y' ORDER BY pk DESC LIMIT 2;
@@ -5090,12 +4484,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`pk` AS `pk`,`test`.`t1`.`c1_idx` AS `c1_idx`,`test`.`t1`.`c2` AS `c2` from `test`.`t1` where (`test`.`t1`.`c1_idx` = 'y') order by `test`.`t1`.`pk` desc limit 2
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 5
@@ -5140,12 +4528,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE c1_idx = 'y' ORDER BY pk DESC LIMIT 2;
@@ -5178,12 +4560,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`pk` AS `pk`,`test`.`t1`.`c1_idx` AS `c1_idx`,`test`.`t1`.`c2` AS `c2` from `test`.`t1` where (`test`.`t1`.`c1_idx` = 'y') order by `test`.`t1`.`pk` desc limit 2
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 5
@@ -5232,12 +4608,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a > 34;
@@ -5269,12 +4639,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` > 34)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 4
@@ -5335,12 +4699,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
@@ -5381,12 +4739,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`c1` AS `c1`,`test`.`t1`.`c2` AS `c2`,`test`.`t1`.`c3` AS `c3`,`test`.`t2`.`c1` AS `c1`,`test`.`t2`.`c2` AS `c2` from `test`.`t1` left join `test`.`t2` on((`test`.`t1`.`c1` = `test`.`t2`.`c1`)) where 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -5445,12 +4797,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c3 = 10;
@@ -5494,12 +4840,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`c1` AS `c1`,`test`.`t1`.`c2` AS `c2`,`test`.`t1`.`c3` AS `c3`,`test`.`t2`.`c1` AS `c1`,`test`.`t2`.`c2` AS `c2` from `test`.`t1` left join `test`.`t2` on((`test`.`t2`.`c1` = `test`.`t1`.`c1`)) where (`test`.`t1`.`c3` = 10)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -5569,12 +4909,6 @@ EXPLAIN
}
Warnings:
Note 1276 Field or reference 'test.t1.f1' of SELECT #2 was resolved in SELECT #1
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT (SELECT MAX(t2.f4) FROM t2 WHERE t2.f3=t1.f1) FROM t1;
@@ -5622,12 +4956,6 @@ EXPLAIN
Warnings:
Note 1276 Field or reference 'test.t1.f1' of SELECT #2 was resolved in SELECT #1
Note 1003 /* select#1 */ select (/* select#2 */ select max(`test`.`t2`.`f4`) from `test`.`t2` where (`test`.`t2`.`f3` = `test`.`t1`.`f1`)) AS `(SELECT MAX(t2.f4) FROM t2 WHERE t2.f3=t1.f1)` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -5728,12 +5056,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM v1 WHERE a > 0;
@@ -5776,12 +5098,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,`test`.`t12`.`a` AS `b` from `test`.`t1` `t11` join `test`.`t1` `t12` where (`test`.`t11`.`a` > 0)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -5852,12 +5168,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, v1 WHERE t1.a = v1.a;
@@ -5910,12 +5220,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t11`.`a` AS `a`,`test`.`t12`.`a` AS `b` from `test`.`t1` join `test`.`t1` `t11` join `test`.`t1` `t12` where (`test`.`t11`.`a` = `test`.`t1`.`a`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 3
@@ -5969,12 +5273,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM v1 WHERE a < 4;
@@ -6006,12 +5304,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` < 4)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -6080,12 +5372,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2, v1 WHERE t2.x = v1.a;
@@ -6128,12 +5414,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`x` AS `x`,`test`.`t1`.`a` AS `a`,(`test`.`t1`.`b` + 1) AS `c` from `test`.`t2` join `test`.`t1` where (`test`.`t1`.`a` = `test`.`t2`.`x`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -6203,12 +5483,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2, v1 WHERE t2.x = v1.a;
@@ -6251,12 +5525,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`x` AS `x`,`test`.`t1`.`a` AS `a`,(`test`.`t1`.`b` + 1) AS `c` from `test`.`t2` join `test`.`t1` where (`test`.`t1`.`a` = `test`.`t2`.`x`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -6300,12 +5568,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT NULL;
@@ -6328,12 +5590,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select NULL AS `NULL`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
# Status of testing query execution:
@@ -6373,12 +5629,6 @@ EXPLAIN
"filtered": 100
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -6402,12 +5652,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -6495,12 +5739,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a IN (SELECT * FROM (SELECT b FROM t2 ORDER BY b LIMIT 2,2) x);
@@ -6562,12 +5800,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` semi join ((/* select#3 */ select `test`.`t2`.`b` AS `b` from `test`.`t2` order by `test`.`t2`.`b` limit 2,2) `x`) where (`x`.`b` = `test`.`t1`.`a`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -6665,12 +5897,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, t2 WHERE a IN (SELECT * FROM (SELECT b FROM t2 ORDER BY b LIMIT 2,2) x);
@@ -6744,12 +5970,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t2`.`b` AS `b` from `test`.`t1` semi join ((/* select#3 */ select `test`.`t2`.`b` AS `b` from `test`.`t2` order by `test`.`t2`.`b` limit 2,2) `x`) join `test`.`t2` where (`x`.`b` = `test`.`t1`.`a`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -6858,12 +6078,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, (SELECT * FROM t2) y WHERE a IN (SELECT * FROM (SELECT b FROM t2 ORDER BY b LIMIT 2,2) x);
@@ -6948,12 +6162,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`y`.`b` AS `b` from `test`.`t1` semi join ((/* select#4 */ select `test`.`t2`.`b` AS `b` from `test`.`t2` order by `test`.`t2`.`b` limit 2,2) `x`) join (/* select#2 */ select `test`.`t2`.`b` AS `b` from `test`.`t2`) `y` where (`x`.`b` = `test`.`t1`.`a`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
=== modified file 'mysql-test/r/innodb_explain_json_non_select_none.result'
--- a/mysql-test/r/innodb_explain_json_non_select_none.result 2011-11-16 15:09:45 +0000
+++ b/mysql-test/r/innodb_explain_json_non_select_none.result 2011-11-21 11:46:42 +0000
@@ -33,12 +33,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a < 10;
@@ -65,12 +59,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` < 10)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -116,12 +104,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a < 10;
@@ -148,12 +130,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` < 10)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -199,12 +175,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a = 1;
@@ -231,12 +201,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` = 1)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -301,12 +265,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, t2 WHERE t1.a = 1;
@@ -349,12 +307,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t2`.`b` AS `b` from `test`.`t1` join `test`.`t2` where (`test`.`t1`.`a` = 1)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -431,12 +383,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 t11, (SELECT * FROM t2) t12 WHERE t11.a = 1;
@@ -490,12 +436,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,`t12`.`b` AS `b` from `test`.`t1` `t11` join (/* select#2 */ select `test`.`t2`.`b` AS `b` from `test`.`t2`) `t12` where (`test`.`t11`.`a` = 1)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -564,12 +504,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE 1 IN (SELECT 1 FROM t2 WHERE t2.b < 3);
@@ -616,12 +550,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where <in_optimizer>(1,<exists>(/* select#2 */ select 1 from `test`.`t2` where (`test`.`t2`.`b` < 3)))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -692,12 +620,6 @@ EXPLAIN
}
Warnings:
Note 1276 Field or reference 'test.t1.a' of SELECT #2 was resolved in SELECT #1
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a IN (SELECT b FROM t2 WHERE t1.a < 3);
@@ -744,12 +666,6 @@ EXPLAIN
Warnings:
Note 1276 Field or reference 'test.t1.a' of SELECT #2 was resolved in SELECT #1
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where <in_optimizer>(`test`.`t1`.`a`,<exists>(/* select#2 */ select 1 from `test`.`t2` where ((`test`.`t1`.`a` < 3) and (<cache>(`test`.`t1`.`a`) = `test`.`t2`.`b`))))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 4
@@ -833,12 +749,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, t2 WHERE a IN (SELECT b FROM t2 WHERE t2.b < 3);
@@ -899,12 +809,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t2`.`b` AS `b` from `test`.`t1` join `test`.`t2` where <in_optimizer>(`test`.`t1`.`a`,<exists>(/* select#2 */ select 1 from `test`.`t2` where ((`test`.`t2`.`b` < 3) and (<cache>(`test`.`t1`.`a`) = `test`.`t2`.`b`))))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 5
@@ -978,12 +882,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 t11, (SELECT * FROM t2) t12;
@@ -1034,12 +932,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,`t12`.`b` AS `b` from `test`.`t1` `t11` join (/* select#2 */ select `test`.`t2`.`b` AS `b` from `test`.`t2`) `t12`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -1115,12 +1007,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 t11, (SELECT 1 FROM DUAL) t12;
@@ -1170,12 +1056,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,'1' AS `1` from `test`.`t1` `t11`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -1255,12 +1135,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 t11, (SELECT * FROM t2) t12 WHERE t11.a > 1;
@@ -1314,12 +1188,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,`t12`.`b` AS `b` from `test`.`t1` `t11` join (/* select#2 */ select `test`.`t2`.`b` AS `b` from `test`.`t2`) `t12` where (`test`.`t11`.`a` > 1)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -1367,12 +1235,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a > 1 LIMIT 1;
@@ -1399,12 +1261,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` > 1) limit 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -1446,12 +1302,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE 0;
@@ -1474,12 +1324,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where 0
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
# Status of testing query execution:
@@ -1514,12 +1358,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE 0;
@@ -1542,12 +1380,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where 0
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
# Status of testing query execution:
@@ -1590,12 +1422,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a = 3;
@@ -1624,12 +1450,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select '3' AS `a`,'3' AS `b` from `test`.`t1` where 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 4
@@ -1675,12 +1495,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a < 3;
@@ -1711,12 +1525,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1` where (`test`.`t1`.`a` < 3)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 5
@@ -1760,12 +1568,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE t1.a > 0 ORDER BY t1.a;
@@ -1797,12 +1599,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` > 0) order by `test`.`t1`.`a`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -1845,12 +1641,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE t1.a > 0 ORDER BY t1.a;
@@ -1882,12 +1672,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` > 0) order by `test`.`t1`.`a`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -1936,12 +1720,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE (@a:= a) ORDER BY a LIMIT 1;
@@ -1972,12 +1750,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (@a:=`test`.`t1`.`a`) order by `test`.`t1`.`a` limit 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -2024,12 +1796,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 ORDER BY a ASC, b ASC LIMIT 1;
@@ -2057,12 +1823,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b`,`test`.`t1`.`c` AS `c` from `test`.`t1` order by `test`.`t1`.`a`,`test`.`t1`.`b` limit 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -2147,12 +1907,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1,t2,t3 WHERE a1=a2 AND b2=a3 AND b1=b3;
@@ -2213,12 +1967,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a1` AS `a1`,`test`.`t1`.`b1` AS `b1`,`test`.`t2`.`a2` AS `a2`,`test`.`t2`.`b2` AS `b2`,`test`.`t3`.`a3` AS `a3`,`test`.`t3`.`b3` AS `b3` from `test`.`t1` join `test`.`t2` join `test`.`t3` where ((`test`.`t3`.`b3` = `test`.`t1`.`b1`) and (`test`.`t3`.`a3` = `test`.`t2`.`b2`) and (`test`.`t2`.`a2` = `test`.`t1`.`a1`))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -2288,12 +2036,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a IN (SELECT a FROM t2);
@@ -2338,12 +2080,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where <in_optimizer>(`test`.`t1`.`a`,<exists>(/* select#2 */ select 1 from `test`.`t2` where (<cache>(`test`.`t1`.`a`) = `test`.`t2`.`a`)))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 4
@@ -2411,12 +2147,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a1 IN (SELECT a2 FROM t2 WHERE a2 > 2);
@@ -2461,12 +2191,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a1` AS `a1` from `test`.`t1` where <in_optimizer>(`test`.`t1`.`a1`,<exists>(/* select#2 */ select 1 from `test`.`t2` where ((`test`.`t2`.`a2` > 2) and (<cache>(`test`.`t1`.`a1`) = `test`.`t2`.`a2`))))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 6
@@ -2530,12 +2254,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a1 IN (SELECT a2 FROM t2 WHERE a2 > 2);
@@ -2580,12 +2298,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a1` AS `a1` from `test`.`t1` where <in_optimizer>(`test`.`t1`.`a1`,<exists>(/* select#2 */ select 1 from `test`.`t2` where ((`test`.`t2`.`a2` > 2) and (<cache>(`test`.`t1`.`a1`) = `test`.`t2`.`a2`))))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 6
@@ -2628,12 +2340,6 @@ EXPLAIN
"filtered": 100
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -2657,12 +2363,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i`,`test`.`t1`.`j` AS `j` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -2705,12 +2405,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -2734,12 +2428,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i`,`test`.`t1`.`j` AS `j` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -2794,12 +2482,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -2829,12 +2511,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -2878,12 +2554,6 @@ EXPLAIN
"filtered": 100
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -2907,12 +2577,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -2956,12 +2620,6 @@ EXPLAIN
"filtered": 100
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -2985,12 +2643,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -3031,12 +2683,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of testing query execution:
Variable_name Value
Handler_write 1
@@ -3069,12 +2715,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of testing query execution:
Variable_name Value
Handler_write 1
@@ -3118,12 +2758,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
@@ -3154,12 +2788,6 @@ EXPLAIN
}
Warnings:
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
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 5
@@ -3214,12 +2842,6 @@ EXPLAIN
Warnings:
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
@@ -3257,12 +2879,6 @@ Warning 1713 Cannot use range access on
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
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
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -3320,12 +2936,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -3354,12 +2964,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -3419,12 +3023,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -3454,12 +3052,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -3516,12 +3108,6 @@ EXPLAIN
}
Warnings:
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -3550,12 +3136,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -3617,12 +3197,6 @@ EXPLAIN
}
Warnings:
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -3650,12 +3224,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd 1
@@ -3710,12 +3278,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE key1 < 13 or key2 < 14 ORDER BY key1;
@@ -3745,12 +3307,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`i` AS `i`,`test`.`t2`.`key1` AS `key1`,`test`.`t2`.`key2` AS `key2` from `test`.`t2` where ((`test`.`t2`.`key1` < 13) or (`test`.`t2`.`key2` < 14)) order by `test`.`t2`.`key1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -3809,12 +3365,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE i > 10 AND i <= 18 ORDER BY i DESC LIMIT 5;
@@ -3845,12 +3395,6 @@ EXPLAIN
}
Warnings:
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` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 5
@@ -3900,12 +3444,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 ORDER BY a, b DESC LIMIT 5;
@@ -3933,12 +3471,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c` from `test`.`t2` order by `test`.`t2`.`a`,`test`.`t2`.`b` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -3995,12 +3527,6 @@ EXPLAIN
"filtered": "X"
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 ORDER BY a DESC, b DESC LIMIT 5;
@@ -4027,12 +3553,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c` from `test`.`t2` order by `test`.`t2`.`a` desc,`test`.`t2`.`b` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 3
@@ -4087,12 +3607,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
@@ -4123,12 +3637,6 @@ EXPLAIN
}
Warnings:
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
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 5
@@ -4186,12 +3694,6 @@ EXPLAIN
Warnings:
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
@@ -4229,12 +3731,6 @@ Warning 1713 Cannot use range access on
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
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
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -4292,12 +3788,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -4326,12 +3816,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -4392,12 +3876,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -4427,12 +3905,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -4490,12 +3962,6 @@ EXPLAIN
}
Warnings:
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -4524,12 +3990,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -4590,12 +4050,6 @@ EXPLAIN
}
Warnings:
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -4623,12 +4077,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd 1
@@ -4682,12 +4130,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE key1 < 13 or key2 < 14 ORDER BY key1;
@@ -4717,12 +4159,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`i` AS `i`,`test`.`t2`.`key1` AS `key1`,`test`.`t2`.`key2` AS `key2` from `test`.`t2` where ((`test`.`t2`.`key1` < 13) or (`test`.`t2`.`key2` < 14)) order by `test`.`t2`.`key1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -4782,12 +4218,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE i > 10 AND i <= 18 ORDER BY i DESC LIMIT 5;
@@ -4818,12 +4248,6 @@ EXPLAIN
}
Warnings:
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` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 5
@@ -4874,12 +4298,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 ORDER BY a, b DESC LIMIT 5;
@@ -4907,12 +4325,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c` from `test`.`t2` order by `test`.`t2`.`a`,`test`.`t2`.`b` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -4972,12 +4384,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 ORDER BY a DESC, b DESC LIMIT 5;
@@ -5004,12 +4410,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c` from `test`.`t2` order by `test`.`t2`.`a` desc,`test`.`t2`.`b` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 3
@@ -5067,12 +4467,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE c1_idx = 'y' ORDER BY pk DESC LIMIT 2;
@@ -5104,12 +4498,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`pk` AS `pk`,`test`.`t1`.`c1_idx` AS `c1_idx`,`test`.`t1`.`c2` AS `c2` from `test`.`t1` where (`test`.`t1`.`c1_idx` = 'y') order by `test`.`t1`.`pk` desc limit 2
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 5
@@ -5154,12 +4542,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE c1_idx = 'y' ORDER BY pk DESC LIMIT 2;
@@ -5191,12 +4573,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`pk` AS `pk`,`test`.`t1`.`c1_idx` AS `c1_idx`,`test`.`t1`.`c2` AS `c2` from `test`.`t1` where (`test`.`t1`.`c1_idx` = 'y') order by `test`.`t1`.`pk` desc limit 2
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 5
@@ -5245,12 +4621,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a > 34;
@@ -5282,12 +4652,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` > 34)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 4
@@ -5348,12 +4712,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
@@ -5394,12 +4752,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`c1` AS `c1`,`test`.`t1`.`c2` AS `c2`,`test`.`t1`.`c3` AS `c3`,`test`.`t2`.`c1` AS `c1`,`test`.`t2`.`c2` AS `c2` from `test`.`t1` left join `test`.`t2` on((`test`.`t1`.`c1` = `test`.`t2`.`c1`)) where 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -5458,12 +4810,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c3 = 10;
@@ -5507,12 +4853,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`c1` AS `c1`,`test`.`t1`.`c2` AS `c2`,`test`.`t1`.`c3` AS `c3`,`test`.`t2`.`c1` AS `c1`,`test`.`t2`.`c2` AS `c2` from `test`.`t1` left join `test`.`t2` on((`test`.`t2`.`c1` = `test`.`t1`.`c1`)) where (`test`.`t1`.`c3` = 10)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -5582,12 +4922,6 @@ EXPLAIN
}
Warnings:
Note 1276 Field or reference 'test.t1.f1' of SELECT #2 was resolved in SELECT #1
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT (SELECT MAX(t2.f4) FROM t2 WHERE t2.f3=t1.f1) FROM t1;
@@ -5635,12 +4969,6 @@ EXPLAIN
Warnings:
Note 1276 Field or reference 'test.t1.f1' of SELECT #2 was resolved in SELECT #1
Note 1003 /* select#1 */ select (/* select#2 */ select max(`test`.`t2`.`f4`) from `test`.`t2` where (`test`.`t2`.`f3` = `test`.`t1`.`f1`)) AS `(SELECT MAX(t2.f4) FROM t2 WHERE t2.f3=t1.f1)` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -5741,12 +5069,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM v1 WHERE a > 0;
@@ -5789,12 +5111,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,`test`.`t12`.`a` AS `b` from `test`.`t1` `t11` join `test`.`t1` `t12` where (`test`.`t11`.`a` > 0)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -5865,12 +5181,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, v1 WHERE t1.a = v1.a;
@@ -5923,12 +5233,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t11`.`a` AS `a`,`test`.`t12`.`a` AS `b` from `test`.`t1` join `test`.`t1` `t11` join `test`.`t1` `t12` where (`test`.`t11`.`a` = `test`.`t1`.`a`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 3
@@ -5982,12 +5286,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM v1 WHERE a < 4;
@@ -6019,12 +5317,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` < 4)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -6093,12 +5385,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2, v1 WHERE t2.x = v1.a;
@@ -6141,12 +5427,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`x` AS `x`,`test`.`t1`.`a` AS `a`,(`test`.`t1`.`b` + 1) AS `c` from `test`.`t2` join `test`.`t1` where (`test`.`t1`.`a` = `test`.`t2`.`x`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -6216,12 +5496,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2, v1 WHERE t2.x = v1.a;
@@ -6264,12 +5538,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`x` AS `x`,`test`.`t1`.`a` AS `a`,(`test`.`t1`.`b` + 1) AS `c` from `test`.`t2` join `test`.`t1` where (`test`.`t1`.`a` = `test`.`t2`.`x`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -6313,12 +5581,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT NULL;
@@ -6341,12 +5603,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select NULL AS `NULL`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
# Status of testing query execution:
@@ -6386,12 +5642,6 @@ EXPLAIN
"filtered": 100
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -6415,12 +5665,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -6508,12 +5752,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a IN (SELECT * FROM (SELECT b FROM t2 ORDER BY b LIMIT 2,2) x);
@@ -6576,12 +5814,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where <in_optimizer>(`test`.`t1`.`a`,<exists>(<index_lookup>(<cache>(`test`.`t1`.`a`) in x on auto_key0)))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -6684,12 +5916,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, t2 WHERE a IN (SELECT * FROM (SELECT b FROM t2 ORDER BY b LIMIT 2,2) x);
@@ -6768,12 +5994,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t2`.`b` AS `b` from `test`.`t1` join `test`.`t2` where <in_optimizer>(`test`.`t1`.`a`,<exists>(<index_lookup>(<cache>(`test`.`t1`.`a`) in x on auto_key0)))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
@@ -6887,12 +6107,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, (SELECT * FROM t2) y WHERE a IN (SELECT * FROM (SELECT b FROM t2 ORDER BY b LIMIT 2,2) x);
@@ -6982,12 +6196,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`y`.`b` AS `b` from `test`.`t1` join (/* select#2 */ select `test`.`t2`.`b` AS `b` from `test`.`t2`) `y` where <in_optimizer>(`test`.`t1`.`a`,<exists>(<index_lookup>(<cache>(`test`.`t1`.`a`) in x on auto_key0)))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 2
=== modified file 'mysql-test/r/myisam_explain_json_non_select_all.result'
--- a/mysql-test/r/myisam_explain_json_non_select_all.result 2011-11-16 15:09:45 +0000
+++ b/mysql-test/r/myisam_explain_json_non_select_all.result 2011-11-21 11:46:42 +0000
@@ -34,12 +34,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a < 10;
@@ -66,12 +60,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` < 10)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 4
@@ -113,12 +101,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a < 10;
@@ -145,12 +127,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` < 10)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 4
@@ -192,12 +168,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a = 1;
@@ -224,12 +194,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` = 1)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 4
@@ -290,12 +254,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, t2 WHERE t1.a = 1;
@@ -338,12 +296,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t2`.`b` AS `b` from `test`.`t1` join `test`.`t2` where (`test`.`t1`.`a` = 1)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 8
@@ -416,12 +368,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 t11, (SELECT * FROM t2) t12 WHERE t11.a = 1;
@@ -475,12 +421,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,`t12`.`b` AS `b` from `test`.`t1` `t11` join (/* select#2 */ select `test`.`t2`.`b` AS `b` from `test`.`t2`) `t12` where (`test`.`t11`.`a` = 1)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 12
@@ -545,12 +485,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE 1 IN (SELECT 1 FROM t2 WHERE t2.b < 3);
@@ -594,12 +528,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` semi join (`test`.`t2`) where (`test`.`t2`.`b` < 3)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 5
@@ -666,12 +594,6 @@ EXPLAIN
}
Warnings:
Note 1276 Field or reference 'test.t1.a' of SELECT #2 was resolved in SELECT #1
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a IN (SELECT b FROM t2 WHERE t1.a < 3);
@@ -718,12 +640,6 @@ EXPLAIN
Warnings:
Note 1276 Field or reference 'test.t1.a' of SELECT #2 was resolved in SELECT #1
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` semi join (`test`.`t2`) where ((`test`.`t2`.`b` = `test`.`t1`.`a`) and (`test`.`t1`.`a` < 3))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 8
@@ -799,12 +715,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, t2 WHERE a IN (SELECT b FROM t2 WHERE t2.b < 3);
@@ -861,12 +771,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t2`.`b` AS `b` from `test`.`t1` semi join (`test`.`t2`) join `test`.`t2` where ((`test`.`t2`.`b` = `test`.`t1`.`a`) and (`test`.`t1`.`a` < 3))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 12
@@ -936,12 +840,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 t11, (SELECT * FROM t2) t12;
@@ -992,12 +890,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,`t12`.`b` AS `b` from `test`.`t1` `t11` join (/* select#2 */ select `test`.`t2`.`b` AS `b` from `test`.`t2`) `t12`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 12
@@ -1069,12 +961,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 t11, (SELECT 1 FROM DUAL) t12;
@@ -1124,12 +1010,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,'1' AS `1` from `test`.`t1` `t11`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -1207,12 +1087,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 t11, (SELECT * FROM t2) t12 WHERE t11.a > 1;
@@ -1266,12 +1140,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,`t12`.`b` AS `b` from `test`.`t1` `t11` join (/* select#2 */ select `test`.`t2`.`b` AS `b` from `test`.`t2`) `t12` where (`test`.`t11`.`a` > 1)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 12
@@ -1315,12 +1183,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a > 1 LIMIT 1;
@@ -1347,12 +1209,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` > 1) limit 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 2
@@ -1390,12 +1246,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE 0;
@@ -1418,12 +1268,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where 0
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
# Status of testing query execution:
@@ -1458,12 +1302,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE 0;
@@ -1486,12 +1324,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where 0
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
# Status of testing query execution:
@@ -1533,12 +1365,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a = 3;
@@ -1567,12 +1393,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select '3' AS `a`,'3' AS `b` from `test`.`t1` where 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 1
@@ -1617,12 +1437,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a < 3;
@@ -1653,12 +1467,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1` where (`test`.`t1`.`a` < 3)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 1
@@ -1701,12 +1509,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE t1.a > 0 ORDER BY t1.a;
@@ -1731,12 +1533,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select NULL AS `a` from `test`.`t1` where 0 order by NULL
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -1778,12 +1574,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE t1.a > 0 ORDER BY t1.a;
@@ -1814,12 +1604,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` > 0) order by `test`.`t1`.`a`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -1866,12 +1650,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE (@a:= a) ORDER BY a LIMIT 1;
@@ -1901,12 +1679,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (@a:=`test`.`t1`.`a`) order by `test`.`t1`.`a` limit 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -1950,12 +1722,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 ORDER BY a ASC, b ASC LIMIT 1;
@@ -1982,12 +1748,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b`,`test`.`t1`.`c` AS `c` from `test`.`t1` order by `test`.`t1`.`a`,`test`.`t1`.`b` limit 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 11
@@ -2067,12 +1827,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1,t2,t3 WHERE a1=a2 AND b2=a3 AND b1=b3;
@@ -2132,12 +1886,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a1` AS `a1`,`test`.`t1`.`b1` AS `b1`,`test`.`t2`.`a2` AS `a2`,`test`.`t2`.`b2` AS `b2`,`test`.`t3`.`a3` AS `a3`,`test`.`t3`.`b3` AS `b3` from `test`.`t1` join `test`.`t2` join `test`.`t3` where ((`test`.`t3`.`b3` = `test`.`t1`.`b1`) and (`test`.`t3`.`a3` = `test`.`t2`.`b2`) and (`test`.`t2`.`a2` = `test`.`t1`.`a1`))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 6
@@ -2205,12 +1953,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a IN (SELECT a FROM t2);
@@ -2252,12 +1994,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` semi join (`test`.`t2`) where (`test`.`t2`.`a` = `test`.`t1`.`a`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 8
@@ -2321,12 +2057,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a1 IN (SELECT a2 FROM t2 WHERE a2 > 2);
@@ -2371,12 +2101,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a1` AS `a1` from `test`.`t1` where <in_optimizer>(`test`.`t1`.`a1`,<exists>(/* select#2 */ select 1 from `test`.`t2` where ((`test`.`t2`.`a2` > 2) and (<cache>(`test`.`t1`.`a1`) = `test`.`t2`.`a2`))))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 30
@@ -2436,12 +2160,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a1 IN (SELECT a2 FROM t2 WHERE a2 > 2);
@@ -2483,12 +2201,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a1` AS `a1` from `test`.`t1` semi join (`test`.`t2`) where ((`test`.`t2`.`a2` > 2) and (`test`.`t1`.`a1` = `test`.`t2`.`a2`))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 12
@@ -2527,12 +2239,6 @@ EXPLAIN
"filtered": 100
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -2556,12 +2262,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i`,`test`.`t1`.`j` AS `j` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 6
@@ -2600,12 +2300,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -2629,12 +2323,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i`,`test`.`t1`.`j` AS `j` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 6
@@ -2682,12 +2370,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -2716,12 +2398,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -2763,12 +2439,6 @@ EXPLAIN
"filtered": 100
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -2792,12 +2462,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 4
@@ -2837,12 +2501,6 @@ EXPLAIN
"filtered": 100
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -2866,12 +2524,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 4
@@ -2908,12 +2560,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of testing query execution:
Variable_name Value
Handler_write 1
@@ -2946,12 +2592,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of testing query execution:
Variable_name Value
Handler_write 1
@@ -2994,12 +2634,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
@@ -3029,12 +2663,6 @@ EXPLAIN
}
Warnings:
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
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 1
@@ -3088,12 +2716,6 @@ EXPLAIN
Warnings:
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
@@ -3130,12 +2752,6 @@ Warning 1713 Cannot use range access on
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
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
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 27
@@ -3188,12 +2804,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -3221,12 +2831,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 27
@@ -3281,12 +2885,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -3315,12 +2913,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -3374,12 +2966,6 @@ EXPLAIN
}
Warnings:
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -3407,12 +2993,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 27
@@ -3470,12 +3050,6 @@ EXPLAIN
}
Warnings:
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -3503,12 +3077,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd 1
@@ -3565,12 +3133,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE key1 < 13 or key2 < 14 ORDER BY key1;
@@ -3602,12 +3164,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`i` AS `i`,`test`.`t2`.`key1` AS `key1`,`test`.`t2`.`key2` AS `key2` from `test`.`t2` where ((`test`.`t2`.`key1` < 13) or (`test`.`t2`.`key2` < 14)) order by `test`.`t2`.`key1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 2
@@ -3664,12 +3220,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE i > 10 AND i <= 18 ORDER BY i DESC LIMIT 5;
@@ -3699,12 +3249,6 @@ EXPLAIN
}
Warnings:
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` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 1
@@ -3753,12 +3297,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 ORDER BY a, b DESC LIMIT 5;
@@ -3785,12 +3323,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c` from `test`.`t2` order by `test`.`t2`.`a`,`test`.`t2`.`b` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 27
@@ -3842,12 +3374,6 @@ EXPLAIN
"filtered": 100
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 ORDER BY a DESC, b DESC LIMIT 5;
@@ -3873,12 +3399,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c` from `test`.`t2` order by `test`.`t2`.`a` desc,`test`.`t2`.`b` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_last 1
@@ -3930,12 +3450,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
@@ -3965,12 +3479,6 @@ EXPLAIN
}
Warnings:
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
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 1
@@ -4027,12 +3535,6 @@ EXPLAIN
Warnings:
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
@@ -4069,12 +3571,6 @@ Warning 1713 Cannot use range access on
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
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
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 27
@@ -4127,12 +3623,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -4160,12 +3650,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 27
@@ -4221,12 +3705,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -4255,12 +3733,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -4315,12 +3787,6 @@ EXPLAIN
}
Warnings:
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -4348,12 +3814,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 27
@@ -4410,12 +3870,6 @@ EXPLAIN
}
Warnings:
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -4443,12 +3897,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd 1
@@ -4504,12 +3952,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE key1 < 13 or key2 < 14 ORDER BY key1;
@@ -4541,12 +3983,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`i` AS `i`,`test`.`t2`.`key1` AS `key1`,`test`.`t2`.`key2` AS `key2` from `test`.`t2` where ((`test`.`t2`.`key1` < 13) or (`test`.`t2`.`key2` < 14)) order by `test`.`t2`.`key1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 2
@@ -4604,12 +4040,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE i > 10 AND i <= 18 ORDER BY i DESC LIMIT 5;
@@ -4639,12 +4069,6 @@ EXPLAIN
}
Warnings:
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` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 1
@@ -4694,12 +4118,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 ORDER BY a, b DESC LIMIT 5;
@@ -4726,12 +4144,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c` from `test`.`t2` order by `test`.`t2`.`a`,`test`.`t2`.`b` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 27
@@ -4786,12 +4198,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 ORDER BY a DESC, b DESC LIMIT 5;
@@ -4817,12 +4223,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c` from `test`.`t2` order by `test`.`t2`.`a` desc,`test`.`t2`.`b` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_last 1
@@ -4877,12 +4277,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE c1_idx = 'y' ORDER BY pk DESC LIMIT 2;
@@ -4915,12 +4309,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`pk` AS `pk`,`test`.`t1`.`c1_idx` AS `c1_idx`,`test`.`t1`.`c2` AS `c2` from `test`.`t1` where (`test`.`t1`.`c1_idx` = 'y') order by `test`.`t1`.`pk` desc limit 2
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 1
@@ -4970,12 +4358,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE c1_idx = 'y' ORDER BY pk DESC LIMIT 2;
@@ -5008,12 +4390,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`pk` AS `pk`,`test`.`t1`.`c1_idx` AS `c1_idx`,`test`.`t1`.`c2` AS `c2` from `test`.`t1` where (`test`.`t1`.`c1_idx` = 'y') order by `test`.`t1`.`pk` desc limit 2
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 1
@@ -5067,12 +4443,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a > 34;
@@ -5103,12 +4473,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` > 34)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 1
@@ -5170,12 +4534,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
@@ -5217,12 +4575,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`c1` AS `c1`,`test`.`t1`.`c2` AS `c2`,`test`.`t1`.`c3` AS `c3`,NULL AS `c1`,NULL AS `c2` from `test`.`t1` where 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -5280,12 +4632,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c3 = 10;
@@ -5330,12 +4676,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`c1` AS `c1`,`test`.`t1`.`c2` AS `c2`,`test`.`t1`.`c3` AS `c3`,NULL AS `c1`,NULL AS `c2` from `test`.`t1` where (`test`.`t1`.`c3` = 10)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -5402,12 +4742,6 @@ EXPLAIN
}
Warnings:
Note 1276 Field or reference 'test.t1.f1' of SELECT #2 was resolved in SELECT #1
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT (SELECT MAX(t2.f4) FROM t2 WHERE t2.f3=t1.f1) FROM t1;
@@ -5454,12 +4788,6 @@ EXPLAIN
Warnings:
Note 1276 Field or reference 'test.t1.f1' of SELECT #2 was resolved in SELECT #1
Note 1003 /* select#1 */ select (/* select#2 */ select max(`test`.`t2`.`f4`) from `test`.`t2` where (`test`.`t2`.`f3` = `test`.`t1`.`f1`)) AS `(SELECT MAX(t2.f4) FROM t2 WHERE t2.f3=t1.f1)` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 2
@@ -5558,12 +4886,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM v1 WHERE a > 0;
@@ -5606,12 +4928,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,`test`.`t12`.`a` AS `b` from `test`.`t1` `t11` join `test`.`t1` `t12` where (`test`.`t11`.`a` > 0)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 6
@@ -5678,12 +4994,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, v1 WHERE t1.a = v1.a;
@@ -5736,12 +5046,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t11`.`a` AS `a`,`test`.`t12`.`a` AS `b` from `test`.`t1` join `test`.`t1` `t11` join `test`.`t1` `t12` where (`test`.`t11`.`a` = `test`.`t1`.`a`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 9
@@ -5790,12 +5094,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM v1 WHERE a < 4;
@@ -5826,12 +5124,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` < 4)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -5897,12 +5189,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2, v1 WHERE t2.x = v1.a;
@@ -5946,12 +5232,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`x` AS `x`,`test`.`t1`.`a` AS `a`,(`test`.`t1`.`b` + 1) AS `c` from `test`.`t2` join `test`.`t1` where (`test`.`t1`.`a` = `test`.`t2`.`x`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 4
@@ -6018,12 +5298,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2, v1 WHERE t2.x = v1.a;
@@ -6067,12 +5341,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`x` AS `x`,`test`.`t1`.`a` AS `a`,(`test`.`t1`.`b` + 1) AS `c` from `test`.`t2` join `test`.`t1` where (`test`.`t1`.`a` = `test`.`t2`.`x`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 4
@@ -6114,12 +5382,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT NULL;
@@ -6142,12 +5404,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select NULL AS `NULL`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
# Status of testing query execution:
@@ -6192,12 +5448,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -6226,12 +5476,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select NULL AS `a` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -6317,12 +5561,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a IN (SELECT * FROM (SELECT b FROM t2 ORDER BY b LIMIT 2,2) x);
@@ -6384,12 +5622,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` semi join ((/* select#3 */ select `test`.`t2`.`b` AS `b` from `test`.`t2` order by `test`.`t2`.`b` limit 2,2) `x`) where (`x`.`b` = `test`.`t1`.`a`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 3
@@ -6484,12 +5716,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, t2 WHERE a IN (SELECT * FROM (SELECT b FROM t2 ORDER BY b LIMIT 2,2) x);
@@ -6563,12 +5789,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t2`.`b` AS `b` from `test`.`t1` semi join ((/* select#3 */ select `test`.`t2`.`b` AS `b` from `test`.`t2` order by `test`.`t2`.`b` limit 2,2) `x`) join `test`.`t2` where (`x`.`b` = `test`.`t1`.`a`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 3
@@ -6675,12 +5895,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, (SELECT * FROM t2) y WHERE a IN (SELECT * FROM (SELECT b FROM t2 ORDER BY b LIMIT 2,2) x);
@@ -6765,12 +5979,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`y`.`b` AS `b` from `test`.`t1` semi join ((/* select#4 */ select `test`.`t2`.`b` AS `b` from `test`.`t2` order by `test`.`t2`.`b` limit 2,2) `x`) join (/* select#2 */ select `test`.`t2`.`b` AS `b` from `test`.`t2`) `y` where (`x`.`b` = `test`.`t1`.`a`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 3
=== modified file 'mysql-test/r/myisam_explain_json_non_select_none.result'
--- a/mysql-test/r/myisam_explain_json_non_select_none.result 2011-11-16 15:09:45 +0000
+++ b/mysql-test/r/myisam_explain_json_non_select_none.result 2011-11-21 11:46:42 +0000
@@ -33,12 +33,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a < 10;
@@ -65,12 +59,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` < 10)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 4
@@ -112,12 +100,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a < 10;
@@ -144,12 +126,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` < 10)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 4
@@ -191,12 +167,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a = 1;
@@ -223,12 +193,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` = 1)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 4
@@ -289,12 +253,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, t2 WHERE t1.a = 1;
@@ -337,12 +295,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t2`.`b` AS `b` from `test`.`t1` join `test`.`t2` where (`test`.`t1`.`a` = 1)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 8
@@ -415,12 +367,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 t11, (SELECT * FROM t2) t12 WHERE t11.a = 1;
@@ -474,12 +420,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,`t12`.`b` AS `b` from `test`.`t1` `t11` join (/* select#2 */ select `test`.`t2`.`b` AS `b` from `test`.`t2`) `t12` where (`test`.`t11`.`a` = 1)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 12
@@ -544,12 +484,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE 1 IN (SELECT 1 FROM t2 WHERE t2.b < 3);
@@ -594,12 +528,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where <in_optimizer>(1,<exists>(/* select#2 */ select 1 from `test`.`t2` where (`test`.`t2`.`b` < 3)))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 5
@@ -666,12 +594,6 @@ EXPLAIN
}
Warnings:
Note 1276 Field or reference 'test.t1.a' of SELECT #2 was resolved in SELECT #1
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a IN (SELECT b FROM t2 WHERE t1.a < 3);
@@ -718,12 +640,6 @@ EXPLAIN
Warnings:
Note 1276 Field or reference 'test.t1.a' of SELECT #2 was resolved in SELECT #1
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where <in_optimizer>(`test`.`t1`.`a`,<exists>(/* select#2 */ select 1 from `test`.`t2` where ((`test`.`t1`.`a` < 3) and (<cache>(`test`.`t1`.`a`) = `test`.`t2`.`b`))))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 11
@@ -803,12 +719,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, t2 WHERE a IN (SELECT b FROM t2 WHERE t2.b < 3);
@@ -869,12 +779,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t2`.`b` AS `b` from `test`.`t1` join `test`.`t2` where <in_optimizer>(`test`.`t1`.`a`,<exists>(/* select#2 */ select 1 from `test`.`t2` where ((`test`.`t2`.`b` < 3) and (<cache>(`test`.`t1`.`a`) = `test`.`t2`.`b`))))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 15
@@ -944,12 +848,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 t11, (SELECT * FROM t2) t12;
@@ -1000,12 +898,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,`t12`.`b` AS `b` from `test`.`t1` `t11` join (/* select#2 */ select `test`.`t2`.`b` AS `b` from `test`.`t2`) `t12`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 12
@@ -1077,12 +969,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 t11, (SELECT 1 FROM DUAL) t12;
@@ -1132,12 +1018,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,'1' AS `1` from `test`.`t1` `t11`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -1215,12 +1095,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 t11, (SELECT * FROM t2) t12 WHERE t11.a > 1;
@@ -1274,12 +1148,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,`t12`.`b` AS `b` from `test`.`t1` `t11` join (/* select#2 */ select `test`.`t2`.`b` AS `b` from `test`.`t2`) `t12` where (`test`.`t11`.`a` > 1)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 12
@@ -1323,12 +1191,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a > 1 LIMIT 1;
@@ -1355,12 +1217,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` > 1) limit 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 2
@@ -1398,12 +1254,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE 0;
@@ -1426,12 +1276,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where 0
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
# Status of testing query execution:
@@ -1466,12 +1310,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE 0;
@@ -1494,12 +1332,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where 0
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
# Status of testing query execution:
@@ -1541,12 +1373,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a = 3;
@@ -1575,12 +1401,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select '3' AS `a`,'3' AS `b` from `test`.`t1` where 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 1
@@ -1625,12 +1445,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a < 3;
@@ -1660,12 +1474,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1` where (`test`.`t1`.`a` < 3)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 1
@@ -1708,12 +1516,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE t1.a > 0 ORDER BY t1.a;
@@ -1738,12 +1540,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select NULL AS `a` from `test`.`t1` where 0 order by NULL
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -1785,12 +1581,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE t1.a > 0 ORDER BY t1.a;
@@ -1821,12 +1611,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` > 0) order by `test`.`t1`.`a`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -1873,12 +1657,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE (@a:= a) ORDER BY a LIMIT 1;
@@ -1908,12 +1686,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (@a:=`test`.`t1`.`a`) order by `test`.`t1`.`a` limit 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -1957,12 +1729,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 ORDER BY a ASC, b ASC LIMIT 1;
@@ -1989,12 +1755,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b`,`test`.`t1`.`c` AS `c` from `test`.`t1` order by `test`.`t1`.`a`,`test`.`t1`.`b` limit 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 11
@@ -2074,12 +1834,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1,t2,t3 WHERE a1=a2 AND b2=a3 AND b1=b3;
@@ -2139,12 +1893,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a1` AS `a1`,`test`.`t1`.`b1` AS `b1`,`test`.`t2`.`a2` AS `a2`,`test`.`t2`.`b2` AS `b2`,`test`.`t3`.`a3` AS `a3`,`test`.`t3`.`b3` AS `b3` from `test`.`t1` join `test`.`t2` join `test`.`t3` where ((`test`.`t3`.`b3` = `test`.`t1`.`b1`) and (`test`.`t3`.`a3` = `test`.`t2`.`b2`) and (`test`.`t2`.`a2` = `test`.`t1`.`a1`))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 6
@@ -2212,12 +1960,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a IN (SELECT a FROM t2);
@@ -2262,12 +2004,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where <in_optimizer>(`test`.`t1`.`a`,<exists>(/* select#2 */ select 1 from `test`.`t2` where (<cache>(`test`.`t1`.`a`) = `test`.`t2`.`a`)))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 10
@@ -2331,12 +2067,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a1 IN (SELECT a2 FROM t2 WHERE a2 > 2);
@@ -2381,12 +2111,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a1` AS `a1` from `test`.`t1` where <in_optimizer>(`test`.`t1`.`a1`,<exists>(/* select#2 */ select 1 from `test`.`t2` where ((`test`.`t2`.`a2` > 2) and (<cache>(`test`.`t1`.`a1`) = `test`.`t2`.`a2`))))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 30
@@ -2446,12 +2170,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a1 IN (SELECT a2 FROM t2 WHERE a2 > 2);
@@ -2496,12 +2214,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a1` AS `a1` from `test`.`t1` where <in_optimizer>(`test`.`t1`.`a1`,<exists>(/* select#2 */ select 1 from `test`.`t2` where ((`test`.`t2`.`a2` > 2) and (<cache>(`test`.`t1`.`a1`) = `test`.`t2`.`a2`))))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 30
@@ -2540,12 +2252,6 @@ EXPLAIN
"filtered": 100
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -2569,12 +2275,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i`,`test`.`t1`.`j` AS `j` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 6
@@ -2613,12 +2313,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -2642,12 +2336,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i`,`test`.`t1`.`j` AS `j` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 6
@@ -2695,12 +2383,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -2729,12 +2411,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -2776,12 +2452,6 @@ EXPLAIN
"filtered": 100
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -2805,12 +2475,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 4
@@ -2850,12 +2514,6 @@ EXPLAIN
"filtered": 100
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -2879,12 +2537,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 4
@@ -2921,12 +2573,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of testing query execution:
Variable_name Value
Handler_write 1
@@ -2959,12 +2605,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of testing query execution:
Variable_name Value
Handler_write 1
@@ -3007,12 +2647,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
@@ -3042,12 +2676,6 @@ EXPLAIN
}
Warnings:
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
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 1
@@ -3101,12 +2729,6 @@ EXPLAIN
Warnings:
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
@@ -3143,12 +2765,6 @@ Warning 1713 Cannot use range access on
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
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
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 27
@@ -3201,12 +2817,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -3234,12 +2844,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 27
@@ -3294,12 +2898,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -3328,12 +2926,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -3387,12 +2979,6 @@ EXPLAIN
}
Warnings:
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -3420,12 +3006,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 27
@@ -3483,12 +3063,6 @@ EXPLAIN
}
Warnings:
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -3516,12 +3090,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd 1
@@ -3578,12 +3146,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE key1 < 13 or key2 < 14 ORDER BY key1;
@@ -3615,12 +3177,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`i` AS `i`,`test`.`t2`.`key1` AS `key1`,`test`.`t2`.`key2` AS `key2` from `test`.`t2` where ((`test`.`t2`.`key1` < 13) or (`test`.`t2`.`key2` < 14)) order by `test`.`t2`.`key1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 2
@@ -3677,12 +3233,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE i > 10 AND i <= 18 ORDER BY i DESC LIMIT 5;
@@ -3712,12 +3262,6 @@ EXPLAIN
}
Warnings:
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` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 1
@@ -3766,12 +3310,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 ORDER BY a, b DESC LIMIT 5;
@@ -3798,12 +3336,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c` from `test`.`t2` order by `test`.`t2`.`a`,`test`.`t2`.`b` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 27
@@ -3855,12 +3387,6 @@ EXPLAIN
"filtered": 100
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 ORDER BY a DESC, b DESC LIMIT 5;
@@ -3886,12 +3412,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c` from `test`.`t2` order by `test`.`t2`.`a` desc,`test`.`t2`.`b` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_last 1
@@ -3943,12 +3463,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
@@ -3978,12 +3492,6 @@ EXPLAIN
}
Warnings:
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
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 1
@@ -4040,12 +3548,6 @@ EXPLAIN
Warnings:
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE i > 10 AND i <= 18 ORDER BY i LIMIT 5;
@@ -4082,12 +3584,6 @@ Warning 1713 Cannot use range access on
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
Warning 1713 Cannot use range access on index 'i' due to type or collation conversion on field 'i'
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
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 27
@@ -4140,12 +3636,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -4173,12 +3663,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 27
@@ -4234,12 +3718,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -4268,12 +3746,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -4328,12 +3800,6 @@ EXPLAIN
}
Warnings:
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -4361,12 +3827,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 27
@@ -4423,12 +3883,6 @@ EXPLAIN
}
Warnings:
Warning 1713 Cannot use range access on index 'a' due to type or collation conversion on field 'b'
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE b = 10 ORDER BY a, c LIMIT 5;
@@ -4456,12 +3910,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`t2` where (`test`.`t2`.`b` = 10) order by `test`.`t2`.`a`,`test`.`t2`.`c` limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd 1
@@ -4517,12 +3965,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE key1 < 13 or key2 < 14 ORDER BY key1;
@@ -4554,12 +3996,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`i` AS `i`,`test`.`t2`.`key1` AS `key1`,`test`.`t2`.`key2` AS `key2` from `test`.`t2` where ((`test`.`t2`.`key1` < 13) or (`test`.`t2`.`key2` < 14)) order by `test`.`t2`.`key1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 2
@@ -4617,12 +4053,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 WHERE i > 10 AND i <= 18 ORDER BY i DESC LIMIT 5;
@@ -4652,12 +4082,6 @@ EXPLAIN
}
Warnings:
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` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 1
@@ -4707,12 +4131,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 ORDER BY a, b DESC LIMIT 5;
@@ -4739,12 +4157,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c` from `test`.`t2` order by `test`.`t2`.`a`,`test`.`t2`.`b` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 27
@@ -4799,12 +4211,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2 ORDER BY a DESC, b DESC LIMIT 5;
@@ -4830,12 +4236,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c` from `test`.`t2` order by `test`.`t2`.`a` desc,`test`.`t2`.`b` desc limit 5
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_last 1
@@ -4890,12 +4290,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE c1_idx = 'y' ORDER BY pk DESC LIMIT 2;
@@ -4927,12 +4321,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`pk` AS `pk`,`test`.`t1`.`c1_idx` AS `c1_idx`,`test`.`t1`.`c2` AS `c2` from `test`.`t1` where (`test`.`t1`.`c1_idx` = 'y') order by `test`.`t1`.`pk` desc limit 2
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 1
@@ -4981,12 +4369,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE c1_idx = 'y' ORDER BY pk DESC LIMIT 2;
@@ -5018,12 +4400,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`pk` AS `pk`,`test`.`t1`.`c1_idx` AS `c1_idx`,`test`.`t1`.`c2` AS `c2` from `test`.`t1` where (`test`.`t1`.`c1_idx` = 'y') order by `test`.`t1`.`pk` desc limit 2
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 1
@@ -5076,12 +4452,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a > 34;
@@ -5112,12 +4482,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` > 34)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 1
@@ -5179,12 +4543,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
@@ -5226,12 +4584,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`c1` AS `c1`,`test`.`t1`.`c2` AS `c2`,`test`.`t1`.`c3` AS `c3`,NULL AS `c1`,NULL AS `c2` from `test`.`t1` where 1
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -5289,12 +4641,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c3 = 10;
@@ -5339,12 +4685,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`c1` AS `c1`,`test`.`t1`.`c2` AS `c2`,`test`.`t1`.`c3` AS `c3`,NULL AS `c1`,NULL AS `c2` from `test`.`t1` where (`test`.`t1`.`c3` = 10)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -5411,12 +4751,6 @@ EXPLAIN
}
Warnings:
Note 1276 Field or reference 'test.t1.f1' of SELECT #2 was resolved in SELECT #1
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT (SELECT MAX(t2.f4) FROM t2 WHERE t2.f3=t1.f1) FROM t1;
@@ -5463,12 +4797,6 @@ EXPLAIN
Warnings:
Note 1276 Field or reference 'test.t1.f1' of SELECT #2 was resolved in SELECT #1
Note 1003 /* select#1 */ select (/* select#2 */ select max(`test`.`t2`.`f4`) from `test`.`t2` where (`test`.`t2`.`f3` = `test`.`t1`.`f1`)) AS `(SELECT MAX(t2.f4) FROM t2 WHERE t2.f3=t1.f1)` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 2
@@ -5567,12 +4895,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM v1 WHERE a > 0;
@@ -5615,12 +4937,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t11`.`a` AS `a`,`test`.`t12`.`a` AS `b` from `test`.`t1` `t11` join `test`.`t1` `t12` where (`test`.`t11`.`a` > 0)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 6
@@ -5687,12 +5003,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, v1 WHERE t1.a = v1.a;
@@ -5745,12 +5055,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t11`.`a` AS `a`,`test`.`t12`.`a` AS `b` from `test`.`t1` join `test`.`t1` `t11` join `test`.`t1` `t12` where (`test`.`t11`.`a` = `test`.`t1`.`a`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_rnd_next 9
@@ -5799,12 +5103,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM v1 WHERE a < 4;
@@ -5835,12 +5133,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` < 4)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -5906,12 +5198,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2, v1 WHERE t2.x = v1.a;
@@ -5955,12 +5241,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`x` AS `x`,`test`.`t1`.`a` AS `a`,(`test`.`t1`.`b` + 1) AS `c` from `test`.`t2` join `test`.`t1` where (`test`.`t1`.`a` = `test`.`t2`.`x`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 4
@@ -6027,12 +5307,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t2, v1 WHERE t2.x = v1.a;
@@ -6076,12 +5350,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t2`.`x` AS `x`,`test`.`t1`.`a` AS `a`,(`test`.`t1`.`b` + 1) AS `c` from `test`.`t2` join `test`.`t1` where (`test`.`t1`.`a` = `test`.`t2`.`x`)
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 4
@@ -6123,12 +5391,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT NULL;
@@ -6151,12 +5413,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select NULL AS `NULL`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
# Status of testing query execution:
@@ -6201,12 +5457,6 @@ EXPLAIN
] /* extra */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1;
@@ -6235,12 +5485,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select NULL AS `a` from `test`.`t1`
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_first 1
@@ -6326,12 +5570,6 @@ EXPLAIN
] /* where_subqueries */
} /* table */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a IN (SELECT * FROM (SELECT b FROM t2 ORDER BY b LIMIT 2,2) x);
@@ -6394,12 +5632,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where <in_optimizer>(`test`.`t1`.`a`,<exists>(<index_lookup>(<cache>(`test`.`t1`.`a`) in x on auto_key0)))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 3
@@ -6499,12 +5731,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, t2 WHERE a IN (SELECT * FROM (SELECT b FROM t2 ORDER BY b LIMIT 2,2) x);
@@ -6583,12 +5809,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t2`.`b` AS `b` from `test`.`t1` join `test`.`t2` where <in_optimizer>(`test`.`t1`.`a`,<exists>(<index_lookup>(<cache>(`test`.`t1`.`a`) in x on auto_key0)))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 3
@@ -6700,12 +5920,6 @@ EXPLAIN
] /* nested_loops */
} /* join */
}
-Validation:
-
-ok at line 2
-
-
-ALL OK
FLUSH STATUS;
FLUSH TABLES;
EXPLAIN EXTENDED SELECT * FROM t1, (SELECT * FROM t2) y WHERE a IN (SELECT * FROM (SELECT b FROM t2 ORDER BY b LIMIT 2,2) x);
@@ -6795,12 +6009,6 @@ EXPLAIN
}
Warnings:
Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`y`.`b` AS `b` from `test`.`t1` join (/* select#2 */ select `test`.`t2`.`b` AS `b` from `test`.`t2`) `y` where <in_optimizer>(`test`.`t1`.`a`,<exists>(<index_lookup>(<cache>(`test`.`t1`.`a`) in x on auto_key0)))
-Validation:
-
-ok at line 2
-
-
-ALL OK
# Status of "equivalent" SELECT query execution:
Variable_name Value
Handler_read_key 3
=== modified file 'mysql-test/t/innodb_explain_json_non_select_all.test'
--- a/mysql-test/t/innodb_explain_json_non_select_all.test 2011-11-16 15:09:45 +0000
+++ b/mysql-test/t/innodb_explain_json_non_select_all.test 2011-11-21 11:46:42 +0000
@@ -19,9 +19,11 @@ set @save_storage_engine= @@session.defa
set session default_storage_engine = InnoDB;
--let $innodb = 1
-# json validation in explain_util.inc can be switched off by setting to zero.
---let $json = 1
---let $validation = 1
+# Next 2 variables control the JSON format output and validation in explain_utils.
+# 1 = enable, 0 = disable
+--let $json = 1
+# Validation disabled due to not having Python with JSON on all PB machines.
+--let $validation = 0
--file_exists $MYSQL_TEST_DIR/suite/opt_trace/validate_json.py
--source include/explain_non_select.inc
=== modified file 'mysql-test/t/innodb_explain_json_non_select_none.test'
--- a/mysql-test/t/innodb_explain_json_non_select_none.test 2011-11-16 15:09:45 +0000
+++ b/mysql-test/t/innodb_explain_json_non_select_none.test 2011-11-21 11:46:42 +0000
@@ -28,8 +28,11 @@ if (`select locate('mrr', @@optimizer_sw
set @save_storage_engine= @@session.default_storage_engine;
set session default_storage_engine = InnoDB;
--let $innodb = 1
+# Next 2 variables control the JSON format output and validation in explain_utils.
+# 1 = enable, 0 = disable
--let $json = 1
---let $validation = 1
+# Validation disabled due to not having Python with JSON on all PB machines.
+--let $validation = 0
--source include/explain_non_select.inc
set default_storage_engine= @save_storage_engine;
=== modified file 'mysql-test/t/myisam_explain_json_non_select_all.test'
--- a/mysql-test/t/myisam_explain_json_non_select_all.test 2011-11-16 15:09:45 +0000
+++ b/mysql-test/t/myisam_explain_json_non_select_all.test 2011-11-21 11:46:42 +0000
@@ -15,8 +15,11 @@ set optimizer_switch='semijoin=on,materi
set @save_storage_engine= @@session.default_storage_engine;
set session default_storage_engine = MyISAM;
---let $json = 1
---let $validation = 1
+# Next 2 variables control the JSON format output and validation in explain_utils.
+# 1 = enable, 0 = disable
+--let $json = 1
+# Validation disabled due to not having Python with JSON on all PB machines.
+--let $validation = 0
--source include/explain_non_select.inc
set default_storage_engine= @save_storage_engine;
=== modified file 'mysql-test/t/myisam_explain_json_non_select_none.test'
--- a/mysql-test/t/myisam_explain_json_non_select_none.test 2011-11-16 15:09:45 +0000
+++ b/mysql-test/t/myisam_explain_json_non_select_none.test 2011-11-21 11:46:42 +0000
@@ -25,8 +25,11 @@ if (`select locate('mrr', @@optimizer_sw
set @save_storage_engine= @@session.default_storage_engine;
set session default_storage_engine = MyISAM;
---let $json = 1
---let $validation = 1
+# Next 2 variables control the JSON format output and validation in explain_utils.
+# 1 = enable, 0 = disable
+--let $json = 1
+# Validation disabled due to not having Python with JSON on all PB machines.
+--let $validation = 0
--source include/explain_non_select.inc
set default_storage_engine= @save_storage_engine;
No bundle (reason: useless for push emails).
| Thread |
|---|
| • bzr push into mysql-trunk branch (horst.hunger:3499 to 3500) | horst.hunger | 22 Nov |
