List:Commits« Previous MessageNext Message »
From:horst.hunger Date:November 21 2011 11:47am
Subject:bzr push into mysql-trunk branch (horst.hunger:3499 to 3500)
View as plain text  
 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.hunger22 Nov