#/* Server0: MySQL 6.0.14-alpha-valgrind-max-debug-log */

SET SESSION OPTIMIZER_SWITCH = 'index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,firstmatch=on,loosescan=on,materialization=on,semijoin=off,mrr=on,mrr_cost_based=off,index_condition_pushdown=on';

SET SESSION optimizer_join_cache_level = 4;

#/* Begin test case for query 0 */

--disable_warnings
DROP TABLE /*! IF EXISTS */ F;
DROP TABLE /*! IF EXISTS */ H;
DROP TABLE /*! IF EXISTS */ O;
DROP TABLE /*! IF EXISTS */ J;
--enable_warnings

CREATE TABLE `F` (
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `col_int_key` int(11) DEFAULT NULL,
  `col_varchar_1024_utf8_key` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `col_varchar_10_latin1_key` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`pk`),
  KEY `col_int_key` (`col_int_key`),
  KEY `col_varchar_1024_utf8_key` (`col_varchar_1024_utf8_key`(255)),
  KEY `col_varchar_10_latin1_key` (`col_varchar_10_latin1_key`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
INSERT INTO `F` VALUES (1,8,NULL,'q');
INSERT INTO `F` VALUES (2,9,'l','o');
INSERT INTO `F` VALUES (3,6,NULL,'j');
INSERT INTO `F` VALUES (4,NULL,'o','o');
INSERT INTO `F` VALUES (5,8,'p','e');
INSERT INTO `F` VALUES (6,2,'b','f');
INSERT INTO `F` VALUES (7,7,'x','n');
INSERT INTO `F` VALUES (8,NULL,NULL,'u');
INSERT INTO `F` VALUES (9,NULL,'m',NULL);
INSERT INTO `F` VALUES (10,NULL,NULL,'o');
CREATE TABLE `H` (
  `col_varchar_10_latin1_key` varchar(10) DEFAULT NULL,
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `col_int_key` int(11) DEFAULT NULL,
  `col_varchar_1024_utf8_key` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`pk`),
  KEY `col_varchar_10_latin1_key` (`col_varchar_10_latin1_key`),
  KEY `col_int_key` (`col_int_key`),
  KEY `col_varchar_1024_utf8_key` (`col_varchar_1024_utf8_key`(255))
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
INSERT INTO `H` VALUES ('x',1,NULL,'w');
INSERT INTO `H` VALUES ('l',2,9,'p');
INSERT INTO `H` VALUES ('v',3,4,'h');
INSERT INTO `H` VALUES (NULL,4,1,'q');
INSERT INTO `H` VALUES ('v',5,9,'h');
INSERT INTO `H` VALUES ('c',6,NULL,'w');
INSERT INTO `H` VALUES ('g',7,3,'l');
INSERT INTO `H` VALUES ('x',8,4,'i');
INSERT INTO `H` VALUES ('i',9,6,'y');
INSERT INTO `H` VALUES (NULL,10,1,'r');
INSERT INTO `H` VALUES ('l',11,2,NULL);
INSERT INTO `H` VALUES (NULL,12,3,'f');
INSERT INTO `H` VALUES ('r',13,2,NULL);
INSERT INTO `H` VALUES ('c',14,NULL,'k');
INSERT INTO `H` VALUES ('w',15,3,'p');
INSERT INTO `H` VALUES ('a',16,9,'j');
INSERT INTO `H` VALUES (NULL,17,0,'m');
INSERT INTO `H` VALUES (NULL,18,3,'g');
INSERT INTO `H` VALUES ('c',19,4,'k');
INSERT INTO `H` VALUES ('f',20,4,'j');
CREATE TABLE `O` (
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `col_varchar_1024_utf8_key` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `col_int_key` int(11) DEFAULT NULL,
  `col_varchar_10_latin1_key` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`pk`),
  KEY `col_varchar_1024_utf8_key` (`col_varchar_1024_utf8_key`(444)),
  KEY `col_int_key` (`col_int_key`),
  KEY `col_varchar_10_latin1_key` (`col_varchar_10_latin1_key`)
) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=latin1;
INSERT INTO `O` VALUES (1,'j',NULL,'w');
INSERT INTO `O` VALUES (2,'w',8,'w');
INSERT INTO `O` VALUES (3,NULL,1,'n');
INSERT INTO `O` VALUES (4,NULL,8,'z');
INSERT INTO `O` VALUES (5,'t',3,NULL);
INSERT INTO `O` VALUES (6,'w',1,NULL);
INSERT INTO `O` VALUES (7,NULL,5,'h');
INSERT INTO `O` VALUES (8,'c',NULL,'l');
INSERT INTO `O` VALUES (9,'p',NULL,'u');
INSERT INTO `O` VALUES (10,NULL,2,'y');
INSERT INTO `O` VALUES (11,'t',NULL,NULL);
INSERT INTO `O` VALUES (12,'v',7,NULL);
INSERT INTO `O` VALUES (13,'b',0,NULL);
INSERT INTO `O` VALUES (14,'w',0,'z');
INSERT INTO `O` VALUES (15,'w',3,'u');
INSERT INTO `O` VALUES (16,'z',NULL,'k');
INSERT INTO `O` VALUES (17,'s',6,'f');
INSERT INTO `O` VALUES (18,'z',NULL,'d');
INSERT INTO `O` VALUES (19,NULL,9,'g');
INSERT INTO `O` VALUES (20,'q',4,'r');
INSERT INTO `O` VALUES (21,NULL,4,'t');
INSERT INTO `O` VALUES (22,'f',6,'t');
INSERT INTO `O` VALUES (23,'c',0,NULL);
INSERT INTO `O` VALUES (24,'i',NULL,NULL);
INSERT INTO `O` VALUES (25,NULL,2,NULL);
INSERT INTO `O` VALUES (26,NULL,1,'w');
INSERT INTO `O` VALUES (27,'t',NULL,'k');
INSERT INTO `O` VALUES (28,NULL,NULL,'f');
INSERT INTO `O` VALUES (29,'l',8,'e');
INSERT INTO `O` VALUES (30,'f',8,'a');
INSERT INTO `O` VALUES (31,'n',NULL,'e');
INSERT INTO `O` VALUES (32,'w',9,'h');
INSERT INTO `O` VALUES (33,'q',2,'x');
INSERT INTO `O` VALUES (34,'s',2,'p');
INSERT INTO `O` VALUES (35,NULL,2,NULL);
INSERT INTO `O` VALUES (36,'c',3,'p');
INSERT INTO `O` VALUES (37,'a',1,'q');
INSERT INTO `O` VALUES (38,'n',1,'k');
INSERT INTO `O` VALUES (39,'y',NULL,'r');
INSERT INTO `O` VALUES (40,'v',5,'v');
INSERT INTO `O` VALUES (41,'r',NULL,'t');
INSERT INTO `O` VALUES (42,'a',3,'e');
INSERT INTO `O` VALUES (43,'w',3,'a');
INSERT INTO `O` VALUES (44,'u',3,'j');
INSERT INTO `O` VALUES (45,'n',2,NULL);
INSERT INTO `O` VALUES (46,'u',5,'z');
INSERT INTO `O` VALUES (47,'w',3,NULL);
INSERT INTO `O` VALUES (48,NULL,2,'w');
INSERT INTO `O` VALUES (49,'c',2,'p');
INSERT INTO `O` VALUES (50,'e',7,'d');
INSERT INTO `O` VALUES (51,'d',1,'c');
INSERT INTO `O` VALUES (52,'k',NULL,'i');
INSERT INTO `O` VALUES (53,'c',8,'j');
INSERT INTO `O` VALUES (54,'b',7,'l');
INSERT INTO `O` VALUES (55,'t',9,'d');
INSERT INTO `O` VALUES (56,'b',0,'s');
INSERT INTO `O` VALUES (57,'j',NULL,NULL);
INSERT INTO `O` VALUES (58,'h',2,'d');
INSERT INTO `O` VALUES (59,'h',6,NULL);
INSERT INTO `O` VALUES (60,NULL,2,'l');
INSERT INTO `O` VALUES (61,'v',4,'j');
INSERT INTO `O` VALUES (62,'q',6,'n');
INSERT INTO `O` VALUES (63,'s',0,'k');
INSERT INTO `O` VALUES (64,NULL,3,'y');
INSERT INTO `O` VALUES (65,NULL,1,'b');
INSERT INTO `O` VALUES (66,NULL,NULL,'h');
INSERT INTO `O` VALUES (67,'s',6,'s');
INSERT INTO `O` VALUES (68,'v',0,'k');
INSERT INTO `O` VALUES (69,'l',6,'y');
INSERT INTO `O` VALUES (70,'m',1,'j');
INSERT INTO `O` VALUES (71,'k',1,'x');
INSERT INTO `O` VALUES (72,'v',5,'j');
INSERT INTO `O` VALUES (73,'d',NULL,'b');
INSERT INTO `O` VALUES (74,'j',9,'t');
INSERT INTO `O` VALUES (75,NULL,4,'i');
INSERT INTO `O` VALUES (76,'f',4,'d');
INSERT INTO `O` VALUES (77,'d',NULL,'r');
INSERT INTO `O` VALUES (78,'k',8,NULL);
INSERT INTO `O` VALUES (79,NULL,2,'e');
INSERT INTO `O` VALUES (80,NULL,7,'m');
INSERT INTO `O` VALUES (81,'c',4,'y');
INSERT INTO `O` VALUES (82,'r',0,'g');
INSERT INTO `O` VALUES (83,NULL,1,NULL);
INSERT INTO `O` VALUES (84,NULL,NULL,'k');
INSERT INTO `O` VALUES (85,'i',8,'l');
INSERT INTO `O` VALUES (86,NULL,9,'v');
INSERT INTO `O` VALUES (87,'q',9,'x');
INSERT INTO `O` VALUES (88,'u',NULL,'m');
INSERT INTO `O` VALUES (89,NULL,9,'u');
INSERT INTO `O` VALUES (90,'j',1,'s');
INSERT INTO `O` VALUES (91,'x',5,'p');
INSERT INTO `O` VALUES (92,'c',NULL,'r');
INSERT INTO `O` VALUES (93,'i',3,'x');
INSERT INTO `O` VALUES (94,'g',7,'e');
INSERT INTO `O` VALUES (95,'t',NULL,'n');
INSERT INTO `O` VALUES (96,'v',2,'n');
INSERT INTO `O` VALUES (97,NULL,4,'t');
INSERT INTO `O` VALUES (98,NULL,4,'b');
INSERT INTO `O` VALUES (99,'n',6,'n');
INSERT INTO `O` VALUES (100,'h',0,'z');
CREATE TABLE `J` (
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `col_varchar_1024_utf8_key` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `col_varchar_10_latin1_key` varchar(10) DEFAULT NULL,
  `col_int_key` int(11) DEFAULT NULL,
  PRIMARY KEY (`pk`),
  KEY `col_varchar_1024_utf8_key` (`col_varchar_1024_utf8_key`(255)),
  KEY `col_varchar_10_latin1_key` (`col_varchar_10_latin1_key`),
  KEY `col_int_key` (`col_int_key`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
INSERT INTO `J` VALUES (1,'d','r',5);
INSERT INTO `J` VALUES (2,'c','q',1);
INSERT INTO `J` VALUES (3,'z','m',8);
INSERT INTO `J` VALUES (4,NULL,'i',8);
INSERT INTO `J` VALUES (5,'p','j',7);
INSERT INTO `J` VALUES (6,'x','o',NULL);
INSERT INTO `J` VALUES (7,'i','p',7);
INSERT INTO `J` VALUES (8,'x','h',8);
INSERT INTO `J` VALUES (9,'v',NULL,1);
INSERT INTO `J` VALUES (10,'u','v',3);
INSERT INTO `J` VALUES (11,NULL,NULL,4);
INSERT INTO `J` VALUES (12,NULL,'a',4);
INSERT INTO `J` VALUES (13,'x','z',8);
INSERT INTO `J` VALUES (14,'e','m',5);
INSERT INTO `J` VALUES (15,'u','z',NULL);
INSERT INTO `J` VALUES (16,'i','j',NULL);
INSERT INTO `J` VALUES (17,'n','d',NULL);
INSERT INTO `J` VALUES (18,'b','z',9);
INSERT INTO `J` VALUES (19,'i','x',8);
INSERT INTO `J` VALUES (20,'w','w',6);
INSERT INTO `J` VALUES (21,'n',NULL,7);
INSERT INTO `J` VALUES (22,NULL,NULL,NULL);
INSERT INTO `J` VALUES (23,'n','g',NULL);
INSERT INTO `J` VALUES (24,NULL,'s',6);
INSERT INTO `J` VALUES (25,'d',NULL,0);


 
SELECT table2 .`col_varchar_1024_utf8_key`  
FROM H table2  LEFT  JOIN F table3  JOIN J table4  ON table3 .`col_int_key`  = table4 .`pk`  LEFT  JOIN O table5  ON table5 .`col_varchar_10_latin1_key`  ON table2 .`col_varchar_10_latin1_key`  > table3 .`col_varchar_10_latin1_key`   ;

DROP TABLE F;
DROP TABLE H;
DROP TABLE O;
DROP TABLE J;
#/* End of test case for query 0 */

#/* Begin test case for query 1 */

--disable_warnings
DROP TABLE /*! IF EXISTS */ H;
DROP TABLE /*! IF EXISTS */ F;
DROP TABLE /*! IF EXISTS */ O;
DROP TABLE /*! IF EXISTS */ J;
--enable_warnings

CREATE TABLE `H` (
  `col_varchar_10_latin1_key` varchar(10) DEFAULT NULL,
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `col_int_key` int(11) DEFAULT NULL,
  `col_varchar_1024_latin1_key` varchar(1024) DEFAULT NULL,
  `col_varchar_1024_utf8_key` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `col_varchar_10_utf8` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`pk`),
  KEY `col_varchar_10_latin1_key` (`col_varchar_10_latin1_key`),
  KEY `col_int_key` (`col_int_key`),
  KEY `col_varchar_1024_latin1_key` (`col_varchar_1024_latin1_key`(767)),
  KEY `col_varchar_1024_utf8_key` (`col_varchar_1024_utf8_key`(255))
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
INSERT INTO `H` VALUES ('x',1,NULL,NULL,'w','d');
INSERT INTO `H` VALUES ('l',2,9,NULL,'p','x');
INSERT INTO `H` VALUES ('v',3,4,'m','h','s');
INSERT INTO `H` VALUES (NULL,4,1,'m','q','e');
INSERT INTO `H` VALUES ('v',5,9,'z','h','m');
INSERT INTO `H` VALUES ('c',6,NULL,NULL,'w','x');
INSERT INTO `H` VALUES ('g',7,3,'b','l','d');
INSERT INTO `H` VALUES ('x',8,4,NULL,'i','d');
INSERT INTO `H` VALUES ('i',9,6,'t','y','x');
INSERT INTO `H` VALUES (NULL,10,1,NULL,'r','u');
INSERT INTO `H` VALUES ('l',11,2,NULL,NULL,'s');
INSERT INTO `H` VALUES (NULL,12,3,'b','f','t');
INSERT INTO `H` VALUES ('r',13,2,'x',NULL,'z');
INSERT INTO `H` VALUES ('c',14,NULL,NULL,'k','q');
INSERT INTO `H` VALUES ('w',15,3,'q','p','y');
INSERT INTO `H` VALUES ('a',16,9,'c','j',NULL);
INSERT INTO `H` VALUES (NULL,17,0,'j','m','v');
INSERT INTO `H` VALUES (NULL,18,3,'h','g','d');
INSERT INTO `H` VALUES ('c',19,4,NULL,'k','v');
INSERT INTO `H` VALUES ('f',20,4,'u','j','w');
CREATE TABLE `F` (
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `col_varchar_1024_latin1_key` varchar(1024) DEFAULT NULL,
  `col_int_key` int(11) DEFAULT NULL,
  `col_varchar_10_utf8` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `col_varchar_1024_utf8_key` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `col_varchar_10_latin1_key` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`pk`),
  KEY `col_varchar_1024_latin1_key` (`col_varchar_1024_latin1_key`(767)),
  KEY `col_int_key` (`col_int_key`),
  KEY `col_varchar_1024_utf8_key` (`col_varchar_1024_utf8_key`(255)),
  KEY `col_varchar_10_latin1_key` (`col_varchar_10_latin1_key`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
INSERT INTO `F` VALUES (1,NULL,8,'e',NULL,'q');
INSERT INTO `F` VALUES (2,NULL,9,'s','l','o');
INSERT INTO `F` VALUES (3,'d',6,'z',NULL,'j');
INSERT INTO `F` VALUES (4,'u',NULL,'f','o','o');
INSERT INTO `F` VALUES (5,'m',8,'z','p','e');
INSERT INTO `F` VALUES (6,NULL,2,NULL,'b','f');
INSERT INTO `F` VALUES (7,'e',7,NULL,'x','n');
INSERT INTO `F` VALUES (8,NULL,NULL,'y',NULL,'u');
INSERT INTO `F` VALUES (9,NULL,NULL,'s','m',NULL);
INSERT INTO `F` VALUES (10,'n',NULL,NULL,NULL,'o');
CREATE TABLE `O` (
  `col_varchar_1024_latin1_key` varchar(1024) DEFAULT NULL,
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `col_varchar_1024_utf8_key` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `col_int_key` int(11) DEFAULT NULL,
  `col_varchar_10_utf8` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `col_varchar_10_latin1_key` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`pk`),
  KEY `col_varchar_1024_latin1_key` (`col_varchar_1024_latin1_key`),
  KEY `col_varchar_1024_utf8_key` (`col_varchar_1024_utf8_key`(444)),
  KEY `col_int_key` (`col_int_key`),
  KEY `col_varchar_10_latin1_key` (`col_varchar_10_latin1_key`)
) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=latin1;
INSERT INTO `O` VALUES ('k',1,'j',NULL,'o','w');
INSERT INTO `O` VALUES ('v',2,'w',8,'u','w');
INSERT INTO `O` VALUES ('u',3,NULL,1,NULL,'n');
INSERT INTO `O` VALUES ('k',4,NULL,8,'n','z');
INSERT INTO `O` VALUES ('y',5,'t',3,'y',NULL);
INSERT INTO `O` VALUES ('u',6,'w',1,'k',NULL);
INSERT INTO `O` VALUES (NULL,7,NULL,5,'i','h');
INSERT INTO `O` VALUES ('w',8,'c',NULL,NULL,'l');
INSERT INTO `O` VALUES ('m',9,'p',NULL,'d','u');
INSERT INTO `O` VALUES ('x',10,NULL,2,NULL,'y');
INSERT INTO `O` VALUES ('s',11,'t',NULL,'l',NULL);
INSERT INTO `O` VALUES ('e',12,'v',7,'v',NULL);
INSERT INTO `O` VALUES ('i',13,'b',0,'g',NULL);
INSERT INTO `O` VALUES ('b',14,'w',0,'i','z');
INSERT INTO `O` VALUES ('t',15,'w',3,'g','u');
INSERT INTO `O` VALUES ('i',16,'z',NULL,'n','k');
INSERT INTO `O` VALUES ('t',17,'s',6,NULL,'f');
INSERT INTO `O` VALUES ('w',18,'z',NULL,'w','d');
INSERT INTO `O` VALUES ('f',19,NULL,9,'t','g');
INSERT INTO `O` VALUES (NULL,20,'q',4,NULL,'r');
INSERT INTO `O` VALUES ('j',21,NULL,4,NULL,'t');
INSERT INTO `O` VALUES (NULL,22,'f',6,'l','t');
INSERT INTO `O` VALUES ('f',23,'c',0,NULL,NULL);
INSERT INTO `O` VALUES ('c',24,'i',NULL,'h',NULL);
INSERT INTO `O` VALUES ('m',25,NULL,2,'o',NULL);
INSERT INTO `O` VALUES ('x',26,NULL,1,'g','w');
INSERT INTO `O` VALUES ('s',27,'t',NULL,NULL,'k');
INSERT INTO `O` VALUES ('s',28,NULL,NULL,NULL,'f');
INSERT INTO `O` VALUES ('z',29,'l',8,'d','e');
INSERT INTO `O` VALUES ('x',30,'f',8,NULL,'a');
INSERT INTO `O` VALUES ('i',31,'n',NULL,'q','e');
INSERT INTO `O` VALUES ('e',32,'w',9,NULL,'h');
INSERT INTO `O` VALUES ('h',33,'q',2,'g','x');
INSERT INTO `O` VALUES ('y',34,'s',2,NULL,'p');
INSERT INTO `O` VALUES ('r',35,NULL,2,'i',NULL);
INSERT INTO `O` VALUES ('a',36,'c',3,NULL,'p');
INSERT INTO `O` VALUES ('q',37,'a',1,'l','q');
INSERT INTO `O` VALUES ('m',38,'n',1,NULL,'k');
INSERT INTO `O` VALUES ('t',39,'y',NULL,NULL,'r');
INSERT INTO `O` VALUES ('p',40,'v',5,'f','v');
INSERT INTO `O` VALUES ('j',41,'r',NULL,'u','t');
INSERT INTO `O` VALUES (NULL,42,'a',3,'m','e');
INSERT INTO `O` VALUES ('u',43,'w',3,'m','a');
INSERT INTO `O` VALUES ('o',44,'u',3,'j','j');
INSERT INTO `O` VALUES ('j',45,'n',2,'j',NULL);
INSERT INTO `O` VALUES ('q',46,'u',5,'s','z');
INSERT INTO `O` VALUES (NULL,47,'w',3,NULL,NULL);
INSERT INTO `O` VALUES ('l',48,NULL,2,'x','w');
INSERT INTO `O` VALUES ('s',49,'c',2,'w','p');
INSERT INTO `O` VALUES ('n',50,'e',7,'g','d');
INSERT INTO `O` VALUES (NULL,51,'d',1,'b','c');
INSERT INTO `O` VALUES (NULL,52,'k',NULL,'b','i');
INSERT INTO `O` VALUES ('k',53,'c',8,'h','j');
INSERT INTO `O` VALUES ('c',54,'b',7,'b','l');
INSERT INTO `O` VALUES ('o',55,'t',9,NULL,'d');
INSERT INTO `O` VALUES ('h',56,'b',0,'o','s');
INSERT INTO `O` VALUES (NULL,57,'j',NULL,'k',NULL);
INSERT INTO `O` VALUES ('f',58,'h',2,'o','d');
INSERT INTO `O` VALUES ('d',59,'h',6,'k',NULL);
INSERT INTO `O` VALUES ('g',60,NULL,2,'f','l');
INSERT INTO `O` VALUES (NULL,61,'v',4,'w','j');
INSERT INTO `O` VALUES ('n',62,'q',6,NULL,'n');
INSERT INTO `O` VALUES ('v',63,'s',0,'y','k');
INSERT INTO `O` VALUES ('a',64,NULL,3,NULL,'y');
INSERT INTO `O` VALUES ('e',65,NULL,1,NULL,'b');
INSERT INTO `O` VALUES ('u',66,NULL,NULL,'y','h');
INSERT INTO `O` VALUES ('x',67,'s',6,NULL,'s');
INSERT INTO `O` VALUES (NULL,68,'v',0,'e','k');
INSERT INTO `O` VALUES ('c',69,'l',6,'y','y');
INSERT INTO `O` VALUES ('t',70,'m',1,'h','j');
INSERT INTO `O` VALUES (NULL,71,'k',1,'i','x');
INSERT INTO `O` VALUES (NULL,72,'v',5,'o','j');
INSERT INTO `O` VALUES (NULL,73,'d',NULL,'a','b');
INSERT INTO `O` VALUES ('u',74,'j',9,'l','t');
INSERT INTO `O` VALUES ('v',75,NULL,4,NULL,'i');
INSERT INTO `O` VALUES (NULL,76,'f',4,'o','d');
INSERT INTO `O` VALUES ('h',77,'d',NULL,'i','r');
INSERT INTO `O` VALUES ('j',78,'k',8,'b',NULL);
INSERT INTO `O` VALUES ('y',79,NULL,2,'d','e');
INSERT INTO `O` VALUES ('z',80,NULL,7,'u','m');
INSERT INTO `O` VALUES ('q',81,'c',4,'z','y');
INSERT INTO `O` VALUES ('w',82,'r',0,NULL,'g');
INSERT INTO `O` VALUES ('t',83,NULL,1,NULL,NULL);
INSERT INTO `O` VALUES (NULL,84,NULL,NULL,NULL,'k');
INSERT INTO `O` VALUES ('t',85,'i',8,'e','l');
INSERT INTO `O` VALUES ('s',86,NULL,9,NULL,'v');
INSERT INTO `O` VALUES ('h',87,'q',9,'y','x');
INSERT INTO `O` VALUES (NULL,88,'u',NULL,NULL,'m');
INSERT INTO `O` VALUES ('v',89,NULL,9,'g','u');
INSERT INTO `O` VALUES (NULL,90,'j',1,'c','s');
INSERT INTO `O` VALUES ('x',91,'x',5,'j','p');
INSERT INTO `O` VALUES ('n',92,'c',NULL,'x','r');
INSERT INTO `O` VALUES (NULL,93,'i',3,NULL,'x');
INSERT INTO `O` VALUES ('j',94,'g',7,'p','e');
INSERT INTO `O` VALUES (NULL,95,'t',NULL,NULL,'n');
INSERT INTO `O` VALUES (NULL,96,'v',2,'b','n');
INSERT INTO `O` VALUES (NULL,97,NULL,4,NULL,'t');
INSERT INTO `O` VALUES ('q',98,NULL,4,'b','b');
INSERT INTO `O` VALUES ('j',99,'n',6,'b','n');
INSERT INTO `O` VALUES ('m',100,'h',0,'o','z');
CREATE TABLE `J` (
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `col_varchar_1024_utf8_key` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `col_varchar_1024_latin1_key` varchar(1024) DEFAULT NULL,
  `col_varchar_10_utf8` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `col_varchar_10_latin1_key` varchar(10) DEFAULT NULL,
  `col_int_key` int(11) DEFAULT NULL,
  PRIMARY KEY (`pk`),
  KEY `col_varchar_1024_utf8_key` (`col_varchar_1024_utf8_key`(255)),
  KEY `col_varchar_1024_latin1_key` (`col_varchar_1024_latin1_key`(767)),
  KEY `col_varchar_10_latin1_key` (`col_varchar_10_latin1_key`),
  KEY `col_int_key` (`col_int_key`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
INSERT INTO `J` VALUES (1,'d','l',NULL,'r',5);
INSERT INTO `J` VALUES (2,'c','t','a','q',1);
INSERT INTO `J` VALUES (3,'z','m','l','m',8);
INSERT INTO `J` VALUES (4,NULL,'a',NULL,'i',8);
INSERT INTO `J` VALUES (5,'p','i',NULL,'j',7);
INSERT INTO `J` VALUES (6,'x',NULL,'t','o',NULL);
INSERT INTO `J` VALUES (7,'i','f',NULL,'p',7);
INSERT INTO `J` VALUES (8,'x','i','h','h',8);
INSERT INTO `J` VALUES (9,'v','p','k',NULL,1);
INSERT INTO `J` VALUES (10,'u',NULL,'r','v',3);
INSERT INTO `J` VALUES (11,NULL,'v','w',NULL,4);
INSERT INTO `J` VALUES (12,NULL,'t',NULL,'a',4);
INSERT INTO `J` VALUES (13,'x','c','m','z',8);
INSERT INTO `J` VALUES (14,'e','w','w','m',5);
INSERT INTO `J` VALUES (15,'u','y','x','z',NULL);
INSERT INTO `J` VALUES (16,'i','r','u','j',NULL);
INSERT INTO `J` VALUES (17,'n','f',NULL,'d',NULL);
INSERT INTO `J` VALUES (18,'b','a','k','z',9);
INSERT INTO `J` VALUES (19,'i','o',NULL,'x',8);
INSERT INTO `J` VALUES (20,'w',NULL,'z','w',6);
INSERT INTO `J` VALUES (21,'n','z','j',NULL,7);
INSERT INTO `J` VALUES (22,NULL,'r','i',NULL,NULL);
INSERT INTO `J` VALUES (23,'n','l','g','g',NULL);
INSERT INTO `J` VALUES (24,NULL,'z','w','s',6);
INSERT INTO `J` VALUES (25,'d',NULL,NULL,NULL,0);




SELECT    table2 . `col_varchar_1024_utf8_key` AS field1 
FROM  F AS table1  RIGHT  JOIN  H AS table2  LEFT  JOIN   F AS table3  LEFT  JOIN J AS table4 ON  table3 . `col_int_key` =  table4 . `pk`   LEFT  JOIN O AS table5 ON  table4 . `col_varchar_1024_utf8_key` =  table5 . `col_varchar_10_latin1_key`  ON  table2 . `col_varchar_10_latin1_key` >  table3 . `col_varchar_10_latin1_key`  ON  table1 . `pk` =  table4 . `pk`  
WHERE   table1 . `pk` IS  NULL OR  table1 . `col_varchar_1024_latin1_key` >= 'u' AND table1 . `col_varchar_1024_latin1_key` < 'o' OR table1 . `col_varchar_1024_latin1_key` >= 'FDBUW' AND table1 . `col_varchar_1024_latin1_key` < 'j' AND table1 . `col_varchar_1024_latin1_key` >= 'q' AND table1 . `col_varchar_1024_latin1_key` <= 'z' OR   table1 . `col_varchar_1024_latin1_key` >= 'q' AND table1 . `col_varchar_1024_latin1_key` <= 'zzzz' OR  table1 . `col_varchar_1024_utf8_key`  BETWEEN 'w' AND 'z' AND  table1 . `col_varchar_1024_latin1_key`  IN ( 'is' ) OR table1 . `col_varchar_10_utf8`  IN ( 'a', 'hey' )  
GROUP BY field1
;

DROP TABLE H;
DROP TABLE F;
DROP TABLE O;
DROP TABLE J;
#/* End of test case for query 1 */