#/* Server0: MySQL 6.0.14-alpha-debug-log */
#/* Server1: MySQL 5.6.99-m4-debug-log */

--source include/have_innodb.inc

--disable_query_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 = 8;
--enable_query_log

#/* Begin test case for query 0 */

--disable_warnings
DROP TABLE /*! IF EXISTS */ F;
DROP TABLE /*! IF EXISTS */ N;
--enable_warnings

CREATE TABLE `F` (
  `col_int` int(11) DEFAULT NULL,
  `col_varchar_1024_latin1_key` varchar(1024) DEFAULT NULL,
  `col_int_key` int(11) DEFAULT NULL,
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`pk`),
  KEY `test_idx` (`col_int_key`,`col_int`,`pk`) USING HASH
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

INSERT INTO `F` VALUES (4,'u',NULL,1);
INSERT INTO `F` VALUES (1160183808,'string0',NULL,3);
INSERT INTO `F` VALUES (-502202368,'oh',6,5);
INSERT INTO `F` VALUES (NULL,'can',NULL,7);
INSERT INTO `F` VALUES (3,'q',NULL,9);


CREATE TABLE `N` (
  `col_int_key` int(11) DEFAULT NULL,
  `col_varchar_1024_latin1_key` varchar(1024) DEFAULT NULL,
  KEY `col_int_key` (`col_int_key`),
  KEY `col_varchar_1024_latin1_key` (`col_varchar_1024_latin1_key`(767))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `N` VALUES (NULL,'m');
INSERT INTO `N` VALUES (NULL,'p');
INSERT INTO `N` VALUES (NULL,'now');
INSERT INTO `N` VALUES (NULL,'TSUNV');
INSERT INTO `N` VALUES (NULL,'string1');
INSERT INTO `N` VALUES (NULL,'how');
INSERT INTO `N` VALUES (NULL,'OYPEN');
INSERT INTO `N` VALUES (NULL,'q');
INSERT INTO `N` VALUES (NULL,'d');
INSERT INTO `N` VALUES (NULL,'tell');
INSERT INTO `N` VALUES (NULL,'string2');
INSERT INTO `N` VALUES (NULL,'y');
INSERT INTO `N` VALUES (NULL,'k');
INSERT INTO `N` VALUES (NULL,'your');
INSERT INTO `N` VALUES (NULL,'ok');
INSERT INTO `N` VALUES (NULL,'like');
INSERT INTO `N` VALUES (NULL,'UILXF');
INSERT INTO `N` VALUES (NULL,'my');
INSERT INTO `N` VALUES (NULL,'VPZDI');
INSERT INTO `N` VALUES (NULL,'t');
INSERT INTO `N` VALUES (6,'as');
INSERT INTO `N` VALUES (NULL,'string3');
INSERT INTO `N` VALUES (NULL,'when');
INSERT INTO `N` VALUES (NULL,'I');
INSERT INTO `N` VALUES (NULL,'string4');
INSERT INTO `N` VALUES (NULL,'string5');
INSERT INTO `N` VALUES (NULL,'at');
INSERT INTO `N` VALUES (NULL,'his');


 
SELECT table2 .`col_varchar_1024_latin1_key`  
FROM F table1  
  LEFT  JOIN N table2  ON table1 .`col_int_key`  = table2 .`col_int_key`   ;


DROP TABLE F;
DROP TABLE N;