/*!50400 SET SESSION optimizer_switch = 'firstmatch=off,index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,loosescan=off,materialization=off,semijoin=on' */;
/*!50400 SET SESSION optimizer_use_mrr = 'force' */;
/*!50400 SET SESSION engine_condition_pushdown = 'ON' */;
/*!50400 SET SESSION join_cache_level = 1 */;


#/* Begin test case for query 0 */

CREATE TABLE t1 (
  v VARCHAR(1) NULL
);

CREATE TABLE t2 (
  v VARCHAR(1) NULL
);

CREATE TABLE t3 (
  v VARCHAR(1) NULL
);

CREATE TABLE t4 (
  v VARCHAR(1) NULL,
  KEY (v)
);

INSERT  INTO t4 VALUES ('k'), ('r');

CREATE TABLE t5 (
  t TIME NULL,
  v VARCHAR(1) NULL,
  KEY (t),
  KEY (v)
);

INSERT INTO t5 VALUES (NULL,'r'), ('10:17:51','w'), ('06:34:09','b');
 
SELECT (  
   SELECT SUBQUERY1_t1.v
   FROM t2 SUBQUERY1_t1 STRAIGHT_JOIN t3 ON ('e','t')  IN (  
       SELECT v, MAX( SUBQUERY1_t1.v  )  
       FROM t1) ), table5.t field5
FROM t5 table5 JOIN t4 ON table5.v
ORDER BY field5;

DROP TABLE t1;
DROP TABLE t2;
DROP TABLE t3;
DROP TABLE t4;
DROP TABLE t5;
#/* End of test case for query 0 */