Debian Codegraph @

mysql-test/suite/ndb_opt/spj_rqg.test

raw
1 -- source include/have_ndb.inc
2
3 #
4 # Test suite include interesting queries extracted from RQG
5 # testing of SPJ. It should be a home for such queries captured
6 # during existing and future SPJ development.
7 #
8
9 # Create the RQG test tables, captured with mysqldump
10
11 --disable_query_log
12 --disable_warnings
13
14 CREATE TABLE a (
15 `col_datetime_unique` datetime DEFAULT NULL,
16 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
17 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
18 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
19 `col_int` int DEFAULT NULL,
20 `col_int_unique` int DEFAULT NULL,
21 `col_datetime_key` datetime DEFAULT NULL,
22 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
23 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
24 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
25 `col_int_key` int DEFAULT NULL,
26 `col_datetime` datetime DEFAULT NULL,
27 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
28 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
29 `pk` int NOT NULL AUTO_INCREMENT,
30 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
31 PRIMARY KEY (`pk`),
32 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
33 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
34 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
35 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
36 UNIQUE KEY `ix1` (`col_int_unique`),
37 KEY `col_varchar_256_key` (`col_varchar_256_key`),
38 KEY `col_datetime_key` (`col_datetime_key`),
39 KEY `col_char_16_key` (`col_char_16_key`),
40 KEY `col_varchar_10_key` (`col_varchar_10_key`),
41 KEY `col_int_key` (`col_int_key`)
42 ) ENGINE=ndbcluster;
43
44 # Table a is intentionally empty
45
46 CREATE TABLE b (
47 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
48 `col_int` int DEFAULT NULL,
49 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
50 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
51 `col_int_unique` int DEFAULT NULL,
52 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
53 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
54 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
55 `col_datetime_unique` datetime DEFAULT NULL,
56 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
57 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
58 `col_int_key` int DEFAULT NULL,
59 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
60 `col_datetime` datetime DEFAULT NULL,
61 `col_datetime_key` datetime DEFAULT NULL,
62 `pk` int NOT NULL AUTO_INCREMENT,
63 PRIMARY KEY (`pk`),
64 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
65 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
66 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
67 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
68 UNIQUE KEY `ix1` (`col_int_unique`) USING HASH,
69 KEY `col_varchar_256_key` (`col_varchar_256_key`),
70 KEY `col_char_16_key` (`col_char_16_key`),
71 KEY `col_varchar_10_key` (`col_varchar_10_key`),
72 KEY `col_int_key` (`col_int_key`),
73 KEY `col_datetime_key` (`col_datetime_key`)
74 ) ENGINE=ndbcluster;
75
76 INSERT INTO b VALUES ('tefqsdksjijcszxw',1,'efqsdksjijcszx','his',13,'we','say','hey',NULL,'fqsdksjijcszxwbj','the',1,'the','2003-12-25 15:33:21',NULL,1);
77
78
79 CREATE TABLE c (
80 `pk` int NOT NULL,
81 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
82 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
83 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
84 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
85 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
86 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
87 `col_datetime` datetime DEFAULT NULL,
88 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
89 `col_int_unique` int DEFAULT NULL,
90 `col_datetime_unique` datetime DEFAULT NULL,
91 `col_datetime_key` datetime DEFAULT NULL,
92 `col_int` int NOT NULL,
93 `col_int_key` int DEFAULT NULL,
94 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
95 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
96 PRIMARY KEY (`col_int`,`pk`),
97 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
98 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
99 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
100 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
101 KEY `col_varchar_256_key` (`col_varchar_256_key`),
102 KEY `col_char_16_key` (`col_char_16_key`),
103 KEY `col_datetime_key` (`col_datetime_key`),
104 KEY `col_int_key` (`col_int_key`),
105 KEY `col_varchar_10_key` (`col_varchar_10_key`),
106 KEY `ix1` (`col_int_unique`)
107 ) ENGINE=ndbcluster;
108
109 INSERT INTO c VALUES (1,'qsdksjijcs','sdksjijcsz','or','me','dksjijcszxwbjjvv','out','2007-10-10 21:18:40','ksjijcszxwbjjvvkymaluk',8,NULL,NULL,0,2,'sjijcszxwbj','jijcszxwbj'),
110 (3,'szxwbj','so','tell','zxwbjjvvkymalukq','out','xwbjjvvkym',NULL,'wbjjvvkym',40,'2005-09-12 16:35:00','2009-05-21 14:19:45',0,0,'bjjvvkymalukqu','jjvvkymalu'),
111 (5,'lukqukkoeiwsgpmfyv','tell','my','hey','how','ukqukkoe',NULL,'kqukkoeiwsgpmf',23,'2008-01-28 16:47:00','2002-07-16 16:31:18',2,2,'qukkoeiwsgpmf','from'),
112 (2,'ijcszxwbjjvvkymalukqukkoe','she','do','some','come','jcszxwbjjv','2008-04-12 17:03:52','cszxwbjjvvkymalukq',NULL,NULL,'2000-12-06 07:11:43',2,2,'him','well'),
113 (4,'just','jvvkymaluk','vvkymalukqukko','vkymalukqukkoeiw','kymalukqukkoeiws','mean',NULL,'ymalukquk',13,'2000-05-23 05:01:33','2002-04-19 18:28:34',0,3,'malukqukkoeiwsgp','alukqukkoe');
114
115
116 CREATE TABLE d (
117 `col_datetime_unique` datetime DEFAULT NULL,
118 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
119 `col_int_key` int DEFAULT NULL,
120 `col_int` int DEFAULT NULL,
121 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
122 `col_datetime_key` datetime DEFAULT NULL,
123 `pk` int NOT NULL AUTO_INCREMENT,
124 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
125 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
126 `col_datetime` datetime DEFAULT NULL,
127 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
128 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
129 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
130 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
131 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
132 `col_int_unique` int DEFAULT NULL,
133 PRIMARY KEY (`pk`),
134 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
135 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
136 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
137 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
138 UNIQUE KEY `ix1` (`col_int_unique`) USING HASH,
139 KEY `col_int_key` (`col_int_key`),
140 KEY `col_datetime_key` (`col_datetime_key`),
141 KEY `col_char_16_key` (`col_char_16_key`),
142 KEY `col_varchar_256_key` (`col_varchar_256_key`),
143 KEY `col_varchar_10_key` (`col_varchar_10_key`)
144 ) ENGINE=ndbcluster;
145
146 INSERT INTO d VALUES ('2004-10-25 03:34:36','something',0,1,'what',NULL,7,'from','lhtrovamzqrdcen','2006-09-06 08:49:41','why','she','htrovamzqr','me','trovamzqrd',NULL),
147 ('2004-04-27 09:07:20','mfyvvuqvtjncdsvqhlhtrovamzqrdcen',NULL,3,'something',NULL,3,'go','fyvvuqvtjncdsvqhlhtrovam',NULL,'yvvuqvtjncdsvqhl','vvuqvtjncd','vuqvtjncds','uqvtjncdsvqhlhtrovamz','qvtjncdsvq',90),
148 ('2004-07-28 05:54:12','can',3,1,'ncdsvqhlht',NULL,5,'it','he\'s','2000-01-06 20:32:48','cdsvqhlhtr','as','dsvqhlhtro','svqhlhtro','here',2),
149 (NULL,'ukkoeiwsgpmfyvvuqvtjn',3,3,'kkoeiwsgpmfyvvuq',NULL,1,'got','I\'m',NULL,'her','koeiwsgpmf','oeiwsgpmfy','eiwsgpmfyvvuqvt','I\'m',5),
150 ('2009-11-04 10:29:22','qrdcench',3,1,'think','2005-10-10 08:36:34',9,'rdcenchyhuoowity','his','2009-02-19 03:17:06','who','there','dcenchyhuo','cenchyhuoowityzgktbkjrkmqmkn','enchyhuoow',15),
151 ('2007-11-22 14:26:10','see',0,3,'how','2008-01-06 01:25:21',10,'think','nchyhuoowityzgktbkjr','2006-10-09 08:01:06','chyhuoowityzgkt','get','hyhuoo','or','right',13),
152 (NULL,'iwsgpmfyvvuqvtjncdsv',2,0,'wsgpmfyvvuqvtjnc',NULL,2,'mean','your',NULL,'when','sgpmfyvvuq','gpmfyvvuqv','like','pmfyvvuqvt',76),
153 (NULL,'my',2,1,'this','2001-08-05 23:15:50',4,'her','at','2006-09-13 07:51:54','vtjncdsvqhlhtrov','tjncd','it\'s','j','no',44),
154 ('2006-09-21 17:54:01','oh',2,1,'because','2001-07-22 08:21:06',6,'got','vqhlhtrovamzqrdcenchyhuoowi','2003-10-23 07:39:27','qhlh','time','hlhtrovamz','say','know',11),
155 ('2007-02-06 00:58:19','rovamzqrdcenchyhuoowi',3,NULL,'ovamzqrdcen','2006-05-20 14:32:39',8,'vamzqrdcenchyhuo','my','2003-05-04 01:51:45','now','amzqrdce','who','mz','zqrdcenchy',58);
156
157 CREATE TABLE e (
158 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
159 `col_datetime_unique` datetime DEFAULT NULL,
160 `col_int_unique` int DEFAULT NULL,
161 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
162 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
163 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
164 `col_int_key` int DEFAULT NULL,
165 `pk` int NOT NULL,
166 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
167 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
168 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
169 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
170 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
171 `col_datetime_key` datetime DEFAULT NULL,
172 `col_int` int NOT NULL,
173 `col_datetime` datetime DEFAULT NULL,
174 PRIMARY KEY (`col_int`,`pk`),
175 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
176 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
177 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
178 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
179 UNIQUE KEY `ix1` (`col_int_unique`),
180 KEY `col_varchar_10_key` (`col_varchar_10_key`),
181 KEY `col_char_16_key` (`col_char_16_key`),
182 KEY `col_varchar_256_key` (`col_varchar_256_key`),
183 KEY `col_int_key` (`col_int_key`),
184 KEY `col_datetime_key` (`col_datetime_key`)
185 ) ENGINE=ndbcluster;
186
187 INSERT INTO e VALUES ('from','2002-05-13 00:09:55',20,'about','you\'re','well',0,10,'xqxnvgqmwcidtumx','qxnvgqmwcidtumxwcftedx','xnvgq','nvgqmwcidtumxwcf','on','2006-11-26 04:25:48',2,NULL),
188 ('his','2004-03-01 14:16:54',46,'okay','rvqlzsvasurqdhuc','vql',3,7,'qlzsvasurqdhucjx','right','lzsvasurqdhucj','zsvasurqd','svasurqdhu','2003-09-16 10:44:08',1,NULL),
189 ('so','2007-06-12 12:16:07',NULL,'vasurqdhucjxdoyg','asurqdhucj','all',0,8,'or','of','surqdhucjxd','urq','right',NULL,0,NULL),
190 ('oh',NULL,21,'yeah','can\'t','cidtumxwcf',1,12,'idtumxwcfted','dtumxwcf','tumxwcftedxqyciakhxptzfpjw','will','they',NULL,1,NULL),
191 ('think','2007-08-05 11:09:40',75,'edxqyciakhxptzfp','this','your',0,15,'dxqyciakhxptzfpj','how','xqyciakhxptzfpjwrgeozxnbycjz','qyciakhxptzfpjwr','a','2007-04-22 03:28:54',2,NULL),
192 ('something','2005-12-09 14:34:01',3,'ityzgktbkjrkmq','you','at',3,3,'no','one','oh','no','tyzgktbkjr','2007-04-09 00:33:36',1,NULL),
193 ('all','2007-04-01 20:58:33',25,'yhuoowityzgktbkj','go','not',2,1,'had','him','been','could','huoowityzg','2007-09-04 14:55:55',1,'2004-06-17 16:53:16'),
194 ('tell','2008-07-20 03:43:16',0,'I','that','get',0,14,'cftedxq','something','ftedxqyciakhxptzfpjwrgeozxnbycjz','tedx','why','2002-06-20 09:15:26',1,NULL),
195 ('something',NULL,NULL,'j','some','xdoygxqxnv',2,9,'I\'ll','doygxqxnvgqmwcid','oygxqxnvgqm','ygxq','gxqxnvgqmw',NULL,1,NULL),
196 ('yciakhxptz',NULL,44,'ciakhxptzfpjwrge','iakhxptzfpjwrg','akhxptz',2,16,'khxptzfp','some','come','hxptzfpjwrg','xptzfpjwrg','2001-01-11 22:50:44',1,'2008-01-22 23:55:20'),
197 ('the',NULL,18,'yzgkt','zgktbkjrkmqmkn','if',2,4,'gktbkjrkmq','ktbk','tbkjrkmqmknbtoervqlzs','come','don\'t',NULL,2,NULL),
198 ('up','2005-03-10 11:52:47',38,'mean','uoowityzgktbkjrkmqmknbtoervqlz','oowi',0,2,'owityzgktbkjrkmq','or','wityzgktbkjrkmqmk','who','don\'t','2009-10-15 09:35:08',2,NULL),
199 ('him',NULL,28,'jrkmqmknbtoer','rkmqmknbto','kmqmknbtoe',0,6,'mqmknbtoervqlzsv','qmknbtoervqlzsvasur','you','mknbtoervqlzsvas','it\'s','2005-07-25 07:22:37',1,'2007-03-22 18:56:28'),
200 ('don\'t','2009-06-07 03:42:02',83,'like','think','go',2,18,'all','so','jwrgeozxnbycjzxiecurgmhbubpij','can','going','2006-08-06 13:49:47',0,NULL),
201 ('vgqmwcidtu','2006-12-12 15:35:16',88,'something','gqmwcidtumxwcftedxqyciakhx','qmwcidtumx',3,11,'and','got','mwc','my','wcidtum','2006-06-28 11:32:20',3,'2009-08-06 12:31:05'),
202 ('bkjrkmqmkn',NULL,96,'think','of','don\'t',2,5,'on','kjrkmqmknbtoer','no','now','want','2001-11-26 13:35:59',3,'2008-10-16 17:13:44'),
203 ('ptzfpjwrge','2007-10-20 02:54:44',9,'here','for','of',1,17,'tzf','back','zfpjw','fpjwrgeozxnbycjz','pjwrgeozxn',NULL,0,'2001-01-20 23:22:32'),
204 ('good','2001-07-09 00:44:58',24,'umxwcftedxqyci','mx','xwcftedxqy',0,13,'hey','wcftedxqyciakhxptzfpjwr','know','no','do',NULL,0,NULL);
205
206 CREATE TABLE f (
207 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
208 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
209 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
210 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
211 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
212 `pk` int NOT NULL,
213 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
214 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
215 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
216 `col_int_key` int DEFAULT NULL,
217 `col_datetime` datetime DEFAULT NULL,
218 `col_datetime_unique` datetime DEFAULT NULL,
219 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
220 `col_int` int NOT NULL,
221 `col_int_unique` int DEFAULT NULL,
222 `col_datetime_key` datetime DEFAULT NULL,
223 PRIMARY KEY (`col_int`,`pk`),
224 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
225 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
226 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
227 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
228 KEY `col_varchar_256_key` (`col_varchar_256_key`),
229 KEY `col_varchar_10_key` (`col_varchar_10_key`),
230 KEY `col_int_key` (`col_int_key`),
231 KEY `col_char_16_key` (`col_char_16_key`),
232 KEY `col_datetime_key` (`col_datetime_key`),
233 KEY `ix1` (`col_int_unique`)
234 ) ENGINE=ndbcluster;
235
236 INSERT INTO f VALUES ('dnozrhhcxsxwujulpjdzvkpaijurs','nozrhhcxsxwuju','ozrhhcxsxw','well','her',16,'she','his','zrhhcx',3,NULL,NULL,'that\'s',0,48,NULL),
237 ('dnkiwsrsxndolpujdnozrhhcx','up','nkiw','kiwsr','have',12,'iwsrsxndol','get','wsrsxndolp',1,NULL,'2006-05-01 04:47:33','I\'ll',0,9,'2004-11-08 11:25:23'),
238 ('nsmujjjbldnkiwsrsxndolpu','smujjjbldnkiwsrsxndolpujdnozrhh','that','that\'s','mujjjb',10,'are','uj','but',1,NULL,NULL,'but',2,77,NULL),
239 ('tell','bycjzxiecurgmh','ycjzxiecu','cjzxiecurgmhbubpi','jzxiecurgmhbubpi',3,'he\'s','say','zxiecurgmh',3,'2005-01-03 10:07:54',NULL,'some',1,15,'2003-02-26 07:57:11'),
240 ('ok','wrgeozxnbycjzxiecur','rgeozxnbyc','geozxnbycjzxiecurgmhb','why',1,'eozxnbycjz','can\'t','ozxnbycjzx',1,NULL,'2000-01-20 13:18:55','I\'m',1,3,NULL),
241 ('srsxndolpujdnozrhhcxsxwujulp','I\'m','rsxndolpuj','look','did',13,'and','sxndolpu','are',2,NULL,'2003-11-22 05:46:08','xndolpujdnozrhhc',2,39,NULL),
242 ('olpujdnoz','know','lpujdnozrh','pujdnoz','ujdnozrhhcxsxwuj',15,'this','when','jdnozrhhcx',2,NULL,NULL,'it\'s',3,2,'2005-08-08 10:02:43'),
243 ('gmhbubpijrllquntppirz','mh','hbubpij','bubpijrllquntppirzdphp','ubpijrllquntp',5,'bpijrllqun','pijrllquntppirzd','you',1,NULL,'2000-11-25 06:38:12','ijrllq',0,NULL,NULL),
244 ('pduhwqhnsmujjj','duhwqh','uhwqhnsmuj','hwqhnsmujjj','wq',9,'up','qhnsmujjjbldnkiw','hnsmujjjbl',0,NULL,'2005-06-13 00:26:39','say',2,7,'2002-03-22 21:29:22'),
245 ('it\'s','ndolpujdnozrhhcxsxwujulpjdzvkp','get','like','could',14,'dolpujdnoz','is','yes',1,'2004-01-10 13:39:11',NULL,'that',2,32,NULL),
246 ('all','here','quntppirzd','if','untppirzdphpduhw',7,'back','ntppirzdphpduhwq','tppirzdphp',2,NULL,NULL,'in',0,58,NULL),
247 ('rzdphpduhwqhnsmujj','zdphpduhwqhnsmujjjbldnki','time','dphpduhwqhnsmujjjbldn','p',8,'think','yeah','hpduhwqhns',0,'2007-07-25 16:33:46',NULL,'not',3,11,'2000-05-02 14:13:20'),
248 ('xiecurgmhbubpi','iecur','ecurgmhb','curgmhbubp','go',4,'urgmhbubpi','rgmhbubpijrllqun','no',0,'2006-12-06 13:31:47','2005-03-03 21:09:39','on',1,60,'2008-06-01 22:34:25'),
249 ('had','xsxwujulpjdzvkpaijursp','know','the','who',17,'of','sxwujulpjdzvkpai','xwujulp',2,NULL,'2005-03-12 21:22:30','w',2,89,'2008-12-21 16:23:58'),
250 ('did','well','zxnbycjzxi','of','they',2,'when','xnbycjz','nbycjzxi',3,NULL,NULL,'can\'t',0,8,NULL),
251 ('jrllquntppirzdphpduhwqhnsmujjjb','they','rllquntpp','out','llquntppirzdph',6,'were','lquntppirzdphpdu','do',2,NULL,NULL,'your',0,6,NULL),
252 ('was','all','look','yeah','jjjbldnkiwsrsxnd',11,'jjb','jbldnkiwsrsxndol','bldnkiwsrs',1,NULL,NULL,'ldnkiwsrsx',1,51,'2001-03-11 13:58:35');
253
254
255 CREATE TABLE g (
256 `col_int` int DEFAULT NULL,
257 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
258 `col_datetime_key` datetime DEFAULT NULL,
259 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
260 `col_int_unique` int DEFAULT NULL,
261 `col_int_key` int DEFAULT NULL,
262 `col_datetime` datetime DEFAULT NULL,
263 `col_datetime_unique` datetime DEFAULT NULL,
264 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
265 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
266 `pk` int NOT NULL,
267 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
268 `col_char_16` char(16) COLLATE latin1_bin NOT NULL,
269 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
270 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
271 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
272 PRIMARY KEY (`col_char_16`,`pk`),
273 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
274 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
275 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
276 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
277 UNIQUE KEY `ix1` (`col_int_unique`),
278 KEY `col_datetime_key` (`col_datetime_key`),
279 KEY `col_int_key` (`col_int_key`),
280 KEY `col_char_16_key` (`col_char_16_key`),
281 KEY `col_varchar_256_key` (`col_varchar_256_key`),
282 KEY `col_varchar_10_key` (`col_varchar_10_key`)
283 ) ENGINE=ndbcluster;
284
285 INSERT INTO g VALUES (0,'what','2008-02-18 23:51:12','qsxmhjwagewclcfy',51,2,'2003-08-08 16:07:39','2007-12-24 22:23:49','back','sxmhjw',8,'xmhjwagewc','as','m','hjwagewclcfykywlcnem','good'),
286 (2,'got',NULL,'rifnhuu',36,1,'2006-03-20 22:09:42','2008-06-17 16:52:03','had','he',15,'ifnhu','all','know','no','fnhuuf'),
287 (3,'I\'m','2003-02-13 10:09:49','p',34,3,NULL,NULL,'would','tell',18,'vasdqkxbwp','it\'s','got','asdqkxbwptigbpnesqigwegcn','sdqkxbw'),
288 (2,'gbpnesqigwegcnfeuvrgnec',NULL,'one',70,2,NULL,NULL,'bpnesqigwe','pnesqig',19,'nesqigwegc','yeah','esqigwegcnfeuvrg','out','sqig'),
289 (3,'clcfykywlcnemiuaabrr','2003-05-17 14:33:21','lcfyky',42,0,'2002-06-09 10:05:32',NULL,'get','cfykywlc',11,'have','know','fykywlcnemiuaa','can','ykywlcnemi'),
290 (1,'who','2001-08-25 18:32:56','be',8,1,'2002-11-27 15:26:31',NULL,'gew','didn\'t',10,'ewclcfykyw','one','then','come','wclcfykywl'),
291 (2,'zzjeiwvd','2003-01-06 04:03:54','zjeiw',71,2,'2001-12-28 03:57:28',NULL,'jeiw','oh',6,'eiwvdmdivj','time','didn\'t','iwvdmdivjqsxmhjwagewclcfykywlcn','well'),
292 (2,'did','2009-01-07 15:27:46','say',5,1,NULL,'2003-12-21 10:46:23','back','rsprnwgrpquarwk',2,'sprnwgrpqu','prnwgrpquarwkazz','rnwgrpquarwkazzj','nwgrpquarwkazzjeiwvdmdi','wgrpquarwk'),
293 (0,'what',NULL,'cnemiuaabrrifnhu',15,3,'2003-04-06 20:26:15',NULL,'nemiuaabrr','there',13,'emiuaabrri','all','do','miuaabrrifnhuufzasunkrcpv','go'),
294 (3,'it',NULL,'pquarwkazzjeiwvd',58,2,'2003-02-05 03:56:03',NULL,'say','quarwkazzjeiwvdmdivjq',4,'uarwkazzje','what','to','arwkazzjeiwvdmdivjqsxmhjw','come'),
295 (0,'divjqsxmhjwagewclc',NULL,'don\'t',72,0,'2007-02-20 02:56:08',NULL,'when','she',7,'ivjqsxmhjw','vjqsxmhjwagewc','jqsxmh','going','yes'),
296 (0,'but','2008-08-04 12:02:29','something',31,3,NULL,'2004-11-25 09:01:20','iuaabrrifn','uaabrrifnhuufzasunkrcpv',14,'her','aabrrifn','abrrifnhuufzasun','brrifnhuufzasunkrc','rrifnhuu'),
297 (3,'jwagewclcfykyw',NULL,'wagewclcfykywlcn',52,3,'2002-02-25 10:04:13','2002-11-10 22:23:01','how','have',9,'yes','then','like','agewclcfykywlcnemi','with'),
298 (2,'you\'re',NULL,'paijursprnwgr',7,1,'2006-12-19 18:02:03','2005-01-28 01:36:00','aijursprnw','ijursprnwgrpquarwkazzj',1,'jursprnwgr','yes','ursprnwgrpqua','at','that'),
299 (1,'nhuufzasunkrcpvasdqkx','2007-04-22 07:02:08','huufzasunkrcpvas',12,2,NULL,NULL,'uufzasun','uf',16,'fzasunkrcp','zasunkrcpvasdqkx','asunkrcpvasdqkxb','sunkrcpvasdqkxb','unkrcpvasd'),
300 (0,'go','2003-06-26 23:33:30','here',0,3,'2005-11-18 04:00:44',NULL,'r','can',5,'were','wkazzjeiwvdmdivj','kazzjeiwvdm','azzjeiwvdmdivjqsxmhjwa','that\'s'),
301 (2,'like','2000-05-20 21:28:25','nkrcpva',27,2,'2006-04-08 02:26:03',NULL,'krcpvasdqk','and',17,'will','were','rcpva','cpvasdqkxbwptigbpnesqigwegc','a'),
302 (2,'back',NULL,'grpquarwkazzjeiw',21,2,'2007-07-03 16:09:05','2000-09-03 23:20:32','look','or',3,'like','my','that','r','no'),
303 (2,'so','2009-08-08 23:58:43','but',92,NULL,NULL,NULL,'kywlcnemiu','ywlcnemiuaabrrifnhuufzasu',12,'I\'ll','wlcnemiuaabrr','ok','yeah','lcn');
304
305 CREATE TABLE h (
306 `col_int_key` int DEFAULT NULL,
307 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
308 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
309 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
310 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
311 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
312 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
313 `col_int_unique` int DEFAULT NULL,
314 `pk` int NOT NULL AUTO_INCREMENT,
315 `col_int` int DEFAULT NULL,
316 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
317 `col_datetime` datetime DEFAULT NULL,
318 `col_datetime_unique` datetime DEFAULT NULL,
319 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
320 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
321 `col_datetime_key` datetime DEFAULT NULL,
322 PRIMARY KEY (`pk`),
323 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
324 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
325 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
326 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
327 UNIQUE KEY `ix1` (`col_int_unique`) USING HASH,
328 KEY `col_int_key` (`col_int_key`),
329 KEY `col_varchar_10_key` (`col_varchar_10_key`),
330 KEY `col_varchar_256_key` (`col_varchar_256_key`),
331 KEY `col_char_16_key` (`col_char_16_key`),
332 KEY `col_datetime_key` (`col_datetime_key`)
333 ) ENGINE=ndbcluster;
334
335 INSERT INTO h VALUES (2,'you\'re','vbitxqjxdz','good','bitxqjxdzdytunqvvrmpyxrencqhu','itxqjxdzdytunqvv','the',73,19,0,'some',NULL,NULL,'can\'t','know',NULL),
336 (1,'tqvbjiklcekxqyox','qvbjiklcek','a','vbjiklcekxqyoxsolbx','he','yeah',80,12,0,'bjiklcekx',NULL,'2004-03-05 23:35:38','jiklcekxqy','iklce',NULL),
337 (3,'jwpukqub','wpukqubzpo','so','pukqub','him','ukqubzpomntrddrw',4,7,3,'kqub',NULL,NULL,'qu','is','2009-05-24 12:06:47'),
338 (0,'euvrgnecpt','uvrgnecpth','vrgnecpthm','rgnecpthmhffqbythjwpukqu','gn','necpthmhffqbythj',17,3,0,'ec',NULL,'2007-07-22 21:19:18','cpthmh','is','2002-09-22 18:17:25'),
339 (2,'omntrddrwhzjtqv','mntrddrwhz','up','now','could','ntrddrwhzjtqvbji',NULL,9,NULL,'trddrwhzjtqvbjik',NULL,'2007-06-14 20:03:45','rddrwhzjtq','ddrwhzjtqvbjiklcekxqyoxsolbxt',NULL),
340 (1,'no','I','your','his','up','drwhzjtqvbj',33,10,1,'yeah','2009-04-03 17:18:11','2007-09-23 00:01:35','you\'re','rwhzjtqv','2001-08-11 01:21:04'),
341 (0,'don\'t','from','qbythjwpuk','something','some','can\'t',61,5,1,'bythjwpukqubzpomntrddrwhz','2007-08-14 00:54:27','2009-09-15 20:30:08','ythjwpukqu','thjwpukqubzpom',NULL),
342 (2,'xdzdytunqvvrmpyx','dzdytunqvv','zdytunqvvr','dytunqvvrmpyxrencq','ytunqvvrmpyxr','then',16,21,1,'tunqvvrmpyxr',NULL,NULL,'unqvvrmpyx','nqvvrmpyxrencqhuyr',NULL),
343 (0,'some','from','wcvumvyvbi','cvumvyvbitxqjxdzdytunqvvrmpyxren','vumvyvbi','umvyvbitxqjxdzdy',10,18,0,'mvy','2008-07-10 21:26:28','2006-07-22 05:54:34','vyvbitxqjx','yvbitxqjx',NULL),
344 (3,'txqjxdzdytunqvvr','you','xqjxdz','say','qjxdzdytunqvvrmp','as',NULL,20,2,'jxdzdytunqvvrmpyxrencqhuyrfluezq',NULL,NULL,'his','or',NULL),
345 (0,'olbxthdcprswpjxi','lbxthdcprs','bxthd','xthdcprswpjxixmvfwmsysebl','thdcprswpjxixmvf','do',1,14,0,'hdcprswpjxixmvf',NULL,NULL,'dcprswpjxi','cprswpjxixmvfwmsyseblwcvumvyv',NULL),
346 (0,'who','you\'re','on','going','w','hzjtqvbjiklce',31,11,2,'one',NULL,'2003-02-07 02:56:19','zjtqvbjikl','jtqvbjiklce',NULL),
347 (2,'prswpjxixmvfwmsy','rswpjxixmv','swpjxixmvf','wpjxi','pjxixmvfwmsyse','can\'t',96,15,0,'jxixmvfw','2005-11-27 10:45:27',NULL,'was','xixmvfwms','2000-09-05 01:12:15'),
348 (2,'hjw','not','been','now','out','what',86,6,0,'for',NULL,'2006-08-22 13:49:39','or','who',NULL),
349 (NULL,'did','say','had','about','me','qigwegcn',83,1,0,'at',NULL,NULL,'igwegcnfeu','gwegcnfeuvrgnecpthm',NULL),
350 (1,'it\'s','or','yeah','klcekxqyoxsolbxthdcprswpjxixm','lcekxqyoxsolbxth','cekxqyoxsolbxthd',64,13,2,'ekxq','2002-12-04 04:19:46',NULL,'kxqyoxsolb','xqyoxsolbxthdcprswpjxixmvfwms','2009-01-08 01:17:32'),
351 (3,'seblwcvumv','ebl','about','a','blwcvumvyvbi','was',23,17,3,'lwcvumvyvbitxqj',NULL,NULL,'didn\'t','you','2006-01-04 14:25:33'),
352 (1,'wmsysebl','msyseblwcv','were','me','syseblwcvumvyvbi','your',44,16,1,'yseblwcvumvyvbitxqjx',NULL,'2000-11-08 21:18:21','me','got',NULL),
353 (0,'wegcnfeuvrgnecpt','what','egcnfe','gcnfeuvrgnecpthmhffqbyt','not','cn',14,2,0,'nfe','2002-12-02 09:55:54',NULL,'feuvrgnecp','just',NULL),
354 (0,'pthmhffqbythjwpu','thm','now','hmh','mhffqbyth','h',6,4,1,'ffqbyth','2003-07-02 02:43:11','2009-02-16 14:58:58','fqbythjwpu','of',NULL),
355 (3,'ubzpomntrdd','me','bzpomntrdd','zpomntrdd','tell','out',75,8,1,'don\'t','2009-08-20 02:03:54','2009-07-07 07:00:21','back','pom',NULL);
356
357
358 CREATE TABLE i (
359 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
360 `col_datetime_key` datetime DEFAULT NULL,
361 `col_datetime` datetime DEFAULT NULL,
362 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
363 `pk` int NOT NULL,
364 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
365 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
366 `col_int_key` int DEFAULT NULL,
367 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
368 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
369 `col_datetime_unique` datetime DEFAULT NULL,
370 `col_int_unique` int DEFAULT NULL,
371 `col_int` int NOT NULL,
372 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
373 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
374 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
375 PRIMARY KEY (`col_int`,`pk`),
376 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
377 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
378 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
379 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
380 KEY `col_datetime_key` (`col_datetime_key`),
381 KEY `col_int_key` (`col_int_key`),
382 KEY `col_varchar_256_key` (`col_varchar_256_key`),
383 KEY `col_varchar_10_key` (`col_varchar_10_key`),
384 KEY `col_char_16_key` (`col_char_16_key`),
385 KEY `ix3` (`col_int`,`col_int_key`,`col_int_unique`)
386 ) ENGINE=ndbcluster;
387
388 INSERT INTO i VALUES ('then','2003-10-20 10:34:07',NULL,'or',12,'wtqrebgj','tqrebgjzbyce',2,'qrebgjzbycekyjgb','rebgjzbyceky',NULL,47,0,'oh','ebgjzbycek','b'),
389 ('qbzsoxvill','2000-11-18 10:20:56',NULL,'bzsoxvillooqx',8,'zsoxvillooqxuvoxcg','that',1,'soxvilloo','with',NULL,16,0,'oxvillooqx','xvillooqxu','villooqxuvoxcg'),
390 ('xrencqhuyr','2008-07-07 16:45:29','2006-05-10 03:29:39','oh',3,'it','not',3,'rencqhuyrfluezqe','of','2001-08-25 07:50:24',5,1,'be','encqhuyrfl','ncqhuyrfluezqekm'),
391 ('what','2004-03-03 02:03:18',NULL,'to',1,'q','tell',2,'ok','vvrmpyxrencqhu','2000-01-19 12:46:53',68,1,'vrmpyxrenc','her','rmp'),
392 ('zqekmqpwut','2004-05-20 15:13:05','2001-08-24 09:26:26','qekmqpwutxnzddrbjycyoyqbzsox',5,'ekmqpwutxnzddrbjycyoyqbzs','k',1,'to','mqpwutxn','2003-08-28 07:41:20',13,0,'qpwutxnzdd','pwutxnzddr','well'),
393 ('yoyqbzsoxv','2006-12-03 12:30:14',NULL,'a',7,'go','oyqbzsoxvillooqx',3,'look','is',NULL,8,0,'the','there','yqbzsoxvillooqxu'),
394 ('now',NULL,NULL,'wutxnzddrbj',6,'know','utxnzddrbjycyoyq',1,'are','hey',NULL,90,2,'his','and','how'),
395 ('ooqxuvox','2001-04-05 16:01:44',NULL,'oqxuvoxcgohdbytybwcqxdw',9,'they','think',3,'could','something','2008-07-09 23:29:55',NULL,2,'something','qxuvoxcgoh','xuvoxcgohdbytybw'),
396 ('or','2009-03-28 17:09:26','2005-04-21 20:59:04','uvoxcgohdbytybwcqxdwtqrebgj',10,'we','voxcgohdbytybwcq',2,'from','oxcgohdbytybwcqxdwtqre','2000-08-06 16:00:04',7,0,'xcgohdbyty','cgohdbytyb','gohdbytybwcqxdwt'),
397 ('that\'s','2009-02-05 03:36:32',NULL,'dodxqqjwasfkvetfobocgpft',14,'at','odxqqjwa',0,'know','as','2002-02-04 09:40:42',4,0,'dxqqjwasfk','got','to'),
398 ('mpyxrencqh','2005-11-19 13:59:10',NULL,'pyxrencqhuyrfluezqekmq',2,'have','his',3,'know','time','2005-03-26 18:40:04',81,1,'yxrencqhu','with','he\'s'),
399 ('cqxdwtqreb','2008-12-20 02:22:17',NULL,'no',11,'qxdwtqrebgjz','they',3,'there','xdwtqrebgjzbycekyjgbpmqadutrq',NULL,NULL,1,'come','come','dwtqrebg'),
400 ('xhrd','2007-09-14 10:21:50',NULL,'I',13,'to','hrdodxqqjwasfkve',NULL,'mean','will',NULL,28,3,'rdodxqqjwa','one','I\'ll'),
401 ('got','2007-01-11 22:10:47','2004-09-06 13:12:32','it',4,'rfluezqekmqpwu','fluezqekmqpwutxn',3,'luezqekmqpwut','uezqekmqpwutxnzddrbjycyoy',NULL,0,0,'my','was','ezqekmqpwutxnzdd');
402
403 CREATE TABLE j (
404 `col_datetime` datetime DEFAULT NULL,
405 `pk` int NOT NULL,
406 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
407 `col_datetime_key` datetime DEFAULT NULL,
408 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
409 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
410 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
411 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
412 `col_int_key` int DEFAULT NULL,
413 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
414 `col_int_unique` int DEFAULT NULL,
415 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
416 `col_datetime_unique` datetime DEFAULT NULL,
417 `col_int` int NOT NULL,
418 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
419 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
420 PRIMARY KEY (`col_int`,`pk`) USING HASH,
421 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
422 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
423 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
424 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
425 UNIQUE KEY `ix3` (`col_int`,`col_int_key`,`col_int_unique`) USING HASH,
426 KEY `col_datetime_key` (`col_datetime_key`),
427 KEY `col_varchar_10_key` (`col_varchar_10_key`),
428 KEY `col_int_key` (`col_int_key`),
429 KEY `col_char_16_key` (`col_char_16_key`),
430 KEY `col_varchar_256_key` (`col_varchar_256_key`)
431 ) ENGINE=ndbcluster;
432
433 INSERT INTO j VALUES (NULL,16,'wblfenfpetwejamgeef',NULL,'me','blfenfpetw','up','get',NULL,'didn\'t',15,'he\'s','2001-01-17 08:26:07',0,'ok','lfenfpetwejamgeefplsksusq'),
434 (NULL,7,'on',NULL,'did','mmszwpoglv','mszwpoglvar','szwp',3,'my',31,'him','2006-02-27 13:50:39',1,'can','zwpoglvarsfiljrzimq'),
435 (NULL,1,'got','2000-02-09 07:02:52','xqqjwasfkv','qqjwasfkve','want','it',3,'qjwasfkvetfobocg',77,'jwasfkvetfobocgp','2006-09-18 04:16:45',0,'wasfkvetfob','look'),
436 ('2001-04-11 12:07:24',5,'gp',NULL,'pftrhvxugm','ftrhvxugmm','I\'m','there',2,'trhvxugmmszwpogl',87,'rhvxugmmszwpoglv','2001-04-06 12:45:11',0,'hvxugmmszwpoglva','for'),
437 (NULL,15,'cpjjvhkkwblfenfpetwejamgeef',NULL,'pjjvhk','jjvhkkwblf','jvhkkwblfenfpetwejamgeef','vhkkwblfen',1,'her',4,'hkkwblfenfpe','2004-11-20 04:14:41',3,'kkwblfenfp','kwblfenfpetwejamgeef'),
438 ('2000-07-20 12:04:13',9,'like',NULL,'rsfiljr','sfiljrzimq','who','what',1,'know',9,'me',NULL,1,'see','something'),
439 (NULL,14,'hcf','2000-05-13 06:50:00','cfrahcpjjv','you\'re','frahcpjjvhkkwbl','rahcpjjvhk',0,'now',56,'ahcpjjvhkkwblf',NULL,3,'hcpjjvhkkwblfenf','yes'),
440 ('2002-04-16 03:31:03',21,'would',NULL,'ekx','kxhn','xhnemklzergshgvtqekglkhirmzl','do',0,'hnemklzerg',NULL,'about',NULL,1,'nemklzergshgvtqe','do'),
441 ('2004-12-14 09:56:19',11,'imqeplev',NULL,'mqeplevl','time','qeplevleqdhepkhcfra','had',0,'want',8,'were',NULL,2,'like','eplevleqdhepkh'),
442 ('2001-04-24 18:42:38',12,'eqdhepkh',NULL,'there','so','as','he\'s',2,'a',35,'qdhepkhcfrahcpjj','2001-06-14 19:13:14',2,'well','I'),
443 (NULL,10,'filjrzimqeplevleqdhepkhcfrahc','2002-05-05 17:30:47','iljrzimqep','you','ljrzimqeplevleq','jrzimqeple',2,'say',43,'rzi',NULL,0,'zimq','you'),
444 ('2008-09-19 06:03:37',6,'vxugmmszwpogl','2002-03-20 03:44:56','xu','ugmm','your','gmmszwpogl',1,'not',27,'yeah','2004-06-07 22:36:15',0,'do','out'),
445 (NULL,8,'wpoglvar',NULL,'poglvarsfi','oglvarsfil','glvarsfiljrzimqeplevleqdh','lvarsfil',1,'varsfi',7,'arsfiljrzimqeple','2005-03-09 05:11:19',2,'what','this'),
446 (NULL,4,'like',NULL,'of','is','bocgpftrhvxugmmszwpoglvarsfilj','look',3,'ocgpftrhvxugmm',65,'come','2004-07-12 02:16:53',0,'of','cgpftrhvxugmmszwpoglvarsf'),
447 ('2000-07-06 03:14:19',20,'what','2000-05-04 23:12:01','sqvazujabv','qvaz','vazujabvkfekxhn','azuja',1,'zuj',44,'how','2002-08-11 13:00:47',2,'ujabvkfekxhnemkl','jabvkfekxhnemklzerg'),
448 (NULL,18,'jamgeefpls',NULL,'time','want','would','and',3,'amgeefplsksusqva',6,'mgeefplsksusqvaz',NULL,1,'geefplsksusqvazu','then'),
449 ('2006-06-09 17:17:31',2,'asfkvetfobocgpftrhvxugm',NULL,'are','this','s','fkve',2,'kvetfobocgp',66,'why','2006-01-10 17:01:57',1,'vetfobocgpftrhvx','him'),
450 ('2008-01-21 01:30:28',19,'my','2003-08-24 14:40:18','some','lsksusqvaz','sksusqv','her',3,'ksusqvazujabvkfe',42,'susqvazuja','2006-04-15 21:41:50',2,'usqvazujabvkfekx','it'),
451 (NULL,17,'oh','2004-03-06 02:00:31','twejamgee','wejamgeefp','ejam','it',0,'could',24,'why','2001-04-18 02:41:03',1,'because','what'),
452 ('2000-04-04 13:42:09',3,'etfobocgpftrhvxugmmszwpogl',NULL,'all','tfobocgpft','at','fobocg',2,'do',63,'had','2009-01-20 11:59:46',2,'is','obocgpftrhvxugmmsz'),
453 (NULL,13,'dhepkhcfrahc',NULL,'time','hepkhcfrah','epkhcfrahcpjjvhkkwblfenfpetw','pkhcfrahcp',1,'no',21,'be',NULL,0,'khcfra','but');
454
455 CREATE TABLE k (
456 `col_int` int DEFAULT NULL,
457 `col_datetime_key` datetime DEFAULT NULL,
458 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
459 `col_datetime_unique` datetime DEFAULT NULL,
460 `col_varchar_256` varchar(256) COLLATE latin1_bin NOT NULL,
461 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
462 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
463 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
464 `col_int_key` int DEFAULT NULL,
465 `col_datetime` datetime DEFAULT NULL,
466 `pk` int NOT NULL,
467 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
468 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
469 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
470 `col_int_unique` int DEFAULT NULL,
471 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
472 PRIMARY KEY (`pk`,`col_varchar_256`),
473 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
474 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
475 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
476 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
477 UNIQUE KEY `ix3` (`col_int`,`col_int_key`,`col_int_unique`),
478 KEY `col_datetime_key` (`col_datetime_key`),
479 KEY `col_char_16_key` (`col_char_16_key`),
480 KEY `col_int_key` (`col_int_key`),
481 KEY `col_varchar_256_key` (`col_varchar_256_key`),
482 KEY `col_varchar_10_key` (`col_varchar_10_key`)
483 ) ENGINE=ndbcluster;
484
485 INSERT INTO k VALUES (1,NULL,'about','2009-04-25 08:51:38','when','at','his','mean',0,'2006-12-16 07:07:19',21,'then','say','tell',47,'cjrxxihtvz'),
486 (2,'2006-02-12 14:52:19','hnp','2004-12-16 06:03:27','there','in','her','like',3,NULL,11,'my','npgthoms','pgt',33,'he\'s'),
487 (0,'2008-05-10 20:43:37','hey','2001-01-12 03:04:26','yeqtfopugfcdfubqoeujfhnpgthomsfu','eqtfopug','qtfopugfcdfubqoeu','tfopugfcdf',0,'2005-05-04 06:55:10',6,'do','say','her',5,'fopugfcdfu'),
488 (0,NULL,'her','2000-09-26 18:50:46','him','ergshgvtqekglkhi','was','rgs',2,'2000-09-10 21:54:02',2,'and','gshgvtqekglkhirmzlqyeqtfopugfcdf','shgvtqe',17,'hgvtqekglk'),
489 (1,NULL,'nkkwoal',NULL,'now','I\'ll','kk','kw',1,NULL,16,'woalodixeuhwkzwf','be','oalodi',15,'alodixeuhw'),
490 (1,NULL,'opugfcdfubqoeujf',NULL,'pugfcdfubqoeujf','yeah','just','ugfcdfubq',1,'2005-11-09 20:12:39',7,'gfcdfubq','fcdfubqoeujfhnpgthomsfusb','cdfubqoeuj',77,'she'),
491 (0,'2006-11-20 14:26:41','qekglkhirmzlqyeq',NULL,'ekglkhirmzlqyeqtfopugfc','kgl','glkhirmzlqyeqt','I\'ll',0,'2005-07-12 06:27:28',4,'lkhirmzlqyeqtfo','have','I\'ll',3,'khir'),
492 (0,NULL,'why',NULL,'jrxxihtvzd','rxxihtvzdfvdanvs','think','xxi',1,NULL,22,'xihtvzdfvdanvsod','up','ihtvzdfvd',21,'did'),
493 (2,'2008-09-24 06:14:13','here','2003-08-02 23:21:00','not','dfubqoeujfhnpgth','some','fubqoeujfh',2,'2004-09-11 09:54:45',8,'yeah','see','that',20,'ubqoeujfhn'),
494 (2,NULL,'dfocdcjrxxihtvzd','2007-03-25 10:50:56','now','can\'t','focdcjrxxihtv','ocdcjrxxih',3,NULL,20,'cd','so','dcjrxxihtv',53,'I'),
495 (0,'2004-12-14 21:01:09','bryqqcbkhankkwoa','2009-11-13 18:04:39','know','ryqqcbkhan','yqqcbkhankkwoalodixeuhwkzwfdbrwm','qqcbkhankk',0,'2000-09-02 12:09:49',15,'would','when','think',60,'qcbkhankkw'),
496 (3,NULL,'rwmpkhdfocdcjrxx',NULL,'wmpkhdfocdcjrxxihtvz','mpkhd','pk','there',3,'2008-10-17 07:41:01',19,'khdf','her','hdfocdcjrx',8,'with'),
497 (3,NULL,'didn\'t','2002-10-20 16:39:22','get','euhwkzwfdbrwmpkh','uhwkzwfdbrwmpkhd','hwkzw',2,NULL,18,'wkzw','your','kzwfdbrwmp',37,'zwfdbrwmp'),
498 (3,NULL,'time','2000-06-21 11:03:19','emkl','mklze','klzergshgvtqekgl','could',1,'2002-02-17 23:12:12',1,'lz','zergs','he\'s',0,'from'),
499 (0,NULL,'htvzdfvdanvsodxu',NULL,'be','tvzdfvdanvs','or','some',3,NULL,23,'got','time','vzdfvdanv',34,'zdfvdanvso'),
500 (2,'2009-03-11 22:42:36','jfhnpgthomsfusbh','2005-04-11 11:09:56','yes','fhnpgthom','mean','we',2,NULL,10,'have','but','come',24,'like'),
501 (0,'2001-10-06 20:08:26','ugmvurbryqqcbkha',NULL,'gmvurbryqqcbkhankkwoalodixeuhw','we','not','mvurbryqqc',3,NULL,14,'vurbryqqcbkhankk','urbryqqcbkhankkwo','rbryqqcbkh',90,'why'),
502 (2,NULL,'a','2006-02-17 09:19:24','it','all','lodixeuhwkzwfdbrwmpkh','odixeuhwkz',0,NULL,17,'dixeuhwkzwfdbrwm','ixeuhwkzwfdbrwmpkhdfocdcjrx','yes',89,'xeuhwkzwfd'),
503 (2,NULL,'could','2001-09-15 12:45:47','at','mean','have','sfusbh',1,NULL,12,'fusbhugmvurbryqq','good','u',16,'well'),
504 (0,NULL,'hirmzlqyeqtfopug',NULL,'irmzlqyeqtfopu','rmzlqyeqtfopug','mzlq','zlqyeqtfop',2,'2005-10-17 05:45:36',5,'lqyeqtfopug','for','qyeqtfopug',31,'see'),
505 (0,NULL,'gvtqekglkhirmzlq',NULL,'yeah','there','vtq','here',1,NULL,3,'so','tqekgl','me',69,'will'),
506 (1,'2000-12-20 05:01:46','bqoeujfhn','2007-07-24 10:40:08','as','why','qoeujfhnpgt','oeujfhnpgt',NULL,'2007-04-13 02:31:19',9,'eujfhnpgthomsfus','ujfhnpgthoms','can',70,'there'),
507 (2,NULL,'sbhugmvurbryqq',NULL,'hey','have','all','didn\'t',0,NULL,13,'yes','then','bhugmvurbr',78,'hugmvurbry');
508
509 CREATE TABLE l (
510 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
511 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
512 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
513 `col_int_unique` int DEFAULT NULL,
514 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
515 `col_int_key` int DEFAULT NULL,
516 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
517 `col_int` int NOT NULL,
518 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
519 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
520 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
521 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
522 `pk` int NOT NULL,
523 `col_datetime_key` datetime DEFAULT NULL,
524 `col_datetime_unique` datetime DEFAULT NULL,
525 `col_datetime` datetime DEFAULT NULL,
526 PRIMARY KEY (`col_int`,`pk`),
527 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
528 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
529 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
530 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
531 KEY `col_varchar_10_key` (`col_varchar_10_key`),
532 KEY `col_int_key` (`col_int_key`),
533 KEY `col_varchar_256_key` (`col_varchar_256_key`),
534 KEY `col_char_16_key` (`col_char_16_key`),
535 KEY `col_datetime_key` (`col_datetime_key`),
536 KEY `ix3` (`col_int`,`col_int_key`,`col_int_unique`)
537 ) ENGINE=ndbcluster;
538
539 INSERT INTO l VALUES ('come','get','sqdkfykpra',1,'qdkfykpraagyrwsw',3,'had',3,'for','that\'s','dkfykpraagy','kfykpraagy',7,NULL,'2001-05-03 23:02:37',NULL),
540 ('hey','odxuroztqc','I\'m',50,'dxuroztqcmuxmpji',3,'xuroztqcmuxmpjisqdk',0,'u','r','oztqcmuxmpj','go',3,NULL,NULL,'2003-04-19 11:03:55'),
541 ('fykpraagyr','ykpraagyrwswotqllacxf','really',58,'just',2,'kpraagyrwswotqllacx',2,'not','go','praagyrwswotqlla','raagyrwswo',8,NULL,NULL,'2002-09-10 00:24:17'),
542 ('me','you\'re','really',64,'ztqcm',0,'think',1,'when','didn\'t','tqcm','I',4,'2009-01-23 19:23:36','2006-04-18 23:09:29','2007-12-26 01:13:46'),
543 ('vryrpktccz','can','could',73,'have',3,'good',3,'r','would','yrpktcczmhdl','rpktcczmhd',20,'2009-03-24 18:00:17',NULL,'2003-02-04 04:58:24'),
544 ('they','dfvdanvsodxuroztqcm','all',19,'then',0,'out',3,'ok','what','that','it\'s',1,NULL,'2000-12-10 14:18:11',NULL),
545 ('mean','nstjejxktdnhiudznoasbvoavry','with',79,'stjejxktdnhiudz',1,'to',2,'tjejxktdnhiu','that','think','jejxkt',16,NULL,'2006-05-14 16:18:55','2007-08-13 15:42:26'),
546 ('how','bvoavryrpktcczmhdlc','going',9,'because',1,'had',1,'voav','oavryrpkt','well','avryrpktcc',19,'2004-11-01 14:00:45',NULL,NULL),
547 ('anvsodxuro','good','nvsodxuroz',NULL,'some',3,'a',1,'I\'ll','vsodx','up','sodxuroztq',2,'2007-12-12 13:02:35',NULL,NULL),
548 ('I\'ll','were','jptzyomlqm',13,'ptzyomlqmecqikpr',3,'really',1,'ok','tzyomlqme','zyomlqm','one',14,NULL,'2008-11-04 22:12:18',NULL),
549 ('qllacxfarg','yeah','but',82,'llacxfargqphiaxj',2,'lacxfargqphiax',3,'acxfargqphiaxjb','see','cxfa','xfargqphia',11,'2008-06-23 23:41:28',NULL,NULL),
550 ('aagyrwswo','and','at',81,'agyrwswotqllacxf',2,'just',3,'gyrwswotqllacxfargqphiaxjbjp','yrwswotqlla','see','rwswotqlla',9,'2002-01-07 03:11:02',NULL,'2009-01-20 15:49:11'),
551 ('fargqphiax','how','how',78,'argqphiaxjbjptzy',2,'go',1,'rgqphiaxjbj','know','did','gqphiaxjbj',12,'2006-05-07 14:15:54',NULL,'2001-06-13 20:47:24'),
552 ('oh','xmpjisqdkfykpraagyrwswotqllacx','back',55,'mpjisqdkfykpraa',1,'a',1,'pjisqdkfykpraagyrwswotql','time','jisqdkfykpraagyr','isqdkfykpr',6,NULL,'2006-07-19 05:39:10','2004-11-17 10:41:38'),
553 ('cq','qikprnstj','ikprnstjej',4,'see',3,'kprnstjejxk',0,'prnstjejxktdnhiudznoasbvoav','how','rnstjejxktdnhiud','but',15,NULL,NULL,'2009-07-16 07:14:03'),
554 ('qcmuxmpjis','who','out',16,'good',2,'of',3,'cmuxmpjis','muxmpjisqdkfy','going','uxmpjisqdk',5,'2003-12-28 08:07:16','2009-08-13 11:02:41','2002-11-28 01:50:37'),
555 ('qp','on','phiaxjbjpt',44,'it',1,'for',1,'hiaxjbjptzyomlqmecqikp','it\'s','can','then',13,NULL,NULL,NULL),
556 ('yeah','znoasbvoavryrpktcczmhdlcserqv','noasbvoavr',NULL,'like',0,'oasbvoavryrpktcczmhdl',2,'and','one','asbvoavryrpktccz','sbvoav',18,NULL,'2003-03-19 10:31:28',NULL),
557 ('right','wswo','swotqllacx',36,'wotqllacxf',2,'all',2,'be','otq','think','tqllacx',10,'2005-08-19 19:29:23','2008-11-20 18:52:24','2008-01-06 15:47:10'),
558 ('then','go','tdnhiudzno',96,'your',0,'for',1,'dnhiudzn','nhiudznoasbvoavr','hiudz','iudznoasbv',17,NULL,'2005-10-15 06:30:22',NULL);
559
560 CREATE TABLE m (
561 `col_int` int DEFAULT NULL,
562 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
563 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
564 `col_int_unique` int DEFAULT NULL,
565 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
566 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
567 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
568 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
569 `col_int_key` int DEFAULT NULL,
570 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
571 `pk` int NOT NULL AUTO_INCREMENT,
572 `col_datetime` datetime DEFAULT NULL,
573 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
574 `col_datetime_unique` datetime DEFAULT NULL,
575 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
576 `col_datetime_key` datetime DEFAULT NULL,
577 PRIMARY KEY (`pk`),
578 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
579 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
580 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
581 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
582 UNIQUE KEY `ix3` (`col_int`,`col_int_key`,`col_int_unique`),
583 KEY `col_varchar_256_key` (`col_varchar_256_key`),
584 KEY `col_char_16_key` (`col_char_16_key`),
585 KEY `col_int_key` (`col_int_key`),
586 KEY `col_varchar_10_key` (`col_varchar_10_key`),
587 KEY `col_datetime_key` (`col_datetime_key`)
588 ) ENGINE=ndbcluster;
589
590 INSERT INTO m VALUES (2,'I','ufce',14,'fce','come','c','I\'ll',0,'at',7,NULL,'come',NULL,'are',NULL),
591 (3,'vakahjtesmgifltnefitzufcefqqm','a',55,'kahjte','ahjtesmgifltnefi','could','from',2,'hjtesmgi',3,NULL,'jtesmgifltnefitzuf','2002-07-27 15:24:53','really','2003-09-26 02:16:56'),
592 (NULL,'whvkgcladdlzomdicuhzmfpxix','yes',88,'hvkgcladdlzomdic','vkgcladdlzomdi','kgcla','I',1,'one',19,'2009-06-19 22:00:23','your',NULL,'back','2004-11-09 11:01:18'),
593 (2,'vsjghsldzxndyqrnlbdgwcjxy','don\'t',5,'something','sjghsldz','jghsldzxndyqrnlb','ghsldzxndy',3,'be',12,NULL,'I\'m',NULL,'no','2003-01-19 19:36:01'),
594 (2,'it','what',68,'fok','okivsitbedsjzuvs','kivs','come',1,'ivsitbedsj',9,'2007-10-05 13:11:15','vsitbedsjzuvsjghsldzxndyq','2005-06-17 17:30:37','sitbedsjzu','2006-06-11 12:37:47'),
595 (1,'got','I',70,'is','about','itbedsjzuvsjghsl','tbedsjzuvs',2,'bedsjzuvsj',10,'2000-02-06 21:05:08','edsjzuvsjghsldzxndyqrn',NULL,'dsjzuvsjgh',NULL),
596 (3,'ifltnefitzufcefqq','fltnefitzufcefqqmfokivsitbed',NULL,'to','me','it','yes',3,'ltnefitzuf',5,NULL,'look','2001-03-09 17:21:43','tnef',NULL),
597 (0,'icuhzmfpxixbqxtodydhjfc','that\'s',74,'cuhzmfpxixbqxtod','uhzmfpxixbqxtody','didn\'t','hzmfpxixbq',1,'had',21,'2005-02-17 19:31:45','zmfpxixbqxtodydhjfcw',NULL,'mfpxixbqxt','2001-03-17 15:19:54'),
598 (2,'hxesmgwhvkgcladdlzomdicuhz','xesmg',51,'esmgwhvkgcladdlz','smgwhvkgcladdlzo','this','mgwhvkgcla',2,'gwhvkgclad',18,NULL,'was',NULL,'oh',NULL),
599 (0,'will','with',NULL,'gcladdlzomdicuhz','claddlzomdicuhzm','will','laddlzomdi',3,'know',20,'2001-09-01 05:11:17','addlzomdicuhzmfpx',NULL,'now',NULL),
600 (2,'time','odydhjfcwozbfxbvtpvluodmcpxdtsvr',66,'dydhjfcwozbfxbvt','could','ydhjf','tell',0,'say',22,NULL,'dhjfcwozbfxbvtpvluodmcpxdt','2007-10-05 00:43:00','he\'s','2008-06-09 15:39:18'),
601 (NULL,'zxndyqrnlbdgwcjxyuoyxkuhxesmgw','xndyqrnlbdgwcj',56,'ndyqrnlb','dyqrnlbdgwcjxyu','yqrnlbdgwcj','but',0,'yeah',14,'2001-12-22 06:07:00','qrnlbdgwcjxyuoyxkuhxesmgwhvkgc',NULL,'rnlbdgw',NULL),
602 (2,'nlbdgw','like',3,'lbdgwcjxyuoyxkuh','bdgwcjxyuoyxkuhx','dgwcjxyuoyxkuhxe','know',2,'right',15,NULL,'I\'ll',NULL,'will',NULL),
603 (1,'fit','oh',0,'will','itzufce','tzufcefqqmfokivs','mean',3,'yeah',6,NULL,'zufcefqqmfokivsitbedsjzuvsj',NULL,'do','2007-06-09 07:37:03'),
604 (0,'not','sjzuvsjghsldzxndyqrn',12,'her','jzuvsjghsldzxndy','but','something',2,'zuvsjghsld',11,NULL,'about',NULL,'uvsjghsldz',NULL),
605 (2,'I','pktcczmhdlcserqvaka',2,'ktcczmhdlcserqva','tccz','cczmhdlcserqvaka','czmhdlcser',3,'zmhdlcserq',1,NULL,'mhdlcserqvakahjtesmgifltnef','2007-04-16 03:16:14','hdlcserqva',NULL),
606 (3,'right','when',94,'didn\'t','back','hjfcw','then',1,'not',23,'2002-02-01 08:13:44','say','2007-12-23 03:44:31','think','2003-11-19 16:48:43'),
607 (0,'was','good',34,'that\'s','uoyxkuhxesm','oyxkuhxesmg','yxk',1,'xkuhxesmgw',17,NULL,'kuhxesmgwhv','2003-07-12 17:56:01','uhxesmgw','2003-10-09 03:05:46'),
608 (0,'don\'t','if',54,'gwcjxyuoyxkuhxes','wcjxyuoyxkuh','cjxyuoyxkuhx','it\'s',1,'jxyuoyxkuh',16,'2006-01-11 10:28:07','xyuoyxkuhxesmgwhvkgcladdl',NULL,'yuoyxkuhxe',NULL),
609 (2,'just','hsldzxndyqrnlbdgwcjxyuo',93,'sldzxndyqrnlbdgw','ldzxndyqrnl','mean','dzxndyqrnl',2,'there',13,NULL,'from','2008-11-07 09:48:10','because','2005-05-26 19:05:03'),
610 (0,'we','dlcserqvakahjtesmgifltnefitzufc',NULL,'good','lcserqvakahjtesm','cserqvakahjtesmg','serqvakahj',2,'erqvakah',2,'2005-10-18 01:52:00','rqvakahjtesmgifltnefitzufce','2005-04-10 22:42:02','qvakahjtes',NULL),
611 (2,'are','t',18,'not','esmgifltnefi','then','smgifltnef',2,'get',4,NULL,'mgifltnefitzufcefqqm',NULL,'gifltnefit',NULL),
612 (0,'why','well',85,'efq','fqqmfo','qqmfokivsitbedsj','qmfokivsit',1,'mfokivsitb',8,NULL,'back','2000-12-15 16:17:19','go','2009-08-13 04:03:40');
613
614 CREATE TABLE n (
615 `col_datetime_unique` datetime DEFAULT NULL,
616 `col_datetime` datetime DEFAULT NULL,
617 `col_char_16` char(16) COLLATE latin1_bin NOT NULL,
618 `col_datetime_key` datetime DEFAULT NULL,
619 `pk` int NOT NULL,
620 `col_int_unique` int DEFAULT NULL,
621 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
622 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
623 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
624 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
625 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
626 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
627 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
628 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
629 `col_int_key` int DEFAULT NULL,
630 `col_int` int DEFAULT NULL,
631 PRIMARY KEY (`col_char_16`,`pk`) USING HASH,
632 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
633 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
634 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
635 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
636 UNIQUE KEY `ix3` (`col_int`,`col_int_key`,`col_int_unique`) USING HASH,
637 KEY `col_datetime_key` (`col_datetime_key`),
638 KEY `col_char_16_key` (`col_char_16_key`),
639 KEY `col_varchar_256_key` (`col_varchar_256_key`),
640 KEY `col_varchar_10_key` (`col_varchar_10_key`),
641 KEY `col_int_key` (`col_int_key`)
642 ) ENGINE=ndbcluster;
643
644 INSERT INTO n VALUES ('2007-03-13 01:18:00','2003-09-01 20:10:59','his',NULL,5,4,'there','can','odmcpxdtsv','d','for','mcpxdtsvrlvdhodxjipyqduobnyhd','cpxdtsvrlv','pxdtsvrlv',2,3),
645 ('2009-04-16 11:03:59','2004-06-08 00:05:54','have','2001-11-20 23:11:02',20,50,'i','when','emdi','mdikmhcaqjd','were','there','dikmhcaqjd','ikmhc',0,1),
646 ('2001-04-24 11:20:52',NULL,'out',NULL,22,24,'lgdxxagtpkbaohozyxxgt','a','were','gdxxagtpkbaohozyx','dxxagtpkbaoh','do','xxagtpkb','all',2,NULL),
647 (NULL,NULL,'vdhodxjipyqduobn',NULL,8,9,'dhodxjipyqduobny','so','hodxjipyqd','odxjipyqduobnyhdvauikwsdbjdm','he','dxjipyqduobnyhdvauikwsdbjdmv','will','got',2,1),
648 ('2004-11-26 20:45:28',NULL,'we','2003-08-20 17:51:57',4,NULL,'pvluodmcpxdtsvrlvdhodxjipyqdu','there','well','vluodmcpxdtsvrlvdho','out','was','luodmcpxdt','uodmcpxdts',2,3),
649 ('2001-04-18 09:51:54','2006-09-10 12:41:46','yqduobnyhdvauikw','2003-10-27 07:05:20',10,11,'as','qduob','and','who','duobn','he','uobnyhdvau','obnyhdvaui',2,1),
650 ('2001-05-20 06:35:19',NULL,'azqihsjlydayqftu',NULL,14,NULL,'zqihsjlydayqf','how','qihsjlyday','ihsjlydayqft','hsjlyday','sj','jl','didn\'t',2,3),
651 ('2000-02-25 22:23:44',NULL,'whqoneroiemdikmh','2009-11-05 17:30:19',18,2,'so','hqoneroiemdikmhc','qoneroiemd','have','oneroiemdikmhcaq','on','neroiemdik','the',3,3),
652 ('2008-07-03 00:23:21','2007-01-20 22:17:15','bfxbvtpv',NULL,2,27,'fxbvtpvluodmcpxdtsvrl','could','one','xbvtpvluodmcpxdts','this','bvtpvluodmcpxdtsvrlvdhodxjip','hey','at',1,2),
653 (NULL,'2000-03-16 12:37:17','uilkphmpanwhqone','2009-02-23 15:36:23',17,66,'ilkphmpan','him','he\'s','lkphmpanwhqoneroiem','kphmpanwhqoner','phmpanwhqoneroi','he','he\'s',3,0),
654 (NULL,NULL,'eroiemdikmhcaqjd','2008-10-14 08:20:03',19,1,'then','roiemdikmhcaqjdl','ok','going','know','oiemdikmhcaqjdlgdxxagtp','the','it',0,0),
655 ('2000-05-11 00:17:52',NULL,'auikwsdbjdmvazqi','2009-01-23 06:08:56',12,44,'him','come','uikwsdbjdm','that','ikwsd','going','there','kwsdbjd',3,NULL),
656 (NULL,'2001-06-16 01:41:25','uuietoejtbuilkph',NULL,15,0,'uietoejtbuilkphmpanwhqon','that\'s','ietoejtbui','etoejtbuilkphmpanwh','okay','toejtbuilkphmpanwhqoneroiem','why','come',3,0),
657 ('2007-04-16 06:21:28','2007-10-17 13:10:51','do','2001-07-27 06:07:09',7,32,'did','can','svr','on','vrlvdhodxjipyqdu','rlvdhodxjipyqduobn','could','lvdhod',0,NULL),
658 (NULL,'2002-05-06 19:54:01','then','2007-08-05 17:12:20',1,65,'jfcwozbfxbvtpvl','fcwozbfxbv','cwozbfxbvt','do','wozbfxbvtpvluodm','ozbfxbvtpvluodmcpxdtsvrlv','back','zbfxbvtpvl',3,1),
659 (NULL,'2003-04-15 05:59:56','bnyhdvauikwsdbjd',NULL,11,46,'nyhdvauikw','yhdvauikwsd','the','going','hdvaui','dvauikwsdbjdmvazqi','look','vauikwsdbj',3,2),
660 (NULL,NULL,'xdtsvr',NULL,6,5,'I\'m','did','that\'s','dtsvrl','good','up','a','tsvr',0,3),
661 (NULL,'2000-07-06 13:53:29','can',NULL,13,67,'jdmv','dmvazqihsjlydayq','mvazqihsjl','in','we','vaz','come','get',2,0),
662 ('2009-01-12 07:28:22','2001-06-15 17:26:51','vtpvluodmcp','2009-01-18 02:16:47',3,3,'right','him','had','like','tpvluodmcpx','ok','well','would',2,1),
663 ('2007-11-09 15:40:00',NULL,'her','2001-03-08 12:49:04',21,NULL,'a','caqjdlgdxxagtpkb','aqjdlgdxxa','so','qjdlgdxxagtpkbao','jdlgdxxagtpkbaoh','would','dlgdxxagtp',2,0),
664 ('2002-10-10 16:57:45','2008-07-13 05:31:14','go','2009-09-06 23:41:54',16,96,'be','this','oejtbuilkp','ejtbu','what','jtbuilkp','tbuilkp','builkphmpa',1,3),
665 (NULL,NULL,'in','2001-01-27 21:08:32',9,48,'xjipyqduobnyhdvauikwsd','is','oh','jipyqduobny','to','just','ipyqduobny','pyq',1,1);
666
667 CREATE TABLE o (
668 `col_int_unique` int DEFAULT NULL,
669 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
670 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
671 `col_int_key` int DEFAULT NULL,
672 `col_datetime_unique` datetime DEFAULT NULL,
673 `col_datetime` datetime DEFAULT NULL,
674 `col_int` int NOT NULL,
675 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
676 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
677 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
678 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
679 `col_datetime_key` datetime DEFAULT NULL,
680 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
681 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
682 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
683 `pk` int NOT NULL,
684 PRIMARY KEY (`col_int`,`pk`),
685 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
686 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
687 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
688 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
689 KEY `col_int_key` (`col_int_key`),
690 KEY `col_varchar_256_key` (`col_varchar_256_key`),
691 KEY `col_varchar_10_key` (`col_varchar_10_key`),
692 KEY `col_char_16_key` (`col_char_16_key`),
693 KEY `col_datetime_key` (`col_datetime_key`),
694 KEY `ix3` (`col_int`,`col_int_key`,`col_int_unique`)
695 ) ENGINE=ndbcluster;
696
697 INSERT INTO o VALUES (6,'ckh','khsczypxpbbl',2,NULL,'2002-08-21 17:38:23',2,'hsc','because','how','sczypxp','2007-10-05 10:23:52','czypxpbblogsxtwkvtbqscgcbnjzle','zypxp','who',24),
698 (63,'could','ra',3,'2009-09-13 00:46:54',NULL,2,'avwfckhsczypxp','no','about','vwfckhsczyp',NULL,'wfckhsczypxpbblogsxtwkvtb','got','fckhsczypx',23),
699 (NULL,'he','didn\'t',1,NULL,'2002-03-08 10:15:21',3,'cwehcwvfusmtftlevhiavzbkf','on','wehcwvfusm','him','2008-09-01 04:13:00','ehcwvfu','hcwvfusmtftlevhia','something',7),
700 (20,'gtaqlmew','taqlme',3,NULL,'2008-04-04 08:43:47',3,'aqlmewibfkxcjaxcwehcw','will','as','qlm','2002-02-02 20:50:14','lmewibfkxcjaxcwehc','did','mewibfkxcj',3),
701 (38,'go','kfuoy',1,'2005-11-17 06:36:16','2000-12-17 13:09:13',3,'I\'ll','fuoypznf','uoypznfihe','be',NULL,'think','oypznfiherobmchxfakeimrancl','ypznfihero',11),
702 (69,'fusmtftlevhi','no',0,NULL,'2001-07-19 20:00:00',0,'you\'re','you\'re','tell','like','2006-06-22 12:39:25','are','usmtftlevhiavzbkfuoypz','what',9),
703 (62,'no','to',2,NULL,NULL,2,'erobmchxfakeimrancl','robmchxfak','and','obmchx',NULL,'bmchxfakeimrancl','about','want',13),
704 (72,'if','yxxgtaqlmewibfkx',0,NULL,NULL,1,'yeah','just','xxgtaqlmew','did',NULL,'xgtaqlmewibfkxcjaxcw','that\'s','who',2),
705 (17,'mchxfakeimranclp','chxfakeimranclpt',2,NULL,NULL,3,'so','hxfakei','will','xfakeimr','2005-02-02 21:27:39','will','fakeimranclptwxgaispoifyx','akeimrancl',14),
706 (84,'have','what',1,NULL,NULL,0,'hozyxxgt','would','ozyxxgtaql','ok',NULL,'zyxxgtaqlmew','because','there',1),
707 (86,'here','xo',0,NULL,'2004-10-26 08:15:44',1,'have','osozwaevsl','didn\'t','sozwaevslluevgxt',NULL,'for','oz','know',18),
708 (36,'some','fkxcjaxcwehcwvfu',1,NULL,NULL,1,'time','kxcj','how','why','2000-03-27 10:27:09','xcjaxcweh','was','cjaxcwehcw',5),
709 (50,'now','clptwxgaispoifyx',2,NULL,NULL,3,'l','ptwxgaispo','ok','twxgaispoifyxos',NULL,'because','I\'m','she',15),
710 (74,'zwaevslluevgxtyt','yes',2,'2005-09-22 07:40:43','2006-09-26 03:55:32',3,'look','waevslluev','that\'s','really','2006-08-15 02:38:34','aevsllu','evslluevgxtytgzicaravwfckhsczypx','vslluevgxt',19),
711 (4,'as','pznfiherobmchxfa',3,'2008-02-15 15:30:58','2002-05-22 20:05:52',3,'znfiherobmc','with','nfiherobmc','fiherobmchxfake','2003-02-02 05:07:16','i','herobmchxfakeimranclptwxgaisp','just',12),
712 (0,'are','cwvfusmtftlevhia',1,NULL,'2003-06-23 18:46:24',0,'say','now','go','me','2008-02-15 11:13:49','wvfu','no','vfusm',8),
713 (3,'smtftlevhiavzbkf','were',1,'2004-10-04 04:16:42','2001-01-27 17:15:13',1,'mtftle','tftlevhi','he','ftlevhiavzbkfuoy',NULL,'about','something','of',10),
714 (22,'s','yeah',2,NULL,'2003-04-13 18:51:03',1,'mean','lluevgxtyt','up','luevgxtytgzicara','2005-02-16 00:33:26','uevgx','yes','that\'s',20),
715 (88,'really','him',0,'2008-12-05 15:37:25','2008-10-12 22:05:40',3,'been','okay','were','will','2005-06-28 11:06:57','spoifyxosozwa','and','are',17),
716 (32,'he\'s','then',1,'2007-11-27 19:00:41',NULL,3,'tytgzicaravwfckhsczypxpbblogsxtw','I','yt','to',NULL,'tgzi','gzicaravwfckhsczyp','didn\'t',21),
717 (70,'jaxcwehcwvfusmtf','axcwehcwvfusmtft',0,NULL,'2006-03-26 11:33:41',0,'at','can\'t','what','didn\'t','2008-06-17 18:36:42','why','some','xcwehcwvfu',6),
718 (2,'yes','ewibfkxcjaxcwehc',1,NULL,NULL,3,'wibfkxcjaxcwehcwvfusmtft','ibfkx','do','bfkxcjaxcwehcwvf',NULL,'the','from','okay',4),
719 (27,'zic','icaravwfckhsczyp',2,'2008-02-17 21:24:29','2005-06-04 07:02:51',3,'go','all','caravwfckh','it','2005-02-17 21:36:20','one','up','aravwfckhs',22),
720 (10,'wxga','or',0,'2004-09-18 09:08:33','2008-09-16 04:32:34',0,'xgaispoifyxosozwaevslluevgxt','gaispoifyx','my','aispo',NULL,'know','been','ispoifyxos',16);
721
722 CREATE TABLE p (
723 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
724 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
725 `col_int_unique` int DEFAULT NULL,
726 `pk` int NOT NULL AUTO_INCREMENT,
727 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
728 `col_int` int DEFAULT NULL,
729 `col_datetime` datetime DEFAULT NULL,
730 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
731 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
732 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
733 `col_datetime_unique` datetime DEFAULT NULL,
734 `col_int_key` int DEFAULT NULL,
735 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
736 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
737 `col_datetime_key` datetime DEFAULT NULL,
738 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
739 PRIMARY KEY (`pk`),
740 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
741 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
742 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
743 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
744 UNIQUE KEY `ix1` (`col_int`,`col_int_unique`) USING HASH,
745 UNIQUE KEY `ix2` (`col_int_key`,`col_int_unique`) USING HASH,
746 KEY `col_char_16_key` (`col_char_16_key`),
747 KEY `col_varchar_256_key` (`col_varchar_256_key`),
748 KEY `col_int_key` (`col_int_key`),
749 KEY `col_datetime_key` (`col_datetime_key`),
750 KEY `col_varchar_10_key` (`col_varchar_10_key`)
751 ) ENGINE=ndbcluster;
752
753 INSERT INTO p VALUES ('you','this',54,19,'had',3,'2003-07-05 08:15:56','get','it','no','2001-08-26 20:34:52',NULL,'dnnac','no',NULL,'there'),
754 ('wbhxogpkk','from',6,12,'bhxogpkkvjhxzkjxgrcyqi',1,NULL,'hxogpkkvjhxzkjxgrcyqilgwelf','I\'ll','xogpk',NULL,0,'ogpkkvj','how',NULL,'gpkkvjhxzk'),
755 ('going','going',80,7,'ywwmshhimsbqljcfstzgruojzffwbhxo',2,'2009-12-18 13:36:00','wwmshhimsbqljcf','in','wmshhimsbq','2004-06-19 18:18:52',0,'mshhimsbqljcfstzgruojzffwbhxogp','her',NULL,'back'),
756 ('don\'t','this',17,3,'vtb',1,'2007-10-27 05:43:49','don\'t','tbqscgcbnjzlelnh','bqscgcbnjz',NULL,2,'could','qscgcbnjzlelnhsm','2000-11-08 15:50:29','scgcbnjzl'),
757 ('get','bqljcfstzgruojzf',50,9,'we',0,NULL,'she','as','got','2001-09-01 22:18:35',2,'qljcfstzgruojzffwbhxogpkk','ljcfstzgruojzffw',NULL,'me'),
758 ('didn\'t','jcfstzgruojzffwb',14,10,'say',3,'2006-01-28 09:37:20','cfstzgruojzf','fstzgruojzffwbhx','stzgruojzf',NULL,1,'a','there','2005-03-22 04:53:40','well'),
759 ('well','bnjzlelnhsmuyemy',61,5,'njzlel',0,NULL,'hey','jzlelnhsmuyemyww','zlelnhsmuy',NULL,0,'so','on','2009-02-15 12:23:45','lelnhsmuye'),
760 ('kold','oldgyusxngucicqc',20,21,'ldgyusxngucicqcjhvtmfnumoxifz',3,NULL,'dgyusxngucicqcjhvtmfnumoxifzchbf','at','here','2002-04-06 21:45:48',3,'gyusxngucicqcjhvtmfnumoxifzchbfu','yusxngucicqcjhvt',NULL,'usxngucicq'),
761 ('smkchar','going',8,18,'really',NULL,'2009-09-15 00:49:13','but','she','would','2005-06-11 02:03:00',1,'mkcharcpqd','kcharcpqdnnacfop','2009-09-14 17:02:02','me'),
762 ('can\'t','how',38,20,'rgldtmxfpvzkoldgyusxnguci',0,'2000-07-08 01:25:10','out','on','when','2009-03-01 23:40:09',2,'see','gldtmxfpvzkoldgy','2007-04-27 11:30:07','ldtmxfpvzk'),
763 ('cyqilgwelf','yqilgwelfobfdrbu',11,14,'here',2,NULL,'is','qilgwelfobfdrbue','ilgwelfobf',NULL,0,'had','lgwelfobfdrbuehn',NULL,'gwe'),
764 ('were','tzgruojzf',84,11,'zgru',2,NULL,'gruojzffwbhx','say','ruo',NULL,3,'can','uojzff','2009-12-03 22:09:02','ojzffwbhxo'),
765 ('we','welfobfdrbuehnsm',71,15,'if',1,NULL,'elfobfdrbuehnsmjqnsjesmkcharc','hey','lfobfdrbue',NULL,2,'me','fobfdrbuehnsmjqn',NULL,'obfdrbuehn'),
766 ('your','smuy',10,6,'one',2,NULL,'muyemywwm','uyemywwmsh','yemywwmshh','2009-12-15 16:09:54',3,'emywwmshhimsbq','right',NULL,'mywwmshhim'),
767 ('logsxtwk','time',13,1,'ogsxt',2,'2003-02-24 15:48:34','time','would','I\'m','2008-05-12 08:39:11',2,'gsxtwkvtbqscgcbnjz','sxtwkvtb',NULL,'had'),
768 ('pkk','kkvjhxzkjxgrcyqi',87,13,'kvjh',2,'2008-09-05 03:07:10','vjhxzkjxgrcy','jhxzkjxgrcyqilgw','hxzkjxgrcy',NULL,2,'xzkjxgrcyqi','zkjxgrcyqilgwelf','2003-06-23 10:17:17','kjxgrcyqil'),
769 ('smjqnsjesm','didn\'t',18,17,'just',0,NULL,'on','mjqnsjesmkcharcp','as',NULL,NULL,'jqnsjesmkcharcpqdnnacfoprgldt','qnsjesmkcharcpqd',NULL,'nsjesmkch'),
770 ('rbuehnsmjq','to',7,16,'buehnsmjqnsjesmkcharcpqdnnacfop',2,NULL,'uehnsmjqnsjes','ehnsmjqnsjesmkch','hnsmjqnsje',NULL,3,'you\'re','just','2007-08-01 14:33:10','nsmjqnsjes'),
771 ('xtwk','twkvtbqscgcbnjz',2,2,'really',0,NULL,'her','all','wkvtbqscgc',NULL,3,'we','she',NULL,'kvtbqscgcb'),
772 ('it','cgcbnj',99,4,'ok',1,NULL,'are','not','gcbnjzleln',NULL,3,'you','his','2007-04-07 17:32:03','cbnjzlelnh'),
773 ('yes','get',57,8,'imsbqljcfstzgruojzffwbhxogpkk',2,NULL,'I\'ll','it\'s','msbqljcfst',NULL,0,'did','sbqljcfstzgruojz','2006-07-23 16:35:56','to');
774
775 CREATE TABLE q (
776 `col_int_unique` int DEFAULT NULL,
777 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
778 `col_datetime_key` datetime DEFAULT NULL,
779 `col_int` int DEFAULT NULL,
780 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
781 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
782 `col_datetime` datetime DEFAULT NULL,
783 `col_datetime_unique` datetime DEFAULT NULL,
784 `col_int_key` int DEFAULT NULL,
785 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
786 `pk` int NOT NULL AUTO_INCREMENT,
787 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
788 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
789 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
790 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
791 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
792 PRIMARY KEY (`pk`),
793 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
794 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
795 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
796 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
797 UNIQUE KEY `ix1` (`col_int`,`col_int_unique`),
798 UNIQUE KEY `ix2` (`col_int_key`,`col_int_unique`),
799 KEY `col_datetime_key` (`col_datetime_key`),
800 KEY `col_varchar_256_key` (`col_varchar_256_key`),
801 KEY `col_int_key` (`col_int_key`),
802 KEY `col_char_16_key` (`col_char_16_key`),
803 KEY `col_varchar_10_key` (`col_varchar_10_key`)
804 ) ENGINE=ndbcluster;
805
806 INSERT INTO q VALUES (0,'fuaiiyufnngmlsudti',NULL,3,'for','so','2002-11-02 07:01:00',NULL,2,'uaiiyufnng',7,'come','have','it\'s','something','aiiyufnn'),
807 (41,'icqcjhvtmfnumoxifzchbfuaiiy',NULL,0,'see','he\'s',NULL,'2004-04-03 09:17:02',1,'cqcjhvt',3,'qcjhvtmfnum','my','cjhvtmfnumoxifzc','jhvtmfnumo','not'),
808 (33,'him','2001-02-26 03:06:18',0,'uegjyzyykqjnzabvesmothzhafnndu','egjyzyykqjnzabvesmo',NULL,NULL,1,'gjyzyykqjn',19,'he','are','that\'s','jyzyykqjnz','yzyykqjnzabvesmo'),
809 (19,'hey',NULL,1,'is','really','2009-09-05 01:47:35',NULL,3,'bn',12,'ndgzuawtnjnpizfj','d','right','gzuawtnjnp','I\'m'),
810 (11,'would',NULL,2,'about','come','2006-02-02 08:09:39',NULL,2,'s',9,'mean','okay','udtiazkktlpufbnd','on','see'),
811 (22,'or',NULL,0,'dtiazkktlpufbndgzu','in',NULL,NULL,0,'is',10,'if','do','you\'re','my','tia'),
812 (69,'f','2009-02-03 18:31:29',NULL,'some','my','2001-04-16 16:44:39','2002-06-23 16:15:16',2,'numoxifzch',5,'him','u','moxifzchbfuaiiyu','oxifzchbfu','xifzchbfuaiiyufn'),
813 (24,'qjnzabvesmothzh','2009-03-05 22:24:54',2,'did','jnzabvesmothzhafnnd','2005-04-09 09:47:51','2004-01-25 14:23:21',0,'were',21,'nzabvesmothzhafn','zabvesmoth','think','if','a'),
814 (12,'whj',NULL,0,'her','hjd','2001-01-07 02:14:44',NULL,2,'j',18,'duu','had','one','uuegjyzyyk','get'),
815 (45,'we',NULL,2,'zyykq','yykqjnzabvesmothzhafnnduhv','2007-11-15 21:15:35','2000-02-06 01:47:01',3,'me',20,'can','ykqjnzabve','well','the','kqjn'),
816 (6,'didn\'t',NULL,1,'bvesmo','vesmothz',NULL,'2006-03-10 05:23:59',3,'out',22,'get','oh','he\'s','esmothzhaf','smothzhafnnduhvu'),
817 (5,'now',NULL,0,'it','say','2003-02-23 05:42:51',NULL,0,'hey',14,'him','here','going','she','think'),
818 (9,'wtnjnpizfjtvnxtispzc',NULL,3,'tnjnpizfjtvnxt','njnpizfjtvnxtispzckpwhjduuegj','2009-02-12 19:47:52',NULL,2,'ok',15,'just','jnpizfj','just','npizfjtvnx','pizfjtvn'),
819 (36,'ifzchbfuaiiyufnngm',NULL,2,'fzchb','oh','2000-07-21 00:18:45','2004-10-22 19:39:52',NULL,'zchbfuaiiy',6,'chbfuaiiyufnngml','look','of','hbfuaiiyuf','bfuaiiyufnngmlsu'),
820 (NULL,'I',NULL,0,'because','pufbndgzuawtnj','2006-12-20 06:53:25','2005-09-08 07:20:52',1,'ufb',11,'that\'s','because','fbndgzuawtnjnpiz','her','they'),
821 (50,'that','2002-06-18 08:09:09',1,'sxngucicqcjhvtmfnumoxifzchb','back','2005-07-13 18:05:44',NULL,3,'do',1,'could','xngucic','good','ngucicqcjh','gucicqcjhvtmfnum'),
822 (30,'back','2006-11-06 19:53:10',2,'look','the','2004-11-20 06:21:59',NULL,2,'mothzhafnn',23,'othzhafnnduhvuct','thzhafnndu','hzhafnnduhvuctf','he\'s','what'),
823 (10,'ckpwhjduuegjyzyykqjnzab','2001-03-10 03:50:08',0,'kpwhj','say',NULL,'2001-12-12 15:44:55',3,'pwhjduue',17,'could','with','her','just','for'),
824 (63,'then',NULL,3,'the','of',NULL,NULL,3,'zuawtnjnpi',13,'uawtnjnpizfj','how','look','it','awtnjnpi'),
825 (57,'one',NULL,3,'tfgfcwjacjpettbswzho','some',NULL,NULL,0,'tell',25,'fgfcwj','gfcwjacjpe','fcwjacjpettbswzh','if','cwjacjpett'),
826 (8,'see','2007-11-21 19:51:29',1,'like','be',NULL,'2005-10-18 00:12:57',3,'going',16,'been','izfjtvnxti','know','I','zfjtvnxtispzckp'),
827 (2,'nduhvuctfgfcwjacjpett',NULL,1,'duhvuctfgfcwjacjpettbs','uhvuctfgfcwjacjpettbswzh',NULL,NULL,0,'hvuctfgfcw',24,'vuctfgfcwja','look','uctfgfcwjacj','can','ctfgfcwjacjpettb'),
828 (3,'ucicqcjhvtm',NULL,1,'now','back',NULL,'2000-02-18 06:36:07',1,'but',2,'okay','who','then','cicqcjhvtm','as'),
829 (4,'hvtm','2009-06-17 08:46:07',0,'vtmfnumoxi','if',NULL,'2008-05-27 07:43:38',1,'tmfnumoxif',4,'they','were','my','mfnumoxifz','some'),
830 (67,'there','2007-08-28 19:48:34',1,'have','ngmlsudtiazkktlpuf',NULL,'2007-01-11 06:21:50',0,'gmlsudtiaz',8,'will','mlsudtiazk','lsudtiazkk','all','really');
831
832 CREATE TABLE r (
833 `col_int_key` int DEFAULT NULL,
834 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
835 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
836 `col_datetime_unique` datetime DEFAULT NULL,
837 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
838 `col_int` int NOT NULL,
839 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
840 `col_int_unique` int DEFAULT NULL,
841 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
842 `col_datetime_key` datetime DEFAULT NULL,
843 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
844 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
845 `pk` int NOT NULL,
846 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
847 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
848 `col_datetime` datetime DEFAULT NULL,
849 PRIMARY KEY (`col_int`,`pk`),
850 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
851 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
852 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
853 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
854 KEY `col_int_key` (`col_int_key`),
855 KEY `col_char_16_key` (`col_char_16_key`),
856 KEY `col_varchar_256_key` (`col_varchar_256_key`),
857 KEY `col_datetime_key` (`col_datetime_key`),
858 KEY `col_varchar_10_key` (`col_varchar_10_key`),
859 KEY `ix1` (`col_int`,`col_int_unique`),
860 KEY `ix2` (`col_int_key`,`col_int_unique`)
861 ) ENGINE=ndbcluster;
862
863 INSERT INTO r VALUES (3,'got','her','2009-05-22 23:19:01','wzhozhnrshnjxesj',0,'know',93,'zh','2005-08-21 13:53:39','hozhnrshnjxesjspsjsviykvijznlsye','ozhnrshnjx',3,'zhnrshnjxesjspsj','hnrshnjxesjspsjsviykvijz',NULL),
864 (2,'from','nxkfxmpoln',NULL,'xkfxmpolnznauhaq',3,'did',10,'kfxmpolnznauha',NULL,'mean','fxmpolnz',11,'xmpolnznauhaqurg','mpo','2008-07-12 13:13:34'),
865 (NULL,'jnspiweumfgpewta','you','2008-05-21 09:54:27','I',2,'think',94,'are',NULL,'nspiweumfgpewtalxwkfurakqzrksf','spiweumfgp',23,'piweumfgpewtalxw','iweum',NULL),
866 (1,'so','want',NULL,'now',1,'nrshnjxesj',37,'have','2001-02-02 07:55:35','she','know',4,'on','rshnjxesjspsjsviykvi','2003-08-03 14:10:00'),
867 (3,'mzordgajjhzdmfbx','zordgajjhz','2009-11-19 01:56:39','I\'m',2,'ordgajjhzd',75,'going','2001-09-16 11:19:35','rdgajj','dgajjhzdmf',16,'gajjhzdmfbxinumv','look','2005-07-04 11:24:02'),
868 (3,'iysxkaiedhsopbio','ysxkaiedhs',NULL,'sxkaiedhsopbiodo',1,'up',35,'how','2001-07-25 01:54:55','all','something',19,'xkaiedhsopbiodou','why','2008-07-27 01:37:15'),
869 (2,'would','can\'t',NULL,'know',0,'tell',13,'inxkfxmpolnznauhaq','2004-12-22 12:36:23','had','do',10,'ok','well',NULL),
870 (2,'xfeaarj','feaarjpqkl','2003-09-07 19:50:54','for',3,'yes',16,'eaarjpqklbmzordgajjhzdmfbx','2009-01-28 23:19:22','aarjpqklbmzordgajjhzdmf','arjpqklbmz',14,'want','no',NULL),
871 (2,'my','sjspsjsviy','2003-05-18 18:51:59','jspsjsviykvijz',1,'spsjsviykv',43,'psjsviykvijznlsyedd',NULL,'yeah','for',6,'sjsv','why',NULL),
872 (1,'dpfvtb','pfvtbixinx',NULL,'fvtbixi',1,'vtbix',5,'tbixinxkfxmpolnznauhaqurgyexi','2000-11-10 01:39:39','bixinx','ixinxkfxmp',9,'we','xinxkfxmpolnznauhaqurgyex','2002-02-20 20:14:46'),
873 (1,'jpettbswzhozhnrs','now',NULL,'now',0,'pettbswzho',8,'I\'ll','2003-07-16 03:50:10','really','ettbswzhoz',1,'you\'re','tt',NULL),
874 (0,'well','iodouwtskx',NULL,'hey',0,'his',4,'odouwtskxolqddojnspiwe',NULL,'douwtskxolqddojn','ouwtskxolq',21,'uwtskxolqddojnsp','wtskxolq',NULL),
875 (0,'I\'m','I\'ll','2008-08-16 02:38:06','weumfgpewtalxwkf',1,'eumfgpewta',63,'right',NULL,'were','when',24,'umfgpewtalxwkfur','mfgpewtal',NULL),
876 (0,'kaiedhsopbio','aiedhsopbi','2003-05-06 12:59:10','iedhsopbiodouwt',1,'edhsopbiod',NULL,'for',NULL,'it','mean',20,'this','dhsopbiodouwtskxolqddojnspiweumf',NULL),
877 (2,'xinumvhiysxkaied','inumvhiysx','2008-03-17 07:44:42','but',0,'numvhiysxk',1,'umvhiysxkai','2009-09-25 13:13:04','mvhiysxkaiedhsopbiodo','vhiysxkaie',18,'hiysxkaiedhsopbi','going',NULL),
878 (2,'some','something','2004-05-16 15:20:12','know',0,'tbswzhozhn',NULL,'just',NULL,'out','no',2,'bsw','swzhozhnrshnjxesjspsj',NULL),
879 (1,'how','would','2001-01-06 23:15:28','with',0,'up',59,'the',NULL,'tksodpfvtb','ksodp',8,'sodpfvtbixinx','odpfvtbixinxkfxmpolnznauhaqurgy',NULL),
880 (0,'fgpewtalxwkfurak','some',NULL,'look',3,'why',9,'ok',NULL,'been','is',25,'gpewtalxwkfurakq','as',NULL),
881 (1,'rjpqkl','jpqklbmzor',NULL,'pqklbmzordgajjhz',0,'qk',41,'klbmzordgajjhzdmfbxinumvhiysxkai',NULL,'don\'t','lbmzordgaj',15,'me','bmzordgajjhzdmfbxinumv',NULL),
882 (1,'ajjhzdmfbxinumvh','jjhzdmfbxi','2002-05-02 13:32:09','jhzdmfbxinumvhiy',3,'hzdmfbxinu',NULL,'zdmfbxin',NULL,'dmfbxi','mf',17,'fbxinumvhiysxkai','bxinumvhiysxkaiedhsop',NULL),
883 (2,'is','ok','2008-10-17 00:21:28','shnjxesjspsjsv',0,'hnjxesjsps',81,'in',NULL,'njxesjspsjsviykvijznlsyeddftkso','jxesjspsj',5,'xesjspsjsviykvij','esjspsjsviykvijznlsyeddf',NULL),
884 (1,'p','it\'s',NULL,'okay',0,'all',72,'olnznauhaqurgyexihx',NULL,'lnznauhaqurg','nznauhaqur',12,'look','zn',NULL),
885 (0,'kvijznlsyeddftks','vijznls',NULL,'right',0,'when',2,'about','2006-05-06 07:54:22','ijznlsyeddf','did',7,'jznlsyeddftksodp','would',NULL),
886 (2,'tskxolqddojnspiw','skxolqddoj',NULL,'kxolqddojnspiweu',0,'who',19,'xolqddojn',NULL,'olqd','lqddojnsp',22,'qddojnspiweumfgp','back',NULL),
887 (2,'want','y',NULL,'exihxfeaarjpqklb',3,'xihxfeaarj',12,'you',NULL,'here','with',13,'ihxfeaarjpqklbmz','hxfeaarjpqklb','2000-08-20 17:28:48');
888
889 CREATE TABLE s (
890 `col_int_key` int DEFAULT NULL,
891 `pk` int NOT NULL AUTO_INCREMENT,
892 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
893 `col_datetime` datetime DEFAULT NULL,
894 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
895 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
896 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
897 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
898 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
899 `col_int` int DEFAULT NULL,
900 `col_datetime_key` datetime DEFAULT NULL,
901 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
902 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
903 `col_int_unique` int DEFAULT NULL,
904 `col_datetime_unique` datetime DEFAULT NULL,
905 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
906 PRIMARY KEY (`pk`),
907 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
908 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
909 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
910 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
911 UNIQUE KEY `ix1` (`col_int`,`col_int_unique`),
912 UNIQUE KEY `ix2` (`col_int_key`,`col_int_unique`),
913 KEY `col_int_key` (`col_int_key`),
914 KEY `col_char_16_key` (`col_char_16_key`),
915 KEY `col_varchar_10_key` (`col_varchar_10_key`),
916 KEY `col_datetime_key` (`col_datetime_key`),
917 KEY `col_varchar_256_key` (`col_varchar_256_key`)
918 ) ENGINE=ndbcluster;
919
920 INSERT INTO s VALUES (3,7,'gffennzvqftxqwqb','2002-03-17 05:29:29','ffennzvqftxqwqbtrydwypawey','fennzvqft','did','want','ennzvqf',0,NULL,'this','me',50,NULL,'will'),
921 (2,3,'kqzrksfzju','2004-10-27 12:28:42','hey','no','mean','qzrks','get',NULL,'2009-05-07 08:59:45','zrks','rksfzjudicvgffennzvqft',4,NULL,'see'),
922 (1,19,'hwndqxyljmtxhhla',NULL,'and','wndqxyljmtxhhlai','is','it','ndqxylj',2,'2006-02-03 02:47:25','will','with',5,'2009-07-03 09:14:28','dqxyljmtxh'),
923 (2,12,'ypaweyyyadktqffy','2006-02-10 11:15:12','paweyyyadktqffyzmxkjbc','aweyyyadktqff','all','the','weyy',0,NULL,'the','eyyyadkt',2,NULL,'some'),
924 (1,9,'to',NULL,'been','go','something','zvqftxqwqb','didn\'t',3,NULL,'vqf','qftxqwqbtrydwypaweyyyad',85,'2007-06-08 04:35:26','ftxqw'),
925 (1,10,'txqwqbtrydwypawe',NULL,'with','xqwqbtrydwypawey','qwqbtrydwy','wqbtrydwyp','qbtrydwypaweyyya',1,'2003-08-28 06:27:26','btrydwypaweyyyadktqf','on',49,'2006-04-03 12:31:21','trydwypawe'),
926 (0,5,'it\'s','2004-03-22 06:22:21','like','one','udicvgffen','he','like',3,'2009-02-04 12:17:07','dicvgffennzvqftxq','tell',88,'2003-02-01 11:00:07','icvgffennz'),
927 (1,21,'I\'m','2005-04-14 05:02:15','not','inrqsfdnuupildsy','time','nrqsfdnuup','what',0,'2005-02-16 11:03:41','just','that\'s',0,NULL,'up'),
928 (0,18,'been','2000-10-27 04:34:00','the','the','have','umghtygkfh','do',2,NULL,'he\'s','mghty',27,'2000-06-07 22:17:43','ghty'),
929 (2,20,'qxyljmtxhhlaiupx',NULL,'xylj','but','back','yljmtx','here',1,NULL,'ljm','for',11,NULL,'want'),
930 (2,22,'uupildsybrxdwtei',NULL,'oh','upildsybrxdwteie','pil','not','ildsybrxdwteiewu',3,NULL,'ldsybrxdwteiewuqafkllnetz','dsybrxdwteie',22,'2008-02-05 17:50:50','sybrxdwt'),
931 (1,14,'I',NULL,'then','tqffyzmxkjb','say','okay','he\'s',0,NULL,'you\'re','go',48,'2000-02-02 19:29:17','ok'),
932 (3,15,'zmxkjbcsdmtshxrm','2001-10-17 04:13:14','mxkjbcsdmtshxrmpynumghtygkfhwndq','here','xkjbcsdmts','kjbcsdmtsh','there',2,NULL,'jbcsdmtshxrmpynumghtygkfhwnd','bcsdmts',53,'2003-04-16 07:24:17','csdmtshxrm'),
933 (3,6,'is',NULL,'get','but','I\'ll','we','cvgffennzvqftxqw',1,'2000-07-03 13:40:30','I\'ll','vgffennzvqftxqwqb',19,NULL,'hey'),
934 (1,11,'rydwypaweyyyadkt','2008-10-08 19:33:58','well','there','ydwypaweyy','dwypaweyyy','not',2,NULL,'wypaweyyyadktqffyzmxkj','ok',47,NULL,'just'),
935 (1,1,'from','2007-01-26 14:26:59','wtalxwkfurakq','talxwkfurakqzrks','alxwkfurak','lxwkfurakq','xwkfurakqzrksfzj',0,'2005-02-14 14:21:41','wkfurakqzrksfzj','did',6,NULL,'you\'re'),
936 (2,23,'afkllnetzyzylflh','2007-02-09 22:56:14','you','fkl','kllnetz','llnetzyzyl','that\'s',0,NULL,'lnetzyzylflhpkrprnmduavmbuahk','with',16,'2001-12-17 03:12:53','mean'),
937 (2,17,'xrmpynumghtygkfh',NULL,'think','rmpynumghtygkfhw','mpynumghty','pynumghtyg','ynumghtygkfhwndq',2,NULL,'nu','did',7,'2001-02-10 22:23:59','good'),
938 (2,16,'sdmtshxrmpyn',NULL,'dmtshxrmpynumghtygkfhwndqxylj','mtshxrmpynumghty','going','really','tshxrmpynumghtyg',0,'2001-12-28 21:53:48','shxrmpynumghtygkfhwn','a',21,NULL,'hxrmpynumg'),
939 (0,13,'back',NULL,'yyyadktqffyzmxkj','yyadktqffyz','yadktqffyz','at','adktqffyzmxk',1,NULL,'tell','dktq',9,'2005-03-21 07:21:19','ktqffyzmxk'),
940 (0,2,'going',NULL,'see','kfurakqzrk','furakqzrks','urakqzrksf','up',1,NULL,'rakqzrk','akqzrksfzjudicvgffennzvqftxqwqb',10,NULL,'with'),
941 (0,4,'just','2001-01-19 08:03:10','ksfzjudicvgffennzvqftxqw','know','sfzjudicvg','do','fzjudi',2,NULL,'zjudi','be',46,'2007-11-04 21:44:23','judicvgffe'),
942 (0,8,'with',NULL,'good','come','they','want','nnzvqftxqwqbtr',3,'2009-06-06 11:48:13','his','up',15,'2004-03-22 05:43:36','nzvqftxqwq');
943
944 CREATE TABLE t (
945 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
946 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
947 `col_datetime_key` datetime DEFAULT NULL,
948 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
949 `col_datetime_unique` datetime DEFAULT NULL,
950 `col_int_key` int DEFAULT NULL,
951 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
952 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
953 `pk` int NOT NULL,
954 `col_int` int NOT NULL,
955 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
956 `col_int_unique` int DEFAULT NULL,
957 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
958 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
959 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
960 `col_datetime` datetime DEFAULT NULL,
961 PRIMARY KEY (`col_int`,`pk`) USING HASH,
962 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
963 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
964 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
965 UNIQUE KEY `col_varchar_10_unique` (`col_varchar_10_unique`),
966 UNIQUE KEY `ix1` (`col_int`,`col_int_unique`) USING HASH,
967 UNIQUE KEY `ix2` (`col_int_key`,`col_int_unique`) USING HASH,
968 KEY `col_varchar_256_key` (`col_varchar_256_key`),
969 KEY `col_datetime_key` (`col_datetime_key`),
970 KEY `col_int_key` (`col_int_key`),
971 KEY `col_varchar_10_key` (`col_varchar_10_key`),
972 KEY `col_char_16_key` (`col_char_16_key`)
973 ) ENGINE=ndbcluster;
974
975 INSERT INTO t VALUES ('out','xzhggqur',NULL,'it','2006-09-07 00:49:43',1,'zhggquryww','hggqurywwm',16,0,'ggqurywwmd',94,'from','gqurywwmdp','qur','2009-07-19 06:37:29'),
976 ('oh','avmbuahklgrl',NULL,'vmbuahklgrlhcjwj','2003-06-05 16:45:46',1,'mbuahklgrl','buahklgrlh',3,0,'uahklgrlhcjwjnal',18,'all','ahklgrlhcj','know',NULL),
977 ('was','hpkrprnmduavmbua','2009-07-05 16:04:43','pkrprnmduavmbuah',NULL,1,'how','a',1,0,'krprnmduavm',4,'don\'t','back','going','2000-07-12 05:14:49'),
978 ('look','could',NULL,'jpdyfruvhqeaokia','2006-01-17 14:48:31',3,'but','now',8,0,'pdyfruvhqeaokiad',NULL,'was','and','think','2002-02-05 18:27:09'),
979 ('fsbtyxxzhggqurywwmdpsnksmrsw','if',NULL,'hey','2004-03-16 06:19:55',0,'sbtyxxzhgg','btyxxzhggq',15,2,'tyxxzhggqurywwmd',11,'can\'t','yxxzhggqur','xxzhggqurywwmdpsnksmr','2008-02-06 09:46:44'),
980 ('snxxobbjemwiibarshpzcjdepvfrub','nxxobbjemwiibars','2007-07-16 09:32:15','now','2002-05-17 17:23:12',1,'I','didn\'t',24,1,'xx',34,'xobbjemwiibarshpzcjdepvfrub','got','had',NULL),
981 ('really','would',NULL,'her',NULL,2,'this','get',25,0,'were',91,'obbjemwiibarshpzcj','bbjemwiiba','bjemwiibarshpzcjdepvfr','2000-03-26 21:02:57'),
982 ('cjwjnalelgvcdzrxj','not','2009-04-07 15:12:21','jwjnalelgvcdzrxj',NULL,0,'wjnal','he\'s',5,0,'at',2,'when','jnalelg','nalelgvcdzrxj','2008-07-10 09:38:34'),
983 ('pegmxmbsivgvkpjhspzqkkszko','have','2004-01-05 20:59:55','egmxmbsivgvkpjhs','2008-12-07 00:48:29',0,'gmxmbsivgv','mxmbsivgv',20,1,'xmbsivgvkpjhspz',5,'mbsivgvkp','bsivgvkpjh','go',NULL),
984 ('how','were','2003-08-26 13:12:48','vhqeaokiad',NULL,1,'that\'s','but',10,0,'hqeaoki',33,'it','that','if',NULL),
985 ('qeaokiadappjpzabgjtnfsbty','how',NULL,'eaokiadapp','2003-12-19 05:14:27',1,'know','aokiadappj',11,0,'o',96,'kiadappjpzabgjtnfsbtyxx','i','could','2004-05-21 16:12:26'),
986 ('that\'s','hspzqkkszkodop','2003-06-08 15:59:01','spzqkkszkodo',NULL,1,'the','pzqkkszkod',21,1,'zqkk',93,'q','didn\'t','kksz','2007-05-05 00:21:26'),
987 ('dopufyausnxxobbjem','right','2000-09-15 21:01:31','opufyau',NULL,1,'pufyausnxx','don\'t',23,0,'my',31,'ufyausnxxobbjemwii','ok','fyausnxxobbjemwiibarsh',NULL),
988 ('dyfru','yfruvhqeaokiadap','2008-01-01 16:55:32','fruvhqeaokiadapp','2004-03-04 17:10:59',3,'out','was',9,2,'he',17,'ruvhqeaoki','were','uvhqeaokiadappjp',NULL),
989 ('pj','jpzabgjtnfsbtyxx','2001-03-04 20:19:45','pzabgjtnfsbt','2007-12-24 23:04:11',0,'got','my',13,3,'zabgjtnfsbtyxx',22,'abgjtnfsbtyxxzh','bgjtnfsbty','as','2007-02-02 21:41:31'),
990 ('adappjpzabgjtnfsb','dappjpzabgjtnfsb','2001-08-11 07:40:05','on','2008-07-22 05:27:07',3,'how','her',12,2,'when',55,'his','appjpzabgj','ppjpzabgjtnfsbtyxxzhggq','2004-03-24 17:10:28'),
991 ('dzrxjtaggjpdyfru','see','2000-08-23 01:48:59','about','2001-06-05 12:18:28',2,'he','something',6,3,'know',10,'then','zrxjtaggjp','rxjtaggjpdyfruvhqeao',NULL),
992 ('mdpsnksmrswbn','look',NULL,'here',NULL,0,'dpsnksmrsw','psnksmrswb',17,2,'snksmrswbnmx',14,'nksm','oh','ksmrswbnmxkvfqetznpvvydity',NULL),
993 ('gjtnfsb','jtnfsbtyxxzhggqu','2002-10-13 12:38:09','from',NULL,0,'then','are',14,2,'up',0,'come','tnfsbtyxxz','nfsbtyxxz',NULL),
994 ('hklgrlhcj','klgrlhcjwjnalelg',NULL,'lgrlhcjwjnalelgv','2003-08-08 18:30:56',0,'if','grlhcjwjna',4,1,'rlhcjwj',19,'lhcjwjnalelgvcdzr','hcjwjnalel','get',NULL),
995 ('wbnmxk','at',NULL,'bnmxkvfqetznpvvy','2007-11-23 07:42:02',3,'you','ok',18,1,'n',27,'mxkvfqet','xkvfqetznp','kvfqetznpvvydit','2001-09-04 20:57:49'),
996 ('her','xjtaggjpdyfruvhq','2005-02-28 13:50:28','going',NULL,2,'jtaggjpdyf','out',7,3,'taggjpdyfruvhqea',74,'aggjpdyfruvhqeaokiadappjp','ggjpdyfruv','gjpdyfr','2001-07-07 17:26:51'),
997 ('ksz','szkodopufyaus',NULL,'been','2007-05-13 17:04:01',2,'there','zkodopufya',22,2,'would',NULL,'got','kodopufyau','odopufyausnxxobbjemwi','2001-04-11 00:00:46'),
998 ('pvvydityzspegmxmbsivg','vvydityzspegmx',NULL,'vydityz','2003-04-28 15:17:35',1,'ydityzs','dityzspegm',19,2,'look',3,'ityzspegmxmbsivgvkp','it\'s','tyz',NULL),
999 ('can','rprnmduavmbua',NULL,'prnmduavmbuahklg',NULL,3,'you\'re','rnmduavmbu',2,0,'nmduavmbuahklgrl',72,'mduavmbuahklgrlhcjwjnalelgvcdzr','duavmbuahk','uavmb',NULL);
1000
1001 CREATE TABLE u (
1002 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
1003 `col_datetime_key` datetime DEFAULT NULL,
1004 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
1005 `col_datetime_unique` datetime DEFAULT NULL,
1006 `pk` int NOT NULL,
1007 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
1008 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
1009 `col_int` int NOT NULL,
1010 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
1011 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
1012 `col_datetime` datetime DEFAULT NULL,
1013 `col_int_unique` int DEFAULT NULL,
1014 `col_int_key` int DEFAULT NULL,
1015 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
1016 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
1017 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
1018 PRIMARY KEY (`col_int`,`pk`),
1019 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
1020 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
1021 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
1022 KEY `col_datetime_key` (`col_datetime_key`),
1023 KEY `col_varchar_256_key` (`col_varchar_256_key`),
1024 KEY `col_char_16_key` (`col_char_16_key`),
1025 KEY `col_int_key` (`col_int_key`),
1026 KEY `col_varchar_10_key` (`col_varchar_10_key`),
1027 KEY `ix1` (`col_char_16`,`col_char_16_unique`),
1028 KEY `ix2` (`col_varchar_256`,`col_varchar_10_unique`)
1029 ) ENGINE=ndbcluster;
1030
1031 INSERT INTO u VALUES ('nolvsksxmpasedzhrzzzxrttuw',NULL,'olvsksx',NULL,12,'or','he',0,'lvsksxmpas','vsksxmpasedzhrzz','2005-02-13 21:36:17',71,1,'sk','that\'s','some'),
1032 ('I\'ll',NULL,'wueubyoecglvgomtgvrwuvifq','2002-08-05 20:59:24',15,'for','ueubyoecglvgomtg',3,'say','when',NULL,31,2,'eubyoecglv','we','it\'s'),
1033 ('how',NULL,'ybedjnxftusxqctk','2007-02-10 08:20:57',26,'bedjn','yeah',1,'right','see','2001-05-05 15:35:37',33,0,'edjnxftu','do','djnxftusxqctkllpocmuysgpzg'),
1034 ('are',NULL,'can','2003-12-08 09:50:39',1,'ibarsh','it',2,'would','barshpzcjdepvfru','2000-03-19 17:37:21',89,1,'how','arshpzcjde','not'),
1035 ('te',NULL,'were',NULL,11,'ea','ok',0,'I','going',NULL,58,2,'aenolvsksx','enolvsksxm','could'),
1036 ('kekuhhzmjwedf','2005-01-22 04:18:51','this',NULL,18,'ekuhhzmjw','kuh',3,'uhhzmjwedf','hhz',NULL,0,1,'we','hzmjwedfgt','zmjwedfgtbvwcvqomkhljgocm'),
1037 ('u','2006-02-04 20:56:11','it','2001-08-01 06:43:07',5,'right','bzcihxezitrkfgsm',2,'if','would',NULL,10,2,'going','got','can'),
1038 ('dfgtbvwcvqomkhljgocmvdr',NULL,'they','2000-11-03 03:50:33',20,'well','fgtbvwcvqomkhljg',1,'gtbvwcvq','tbvwcvqomkhljgoc','2007-09-23 08:11:00',61,0,'there','bvwcvqomkh','vwcvqomkhljg'),
1039 ('wcvqom',NULL,'something',NULL,21,'I','cvqomkhljgocmvdr',3,'v','we',NULL,70,2,'qomkhljgoc','o','back'),
1040 ('a',NULL,'just','2003-02-10 23:38:31',13,'will','the',3,'are','sedzhrzzzxrttuwu','2001-06-20 18:43:22',7,3,'edzhrzzzxr','mean','something'),
1041 ('rttuwueubyoecglvgom',NULL,'be','2006-12-27 04:28:34',14,'don\'t','ttuwueubyoecglvg',1,'with','tuwueubyoecglvgo',NULL,18,2,'no','be','uwueubyoecgl'),
1042 ('vmxlxybedjnxf',NULL,'mxlxybedjnxftusxqctkl',NULL,25,'xlxybedjnxftusxq','lxybedjnxftusxqc',1,'xybedjnxft','him',NULL,94,0,'with','the','just'),
1043 ('tgvrwuvifqlekekuhhzmjwed',NULL,'gvrwuvifqlekekuhhzmjwedfgtbvwcv',NULL,17,'oh','have',0,'going','how',NULL,63,3,'vrwuv','rwuvifqlek','wuvifqlekekuhhzmjwedfgt'),
1044 ('ub','2003-10-26 03:18:37','byoecglvgomtgvrwuvifqlekekuhhzmj',NULL,16,'yoecglvgomtgvr','oecglvg',3,'ecglvgo','back','2006-06-18 21:37:37',3,3,'c','glvgomtgvr','l'),
1045 ('bliaihvhoteaenolvsksxmpa',NULL,'liaihvhot',NULL,9,'were','get',2,'iaihvhotea','can\'t',NULL,34,NULL,'ai','who','at'),
1046 ('him','2002-05-11 12:54:46','zcihxezitrk',NULL,6,'go','cihxezitrkfg',1,'ihxezitrkf','hxezitrkfgsmbl','2009-12-20 18:31:04',2,0,'xezitrkfgs','ezitrkfgsm','zitrkfgsmbliaihvhoteaeno'),
1047 ('his','2002-10-17 23:14:56','drncammchvehbdvm','2003-12-02 14:09:55',23,'one','rncam',3,'ncammchveh','so','2000-10-18 17:51:22',12,2,'good','there','c'),
1048 ('rshpz','2004-08-28 18:28:52','can','2002-04-10 11:22:35',2,'shpzcjdepvfrubzc','hpz',0,'want','on','2003-04-03 07:15:02',62,1,'was','yeah','ok'),
1049 ('for',NULL,'jnxftusxqctk','2009-03-07 01:05:40',27,'nxftusxqctkllpoc','if',3,'xftusxqctk','then',NULL,74,1,'from','ftusxqctkl','okay'),
1050 ('you','2004-06-26 13:51:14','how',NULL,24,'was','ammc',0,'some','I','2000-10-02 02:34:38',21,1,'he','tell','with'),
1051 ('jdepvfrubzcihxezitrkfgs',NULL,'depvfrubzcihxezit','2005-06-24 06:08:17',4,'epvfrubzcihxezit','well',1,'been','pvfrubzcihxezitr','2008-07-21 18:26:34',17,0,'vfrubzcih','frubzcihxe','rubzcihxezitrkfgsmblia'),
1052 ('can','2002-07-07 19:05:15','mjwedfgtbvwcvqomkhljgocmv','2008-03-13 23:05:20',19,'jwedfgtbvwcvqomk','and',1,'because','something',NULL,87,2,'wedfg','edfgtbvwcv','you\'re'),
1053 ('mkhljgocmvdrncammchvehbdvmxlxybe','2009-02-26 06:10:01','khljgocmvdrncammchvehbdvmxlxybed',NULL,22,'yeah','no',1,'didn\'t','then',NULL,76,3,'h','your','ljgocmvdrncammchvehbdv'),
1054 ('itrkfgsmbliaihvh','2007-03-23 00:44:32','know',NULL,7,'then','trkfgsmbliaihvho',2,'who','the',NULL,1,0,'rkfgsm','for','kf'),
1055 ('time','2000-06-15 06:53:26','fgsmb',NULL,8,'I','was',1,'well','gsmblia','2008-10-19 09:17:39',9,0,'smblia','so','mbliaihvhoteae'),
1056 ('well',NULL,'then','2006-12-05 01:12:44',3,'now','say',2,'p','are',NULL,15,2,'zcjdepvfru','I\'m','cjde'),
1057 ('ihvhoteaenolvs',NULL,'you','2007-04-11 02:13:10',10,'up','yes',1,'hvhoteaeno','vhoteaenolvsksxm','2006-09-23 14:57:47',13,0,'hoteaenolv','oteaenolvs','you');
1058
1059 CREATE TABLE v (
1060 `col_int` int DEFAULT NULL,
1061 `col_int_unique` int DEFAULT NULL,
1062 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
1063 `col_datetime_key` datetime DEFAULT NULL,
1064 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
1065 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
1066 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
1067 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
1068 `pk` int NOT NULL,
1069 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
1070 `col_int_key` int DEFAULT NULL,
1071 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
1072 `col_datetime` datetime DEFAULT NULL,
1073 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
1074 `col_varchar_256` varchar(256) COLLATE latin1_bin NOT NULL,
1075 `col_datetime_unique` datetime DEFAULT NULL,
1076 PRIMARY KEY (`pk`,`col_varchar_256`) USING HASH,
1077 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
1078 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
1079 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
1080 UNIQUE KEY `ix1` (`col_char_16`,`col_char_16_unique`) USING HASH,
1081 UNIQUE KEY `ix2` (`col_varchar_256`,`col_varchar_10_unique`) USING HASH,
1082 KEY `col_varchar_10_key` (`col_varchar_10_key`),
1083 KEY `col_datetime_key` (`col_datetime_key`),
1084 KEY `col_char_16_key` (`col_char_16_key`),
1085 KEY `col_varchar_256_key` (`col_varchar_256_key`),
1086 KEY `col_int_key` (`col_int_key`)
1087 ) ENGINE=ndbcluster;
1088
1089 INSERT INTO v VALUES (3,25,'who','2003-12-01 01:22:54','like','gqcaqouifkvuimek','qcaqouifkvuimekskfco','why',5,'can\'t',0,'how',NULL,'the','ca','2001-11-26 14:11:36'),
1090 (1,65,'cuwxudsmsk','2000-03-15 09:03:52','uwxudsmskrimoadw','know','wxudsmskrimoadwvvkxjkrzhwmtlspk','you',15,'xudsmskrim',3,'udsmskrimoa',NULL,'dsmskrimoa','you\'re','2006-11-10 02:31:00'),
1091 (1,4,'had','2002-05-16 17:01:34','g','he\'s','mgqzynfxjjja','gqzynfxjjjasvygjlxwgvskswhwjqzi',22,'have',3,'qzynfxjjjasvygjl',NULL,'from','zynfxjjjasvygjlxwgvskswhwjqzidj',NULL),
1092 (2,73,'iibnncuwxu',NULL,'ibnncuwxudsmsk','bnnc','my','because',14,'nncuwxudsm',0,'ncuwxudsmskrimoa',NULL,'not','could','2008-12-23 17:21:25'),
1093 (3,26,'for','2003-10-17 07:48:40','I\'m','qctkllpocmuysgpz','you\'re','right',2,'he\'s',2,'because','2007-08-25 17:19:46','go','ctkllpocmuysgpzgqcaq',NULL),
1094 (NULL,50,'vkxjkrzhwm','2009-01-20 04:04:17','did','would','kxjkrz','could',17,'can\'t',2,'xjkrzhwmtlsp','2008-11-28 21:39:45','she','jkrzhwmtl','2001-02-17 03:06:51'),
1095 (1,2,'of','2004-06-25 22:50:17','ynfxj','nfx','fxjj','okay',23,'xjj',2,'my','2000-11-12 05:56:48','don\'t','jjjasvygjlxwgvsks','2002-07-20 06:37:21'),
1096 (2,9,'acsogmgqzy',NULL,'cs','okay','did','his',21,'sogmgqzynf',2,'okay',NULL,'ogmgqzynfx','and','2001-06-06 09:30:16'),
1097 (2,49,'moadwvvkxj',NULL,'oadwvvkxjkrzhwmt','adwvvkxjkrzhwmtl','back','dwvvkxjkrzhwmtlspkqdaeiu',16,'wvvkxjkrzh',1,'can',NULL,'hey','vvkxjkrzhwmtl',NULL),
1098 (3,40,'lmeigzwelo','2003-08-20 22:30:51','meigzweloudxofox','eigzweloudxofoxh','igzwelo','not',10,'gzwelo',1,'I','2004-09-05 11:56:13','zweloudxof','we','2007-03-10 14:38:29'),
1099 (1,78,'mtlspkqdae',NULL,'get','tlsp','now','lspkqdaei',19,'spkqdaeiua',2,'pkqdaeiuacsogmgq','2001-02-15 08:29:54','to','kqdaeiuacsogmg','2000-04-07 14:28:54'),
1100 (0,87,'my',NULL,'kswhwjqzidj','swhw','whwjqzidjrptlypxvwrduehoibvlm','hwjqzidjrptlypxvwrduehoibvlmj',25,'wjqzidjrpt',NULL,'from',NULL,'when','jqzidjrptlypxvwrduehoibvlmjcxhif','2003-06-25 23:14:57'),
1101 (3,30,'jlxwgvsksw',NULL,'lxwgvskswhwjqzi','don\'t','xwgvskswhwjqzidjrptlypxvw','wgvskswhwjqz',24,'think',2,'that',NULL,'gvskswhwjq','all',NULL),
1102 (1,1,'djrptlypxv','2005-11-12 05:51:52','jr','right','see','rptlypxvwrduehoib',26,'pt',NULL,'is','2003-03-18 21:07:14','really','tlypxvwrduehoibvlmjcxh',NULL),
1103 (1,NULL,'want',NULL,'ehoibvlmjcxhifez','hoibvlmjcxhifezh','oibvlmjcxhife','ibvlm',29,'I\'ll',1,'bvlmjcxhifezhocc',NULL,'ok','and',NULL),
1104 (1,77,'ofoxhxlsio',NULL,'I','were','foxhxlsioiibnncuwxudsmskrimoa','to',12,'oxhxls',1,'xhxls','2008-02-08 06:07:04','be','hxlsioiibnncuwxudsmskrimoa','2009-06-27 14:33:24'),
1105 (3,19,'really','2001-07-05 14:09:00','qtzzfwnxzelmeigz','tzzfwnxzel','zzfwnxzelmeigzwelou','zfwnxzelmeigzwe',8,'this',2,'oh','2002-12-26 17:46:07','look','fwnxzelmei',NULL),
1106 (1,NULL,'as','2000-11-15 10:23:23','pzgqcaqouifkvuim','zgqcaqouifkvuime','can','want',4,'right',1,'it',NULL,'one','who','2008-08-03 09:25:21'),
1107 (1,8,'were',NULL,'qdaeiuacsogmgqzy','daeiuacsogmgqzyn','hey','aeiuacsogmgqz',20,'eiuacsogmg',0,'to',NULL,'iuacsogmgq','uac','2001-03-08 21:01:00'),
1108 (1,46,'ok','2006-08-08 23:19:42','aqouifkvuimekskf','qouifkvuimekskfc','how','now',6,'to',3,'ouifkvui','2005-12-20 20:50:13','uifkvuimek','what',NULL),
1109 (1,57,'krzhwmtls',NULL,'up','rzhwmtlspkqdaeiu','there','want',18,'zh',1,'hey','2007-11-02 08:30:09','hwmtlspkqd','wmtlspkqdaei',NULL),
1110 (NULL,99,'el',NULL,'how','loudxofoxhxlsio','oudxofoxhxls','for',11,'udxofoxhxl',0,'dxofoxh','2006-01-21 17:24:50','xofoxhxlsi','my',NULL),
1111 (1,70,'got',NULL,'lypxvwrduehoibvl','ypxvwrd','pxvwrduehoi','right',27,'can\'t',1,'got','2005-02-27 15:53:03','xvwrduehoi','vwrduehoibvlmjcxhifezh',NULL),
1112 (0,3,'tusxqctkll','2007-10-04 05:31:37','usxqctkllpocmuys','sxqctkllpoc','in','well',1,'say',1,'been','2000-08-25 17:23:04','he','xqctkllpocmuysg','2002-11-18 03:55:54'),
1113 (1,54,'xlsioiibnn','2004-03-11 19:00:26','lsioiibnncuwxuds','sioiibnnc','on','one',13,'got',2,'ioiibnncuwxudsms',NULL,'I\'ll','oiibnncuwxudsmskrimo',NULL),
1114 (2,93,'tkllpocmuy','2000-09-20 21:09:13','kllpocmuysgpzgqc','as','llpocmu','lpocmuysgpzgqcaqouif',3,'your',NULL,'pocmuysgpzgqcaqo',NULL,'my','hey',NULL),
1115 (3,95,'ifk',NULL,'come','what','fkvuimekskfcon','kvuimekskfconxqtzzf',7,'vuimekskfc',0,'it\'s',NULL,'uimekskfco','imekskfconxqtzzfwnxzelme','2002-04-20 03:59:52'),
1116 (0,83,'from',NULL,'wnxzelmeigzwelou','who','nxzelmeigzweloudxofoxhxls','xzelmeigzweloudxofoxhxls',9,'now',3,'zelmeigzwelou',NULL,'elmeigzwel','then',NULL),
1117 (3,79,'wrd',NULL,'rd','duehoibv','his','up',28,'come',1,'uehoibvlmjcxhife',NULL,'were','me',NULL);
1118
1119 CREATE TABLE w (
1120 `col_int` int DEFAULT NULL,
1121 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
1122 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
1123 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
1124 `pk` int NOT NULL AUTO_INCREMENT,
1125 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
1126 `col_int_key` int DEFAULT NULL,
1127 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
1128 `col_datetime_key` datetime DEFAULT NULL,
1129 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
1130 `col_datetime_unique` datetime DEFAULT NULL,
1131 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
1132 `col_int_unique` int DEFAULT NULL,
1133 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
1134 `col_datetime` datetime DEFAULT NULL,
1135 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
1136 PRIMARY KEY (`pk`),
1137 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
1138 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
1139 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
1140 UNIQUE KEY `ix1` (`col_char_16`,`col_char_16_unique`),
1141 UNIQUE KEY `ix2` (`col_varchar_256`,`col_varchar_10_unique`),
1142 KEY `col_varchar_10_key` (`col_varchar_10_key`),
1143 KEY `col_varchar_256_key` (`col_varchar_256_key`),
1144 KEY `col_int_key` (`col_int_key`),
1145 KEY `col_datetime_key` (`col_datetime_key`),
1146 KEY `col_char_16_key` (`col_char_16_key`)
1147 ) ENGINE=ndbcluster;
1148
1149 INSERT INTO w VALUES (0,'rfhtjqxgsukwlv','they','fhtjqxgsukwlvqez',7,'htjqxgsukw',0,'tjqxgsukwl','2009-08-06 14:26:25','and',NULL,'if',97,'or',NULL,'jqxgsukwlv'),
1150 (0,'to','ifezhocchh','fezho',3,'me',3,'ezhocchhsq',NULL,'zhocchhsqnixfbl',NULL,'why',18,'hocchh',NULL,'occhhsqnixfbljhfrfhtj'),
1151 (2,'then','ohodqkxyxk','hodqkxyxkmolcfwk',19,'odqkxy',NULL,'tell','2008-11-04 10:19:35','that\'s',NULL,'like',23,'dqkx',NULL,'some'),
1152 (2,'look','back','oyekglwzqqkglgti',12,'are',1,'a','2000-03-19 18:51:22','yekglwzqqkglgtib','2009-11-25 16:36:02','ekglwzqqkg',32,'yeah',NULL,'it'),
1153 (0,'sukwlvqezc','had','ukwlvqezceuapqoy',9,'kwlvqezceuapq',1,'wlvqezceua',NULL,'lvqez','2005-10-12 04:10:29','vqezceuapq',43,'qezceuap',NULL,'look'),
1154 (0,'at','how','qglgmaeykcuhdtvq',28,'look',3,'glgmaeykcu','2001-12-20 20:31:55','this',NULL,'lgmaeykcuh',72,'mean',NULL,'no'),
1155 (3,'because','qnixfbljhf','I\'ll',5,'nixfbljhfrfhtjq',3,'him','2007-06-17 06:57:29','ixfbljhfrfhtjqxg','2008-05-12 09:06:34','up',3,'it\'s',NULL,'is'),
1156 (3,'itrdqglgmaeykcuhdtvqjwtvr','have','up',27,'him',2,'something','2002-12-27 17:44:16','trdqg',NULL,'rdqglgma',11,'dqglgmaeykcuhdtv',NULL,'with'),
1157 (3,'ezceuapqoyekglwzqqkglgt','could','yeah',10,'go',0,'zceuapqoye',NULL,'out','2008-06-02 19:42:39','ceuapqoyek',44,'say',NULL,'euapqo'),
1158 (3,'bisohodqkxyxkmolcfwkabqkeayhr','what','back',18,'me',1,'yes',NULL,'isohodqkxyxkmolc',NULL,'sohodqk',69,'they',NULL,'all'),
1159 (1,'there','xkmolcfwka','mean',21,'mean',3,'kmolcfwkab',NULL,'mo','2004-11-18 23:51:19','olcfwkabq',1,'from','2007-03-03 16:42:39','lcfwkabqkeayhrv'),
1160 (1,'see','cfwkabqkea','fwkabqkea',22,'wkabqkeayhrvxxfnrgpzvpvvwqmpub',1,'kabqk','2009-02-07 00:37:24','can\'t','2009-08-27 07:14:08','like',84,'of',NULL,'see'),
1161 (3,'qkxyx','at','can',20,'kxyxkmolcfwkabqkeayhrvxxfnrgpzvp',3,'xyxkmolcfw','2001-01-04 17:45:49','going',NULL,'is',82,'I',NULL,'yxkmolcfwkabqkeayhrvxxfnrgpzvpvv'),
1162 (2,'glgt','lgtibaczot','gtibaczotqzwatwv',15,'and',1,'me',NULL,'or',NULL,'tibaczotqz',29,'ibaczotqzwatwvxk','2007-03-07 07:47:52','baczotqzwatwvx'),
1163 (0,'got','not','wzqqkglgtibaczo',14,'zqqkglgtibaczotqzwatwvxkbiso',1,'her','2000-03-19 09:02:34','qqkglgti','2009-06-14 01:02:22','that\'s',38,'qkglgtibaczotqzw',NULL,'kglgtibaczotqzw'),
1164 (1,'uapqoyekglwzqqkglgt','apqoye','get',11,'how',2,'of',NULL,'I\'ll',NULL,'pqoyekglwz',2,'all','2008-02-22 01:53:57','qoyekglwzqqkglgtibaczotqzwatwvxk'),
1165 (0,'xfbljhf','fbljhfrfht','bljhfrfhtjqxg',6,'got',2,'ljhfrfhtjq',NULL,'jhfrfhtjqxgsukwl','2007-01-27 20:00:46','hfrfhtjqxg',67,'up',NULL,'frfhtjqxgsukwlvqezceuapqoyek'),
1166 (1,'me','want','come',23,'because',0,'because',NULL,'did',NULL,'up',7,'rgpzvpvvwqmpubuq',NULL,'gpzvpvvwqmpubuqjcpskjujrpitrd'),
1167 (0,'would','jcpskj','in',26,'good',3,'cpskjujrpi',NULL,'okay','2006-08-05 22:37:13','pskjujrp',60,'skjujrpitrdqglgm','2004-01-21 06:54:29','kjujrpitrdqglgmaeykcuhdt'),
1168 (1,'will','tqzwatwvxk','qzwatwv',17,'zwatwvxkbisohodqkxyxkmolcfwkab',3,'watwvxkbis',NULL,'a',NULL,'oh',NULL,'twvxkbisohodqkxy',NULL,'wvx'),
1169 (2,'vlmjcxhifezhocchhsqnixfbl','lmjcxhifez','he\'s',1,'had',1,'she','2006-05-07 08:02:04','as','2003-01-04 12:12:15','mjcxhifezh',58,'jcxhifezhocchhsq','2005-09-03 13:34:51','going'),
1170 (2,'some','mean','kglwzqqkglgtibac',13,'have',2,'think','2002-05-09 02:30:08','but','2003-03-07 10:25:42','you\'re',10,'glwzqq','2009-10-04 21:39:28','lwzqqkglgtibaczotqzwatwvxkb'),
1171 (3,'gmaeykcuhdtvqjwtvrziz','come','mae',29,'aeykcuhdtvq',1,'no',NULL,'for','2001-02-08 08:17:55','eykcu',48,'here',NULL,'her'),
1172 (1,'aczotqzwatwv','the','czotqzwat',16,'out',1,'zotqzwatwv','2004-05-28 08:26:50','something',NULL,'really',73,'because',NULL,'otqzwatwvxkbisohodqkxyxkmolcfwk'),
1173 (3,'pubuqjcpskjujrp','ubuqjcpskj','buqj',25,'did',0,'I\'ll','2007-04-06 23:13:17','so','2004-06-06 09:59:53','uqjcpskj',30,'don\'t',NULL,'qjcpskjujrpit'),
1174 (0,'cxhifezhocchhsqnixfbljhfrfhtjqx','xhifez','with',2,'all',2,'good','2001-01-08 12:15:24','I\'m',NULL,'hifezhoc',65,'up','2008-06-16 03:28:44','mean'),
1175 (1,'up','out','some',24,'pzvpvvwqmpubuqjcp',1,'be','2008-09-25 21:53:53','zvpvvwqmpubuqjcp','2004-07-17 09:36:15','vpv',6,'pvvwqmpubuqjcpsk','2008-09-24 03:59:21','vvwqmpubuqjcpskjujrpitrdqglg'),
1176 (2,'dtvqjwtvrz','tvqjwtvrzi','oh',30,'say',2,'vqjwtvrziz','2007-07-04 02:03:48','qjwtvrzizqg','2007-08-16 06:44:31','your',12,'can\'t','2004-01-13 11:43:56','jwtvrzizqgmjlkfdihivchsgfwivlyfg'),
1177 (0,'cchhsqnixfbljhfrfhtj','about','chhsqnix',4,'well',NULL,'hhsqnixfbl','2006-05-11 02:10:33','hsqnixfbljhfrfht','2002-04-09 02:26:00','sqnixfbljh',31,'would','2008-07-21 05:30:39','me'),
1178 (0,'I\'m','didn\'t','qxgsu',8,'is',0,'go','2009-02-15 07:07:40','get',NULL,'xgsukw',17,'gsukwlv',NULL,'to');
1179
1180 CREATE TABLE x (
1181 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
1182 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
1183 `col_int_unique` int DEFAULT NULL,
1184 `col_int_key` int DEFAULT NULL,
1185 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
1186 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
1187 `col_datetime` datetime DEFAULT NULL,
1188 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
1189 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
1190 `col_int` int NOT NULL,
1191 `col_datetime_key` datetime DEFAULT NULL,
1192 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
1193 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
1194 `col_datetime_unique` datetime DEFAULT NULL,
1195 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
1196 `pk` int NOT NULL,
1197 PRIMARY KEY (`col_int`,`pk`),
1198 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
1199 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
1200 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
1201 KEY `col_varchar_256_key` (`col_varchar_256_key`),
1202 KEY `col_int_key` (`col_int_key`),
1203 KEY `col_datetime_key` (`col_datetime_key`),
1204 KEY `col_varchar_10_key` (`col_varchar_10_key`),
1205 KEY `col_char_16_key` (`col_char_16_key`),
1206 KEY `ix1` (`col_char_16`,`col_char_16_unique`),
1207 KEY `ix2` (`col_varchar_256`,`col_varchar_10_unique`)
1208 ) ENGINE=ndbcluster;
1209
1210 INSERT INTO x VALUES ('up','ybqvctokjtidvfak',3,1,'could','think',NULL,'bqvctokjtidvfakc','qvctokjtidvfak',2,'2002-07-15 06:57:12','vctokjtidv','ctokjtidvfakcuir','2003-04-01 09:26:13','been',17),
1211 ('fpjnohwpiacuyexxwaj','pjnohwpiacuyexxwajoiigpdgjjw',97,2,'say','he\'s','2001-09-20 17:33:41','jnoh','n',2,'2008-06-17 17:52:13','ohw','was',NULL,'hwpiacuyex',23),
1212 ('he\'s','is',16,0,'gjbftejxbh','yeah',NULL,'yes','up',3,'2004-05-04 05:19:18','jbftej','bftejxbhhoznusuq','2008-01-03 22:56:12','can\'t',7),
1213 ('fd','dihivchsgfw',52,1,'out','but','2006-04-01 17:05:30','he','ihivchsgfw',0,NULL,'hivchsg','ivc','2000-05-08 07:18:59','vchsgfwivl',3),
1214 ('idv','dvfakcuirqkdqjx',15,0,'this','vfakcuirqkdq','2002-05-11 08:18:36','here','fakcuirqkdqjxqpp',1,NULL,'akcuirqkdq','kcuirqkdqjxqpplm',NULL,'as',19),
1215 ('gjjwljngb','what',1,3,'who','were','2005-01-27 23:32:09','jjwljngbhhmtefyuotlxqefyfdkx','had',1,'2002-04-19 06:22:34','jwljngbhhm','about',NULL,'wljngbhhmt',26),
1216 ('wtvrzizqgmjlkfdihivchsgfwi','tvrzizqgmjlkf',70,0,'vrzizqgmjl','was','2009-10-01 14:05:05','rzizqgmjlkfdihivchsgfwivlyfg','zizqgmjlkfdihivc',0,'2003-07-04 01:57:31','right','izqgmjlkfdihivch','2005-09-12 03:09:16','zqgmjl',1),
1217 ('lmgptelgosvgtviwq','her',48,1,'mgptelgosv','really','2003-06-14 19:50:28','say','all',0,NULL,'gptelgo','do',NULL,'one',21),
1218 ('ngbhhmt','gbhhmtefyuotlxqefyfdkxerr',78,2,'bhhmte','say','2003-10-07 15:31:05','then','one',2,'2000-06-22 00:29:01','hhmtefyuot','hmtefyuotlxqefyf','2001-05-17 02:02:42','like',27),
1219 ('qorgqhp','orgqhpybqvctokj',9,0,'rgqhpybqvc','gqhpybqvctokjtid',NULL,'qhpybqvctokjtidvfakc','this',1,'2007-03-11 18:19:43','hpybqvcto','I\'ll',NULL,'pybqvctokj',16),
1220 ('gpwpuaqorgqhpybqvctokjtidvfak','you',11,0,'pwpuaqorgq','wpuaqorgqhpybqvc',NULL,'at','puaqorgq',3,'2009-08-21 23:37:11','go','uaqorgqhpybqvcto',NULL,'aqo',15),
1221 ('wajoiigp','ajoiigpdgjjwljngbhhmt',39,3,'jo','some','2003-02-25 14:35:58','oiigpdgjjwljngbhhmtefy','from',3,'2005-04-05 16:48:29','back','iigpdgjjwljngbhh',NULL,'in',25),
1222 ('you\'re','we',17,2,'enreawhbfh','nreawhbfhrnlliqk',NULL,'on','she',0,'2005-04-02 21:55:53','the','what','2008-09-28 23:11:28','reawhbfhrn',11),
1223 ('uelupgjbftej','here',6,3,'elupgjbfte','so','2001-03-23 10:52:21','that','lupgjbftej',3,NULL,'upgjbftejx','didn\'t',NULL,'pgjbftejxb',6),
1224 ('vlyfgiuelupgjbfte','it',5,0,'lyfgiuelup','yfgiuelupgjbftej',NULL,'fgiuelupgjbftejxbhhoznusu','giuelupgjbftejxb',2,'2004-11-27 04:10:06','how','then','2009-07-25 09:46:22','iuelupgjbf',5),
1225 ('your','think',20,0,'would','xbhhoznusuqcyenr',NULL,'bhho','will',1,NULL,'hh','up',NULL,'hoznusuqcy',9),
1226 ('hrnlliqknwavnuqezsscxg','rnlliqknwavnuqezsscxgpw',7,3,'nlliqknwav','I','2001-05-18 07:31:52','lliqknwavnu','liqknwavnuqe',0,NULL,'iqknwa','really',NULL,'that\'s',12),
1227 ('for','vnuqezsscxgpwpuaqorgqhpybqvct',50,2,'she','how','2009-09-06 21:45:44','nuqezsscxgpwpuaq','uqezsscxgpwpuaq',3,NULL,'qezsscxgpw','ezsscxgpwpuaqorg',NULL,'z',13),
1228 ('really','wpiacuyexxwajoiigpdgjjw',73,0,'piacuyexxw','so','2000-05-25 04:55:47','iacuyexxwajoii','acuyexxwajoiigpd',1,NULL,'all','cuyexxwajoiig',NULL,'that',24),
1229 ('we','tokjtidvf',8,2,'okjtidvfak','good','2002-09-18 05:49:24','yeah','well',2,'2002-03-07 05:00:42','kjtidvfakc','jtidvfakcui',NULL,'tidvfakcui',18),
1230 ('ok','like',19,1,'tviwqbu','viwqbuvjsvvaqlfp','2000-09-25 17:23:55','right','is',3,NULL,'iwqbuv','wqbu',NULL,'qbuvjsvvaq',22),
1231 ('sscxgpwpuaqorgq','scxgpwpuaqorgqhpyb',10,0,'could','were','2006-04-21 05:46:10','he\'s','cxgpwpuaqorgqhpy',0,NULL,'xgpwpuaqor','would','2008-05-18 07:09:46','well',14),
1232 ('oznusuqcyenreawhbfhrnll','znusuqcyenrea',2,1,'nusuqcyenr','were',NULL,'I','usuqcyenreawhbfh',1,NULL,'suqcyenrea','to','2007-11-28 17:03:51','uqcyen',10),
1233 ('mean','cuirqkdqjx',40,3,'uirqkdqjxq','is',NULL,'I\'m','he',1,'2001-09-25 03:42:26','yes','irqk','2000-08-24 11:43:06','it\'s',20),
1234 ('she','qgmj',36,3,'gmjlkfd','mjlkfd','2009-05-18 09:56:16','jlkfdihivchsgfwivlyfgiuelu','l',3,NULL,'hey','they','2003-09-19 03:36:05','kfdihivchs',2),
1235 ('ftejxbhhoznusuqcyenreawhb','yes',57,0,'tejxbhhozn','ejxbhhozn',NULL,'me','see',1,'2007-11-01 20:13:42','jxbhhoznus','it',NULL,'ok',8),
1236 ('chsgfwivl','hsgfwivlyfg',51,0,'had','sgfwivlyfgiue','2006-09-20 10:37:06','gfwivlyfgiuelupgjbftejxbhh','fwiv',2,'2001-11-17 13:46:45','wivlyfgiue','ivlyfgiuelupgjbf',NULL,'if',4);
1237
1238 CREATE TABLE y (
1239 `col_int_key` int DEFAULT NULL,
1240 `col_datetime` datetime DEFAULT NULL,
1241 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
1242 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
1243 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
1244 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
1245 `col_datetime_unique` datetime DEFAULT NULL,
1246 `col_datetime_key` datetime DEFAULT NULL,
1247 `pk` int NOT NULL,
1248 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
1249 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
1250 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
1251 `col_int` int NOT NULL,
1252 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
1253 `col_int_unique` int DEFAULT NULL,
1254 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
1255 PRIMARY KEY (`col_int`,`pk`),
1256 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
1257 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
1258 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
1259 UNIQUE KEY `ix1` (`col_char_16`,`col_char_16_unique`),
1260 UNIQUE KEY `ix2` (`col_varchar_256`,`col_varchar_10_unique`),
1261 KEY `col_int_key` (`col_int_key`),
1262 KEY `col_char_16_key` (`col_char_16_key`),
1263 KEY `col_varchar_256_key` (`col_varchar_256_key`),
1264 KEY `col_datetime_key` (`col_datetime_key`),
1265 KEY `col_varchar_10_key` (`col_varchar_10_key`)
1266 ) ENGINE=ndbcluster;
1267
1268 INSERT INTO y VALUES (2,NULL,'r','mean','one','tv',NULL,NULL,10,'it','there','vzfjeyyvsx',2,'zfjeyyvsxefucefu',56,'fjeyyv'),
1269 (2,'2007-02-22 07:13:22','sanplcdpcztoqnto','anplcdpcztoqntoo','you','nplcdpczto',NULL,NULL,16,'plcdpczt','lcdpcztoq','cdpcztoqnt',0,'dpcztoqntooevmwx',52,'look'),
1270 (1,'2006-12-08 23:09:03','here','look','would','he','2001-10-19 23:39:08',NULL,21,'the','of','gqyphbhbhz',2,'qyphbhbh',NULL,'was'),
1271 (2,NULL,'jeyyvsxefucefumu','mean','tell','eyyvsxefuc','2001-08-16 00:48:47',NULL,11,'be','what','is',0,'yyvsxefucefumupy',1,'yvsxefucefumupythocu'),
1272 (0,'2008-11-25 10:02:45','aekuuam','be','eku','ku','2007-11-26 19:14:32','2006-04-21 16:06:34',26,'uuamstxdxwoyupbkk','ua','this',1,'okay',16,'my'),
1273 (1,'2007-10-07 14:59:37','been','euwwdfrmirzpjp','uwwdfrm','right',NULL,'2008-04-05 13:21:15',23,'did','wwdfrmirzp','the',1,'of',3,'how'),
1274 (1,NULL,'can\'t','mvayghwmxskl','were','mean','2007-11-02 00:03:23','2006-09-09 03:41:46',5,'v','with','him',2,'ayghwmxsklhospfz',40,'were'),
1275 (3,NULL,'mtefyuotlxqefyfd','tefyuotlxqefyf','your','I\'m','2001-07-18 08:05:38',NULL,1,'efyuotlxqefyfdkxerrmvayghw','don\'t','fyuotlxqef',3,'her',14,'what'),
1276 (2,NULL,'what','rnaspvfryjzquohc','here','got','2003-10-13 17:02:06','2006-05-20 18:56:04',31,'you\'re','naspvfryjz','aspvfryjzq',3,'spvfryjzquohcjjz',91,'pvfryjzquohcjjzvrsahytb'),
1277 (3,NULL,'one','gwdbfxpbfjdiurna','yeah','with','2008-05-14 08:52:54','2006-06-23 04:13:49',29,'time','wdbfxpbfjd','dbfxpbfjdi',3,'had',66,'bfxpbfjdiurnaspvfryj'),
1278 (3,'2000-09-15 12:39:24','think','yfmmaekuuamstxdx','fmmaekuuamstxdxwoyupbkkvei','yeah','2005-04-24 00:16:20',NULL,25,'she','no','mmaekuuams',1,'maekuuamstxdxwoy',80,'of'),
1279 (NULL,NULL,'just','come','kkveiyhekim','yes',NULL,NULL,27,'it\'s','kveiyhekim','all',1,'look',46,'would'),
1280 (2,NULL,'as','thocugnbubcsanpl','ho','me',NULL,NULL,14,'didn\'t','ocugnbubcs','going',0,'because',54,'see'),
1281 (3,'2004-06-16 16:44:22','vsxefucefumupy','sxefucefum','but','tell','2004-07-01 22:43:34',NULL,12,'xefucefumupythocu','efucefumup','fuce',2,'come',76,'been'),
1282 (2,'2002-01-27 04:45:21','fzlryxrrtvzfjeyy','zlryxr','because','I\'ll','2007-06-19 06:18:06','2003-06-25 07:29:54',9,'lryxrr','ryxrrtvzfj','yxrrtvzfje',3,'xrrtvzfjeyyvsxef',23,'rrtvzfjeyyvsxefucefumupyt'),
1283 (3,NULL,'fhentgqyphbhbhzc','have','that','hentgqyphb',NULL,'2005-12-08 20:03:46',20,'entgqyphbhbhzcukpiggkeuwwdf','ntgqyphbhb','I\'ll',1,'tgqyphbhbh',2,'were'),
1284 (0,'2006-06-10 16:27:45','his','don\'t','spfzlryxrrtvzfj','the',NULL,'2002-06-13 03:54:13',8,'do','pfzlryxrrt','up',2,'there',7,'your'),
1285 (0,'2002-02-26 06:14:37','fxpbfjdiurnaspvf','xpbfjdiurnaspvfr','been','were',NULL,NULL,30,'pbfjdiurnaspvfryjzquohcjj','his','bfjdiurnas',0,'fjdiurn',95,'been'),
1286 (2,'2008-06-03 06:44:19','up','veiyhekimgwdbfxp','eiyhekimgwdbfxpbfjdiurnaspv','iyhekimgwd',NULL,'2009-04-01 03:32:41',28,'about','yhekimgwdb','they',2,'from',13,'h'),
1287 (1,'2003-08-14 02:05:20','ygh','okay','ghwmxsklhospfzlryxrrtvzfjeyyvsx','oh','2007-04-27 14:32:45','2008-02-21 14:02:52',6,'for','be','hwmxsklhos',3,'wmxsklhospfzlryx',18,'mxsklhospfzlryxrrtvzfjeyy'),
1288 (0,'2000-01-25 16:00:23','right','kx','say','out',NULL,NULL,4,'xerrmvayghwmxsklhospfzlryxrrtvz','errmvayghw','then',1,'rrmv',64,'r'),
1289 (3,NULL,'xsdfhentgqyphbhb','is','sdfhentgqyphbhbhzcukp','see','2007-11-26 15:37:28',NULL,19,'dfhentgqyphbhbhzc','been','I\'m',1,'up',30,'he\'s'),
1290 (1,NULL,'iggkeuwwdfrmirzp','would','gg','gkeuwwdfrm',NULL,NULL,22,'at','keuwwdfrmi','a',2,'he\'s',92,'out'),
1291 (1,'2006-08-22 22:24:49','here','him','fumupythocugnbubcsanplcdpcz','umupythocu',NULL,'2006-06-16 11:08:26',13,'he','didn\'t','mupythocug',0,'can',59,'him'),
1292 (2,'2002-03-09 13:52:16','going','pcz','czt','but','2009-01-26 08:27:08','2004-02-20 23:13:12',17,'him','that\'s','ztoqntoo',2,'toqntooevmwxsdfh',82,'how'),
1293 (1,'2006-04-13 12:28:52','bubcsanplcdpczto','with','why','who','2008-06-12 13:14:45',NULL,15,'ubcsanplcdpcztoqnt','to','bcsanplcdp',0,'one',58,'csanplcdpcztoqntooevmwxsdfhentgq'),
1294 (3,NULL,'we','yuotlxqefyfdkxer','uotlxqe','it\'s','2004-06-22 08:47:26','2001-12-20 14:45:29',2,'from','otlxq','tlxqefyfdk',0,'lxqefyfdk',5,'xqefy'),
1295 (3,NULL,'uohcjjzvrs','with','of','there','2009-02-08 22:25:03',NULL,33,'ohcjjzvrsahytbomh','got','you\'re',0,'with',9,'hcjjzv'),
1296 (0,'2003-06-25 02:44:39','think','I\'ll','oqntooevmwxsdfhentg','just','2002-09-02 10:03:41','2007-04-09 17:35:20',18,'will','qntooevmwx','now',2,'ntooevmwxsdfhent',NULL,'tooevmw'),
1297 (3,NULL,'wdfrmirzpjppgtlv','dfrmirz','in','frmirzpjpp','2001-08-17 18:39:57','2006-05-26 13:00:43',24,'rmirzpjppgtlvwivxpqyfmmaekuu','up','mirzpjppgt',0,'irzpjppgtlvwivxp',90,'be'),
1298 (3,NULL,'vfry','fryjzquohcjjzvrs','be','one',NULL,NULL,32,'ryjzquohcjjzvrs','I\'ll','don\'t',2,'him',49,'as'),
1299 (1,'2006-04-24 17:19:22','didn\'t','qef','how','efyfdkxerr',NULL,NULL,3,'fyfdk','we','yfdkxerr',2,'fd',93,'dkxerrmvayghw'),
1300 (0,NULL,'is','xsklhospfzlryxrr','sklhospfzlryxrrtvzfjeyyvsxe','klhospfzlr',NULL,'2002-06-06 02:06:00',7,'lhospf','hospfzlryx','from',3,'os',6,'ok');
1301
1302 CREATE TABLE z (
1303 `col_int_unique` int DEFAULT NULL,
1304 `col_varchar_10_key` varchar(10) COLLATE latin1_bin DEFAULT NULL,
1305 `col_int` int DEFAULT NULL,
1306 `pk` int NOT NULL AUTO_INCREMENT,
1307 `col_datetime_unique` datetime DEFAULT NULL,
1308 `col_char_16` char(16) COLLATE latin1_bin DEFAULT NULL,
1309 `col_char_16_key` char(16) COLLATE latin1_bin DEFAULT NULL,
1310 `col_int_key` int DEFAULT NULL,
1311 `col_datetime` datetime DEFAULT NULL,
1312 `col_char_16_unique` char(16) COLLATE latin1_bin DEFAULT NULL,
1313 `col_varchar_10` varchar(10) COLLATE latin1_bin DEFAULT NULL,
1314 `col_varchar_256_unique` varchar(256) COLLATE latin1_bin DEFAULT NULL,
1315 `col_datetime_key` datetime DEFAULT NULL,
1316 `col_varchar_256_key` varchar(256) COLLATE latin1_bin DEFAULT NULL,
1317 `col_varchar_10_unique` varchar(10) COLLATE latin1_bin DEFAULT NULL,
1318 `col_varchar_256` varchar(256) COLLATE latin1_bin DEFAULT NULL,
1319 PRIMARY KEY (`pk`),
1320 UNIQUE KEY `col_datetime_unique` (`col_datetime_unique`),
1321 UNIQUE KEY `col_char_16_unique` (`col_char_16_unique`),
1322 UNIQUE KEY `col_varchar_256_unique` (`col_varchar_256_unique`),
1323 UNIQUE KEY `ix1` (`col_char_16`,`col_char_16_unique`) USING HASH,
1324 UNIQUE KEY `ix2` (`col_varchar_256`,`col_varchar_10_unique`) USING HASH,
1325 KEY `col_varchar_10_key` (`col_varchar_10_key`),
1326 KEY `col_char_16_key` (`col_char_16_key`),
1327 KEY `col_int_key` (`col_int_key`),
1328 KEY `col_datetime_key` (`col_datetime_key`),
1329 KEY `col_varchar_256_key` (`col_varchar_256_key`)
1330 ) ENGINE=ndbcluster;
1331
1332 INSERT INTO z VALUES (23,'about',NULL,19,NULL,'aurwrurjcqcmbfes','urwrurjcqcmb',1,NULL,'rwrurjcqcmbfeska','wrurjcqcmb','say','2008-10-02 05:22:55','one','rurjcqcmbf','see'),
1333 (12,'she',3,12,'2005-08-09 16:53:39','or','yokptuplfukamiwt',0,'2008-06-04 14:05:54','his','with','one','2008-05-16 16:14:36','okp','my','would'),
1334 (NULL,'think',NULL,7,'2008-02-06 09:53:37','midxalztdtgbwvcj','could',2,'2005-11-01 12:50:50','idxalztdtgbwvcj','dxalztdtgb','xalztdtgbwvcjraczxgmmi','2004-10-18 12:55:12','alztdtgbwvcjraczxgmmiyokptupl','it','why'),
1335 (4,'there',3,3,NULL,'ibpkgiyshfsuypvw','bpkgiyshfsuypvwa',1,NULL,'say','good','okay','2005-07-17 13:02:46','p','been','kgiyshfsuypvwazxvmi'),
1336 (1,'uypvwa',NULL,5,'2007-07-20 02:17:02','ypvw','pvwazx',1,NULL,'some','look','are','2000-12-27 05:57:19','vwazxvmidxalztdtgbwvcjraczxg','wazxvmidxa','yes'),
1337 (72,'gxjugbpymz',2,51,'2007-03-01 04:02:34','why','as',0,NULL,'now','xjugbpymzl','like','2000-06-28 15:13:51','like','be','jugbpymzlgzjxixrgqwmxgyfu'),
1338 (13,'tgbwvcjrac',1,9,'2007-04-26 01:59:58','think','gbwvcjraczxgmmiy',2,'2008-07-28 19:36:04','something','bwvcjraczx','on','2005-06-21 15:16:19','him','but','have'),
1339 (NULL,'him',1,28,NULL,'i','didn\'t',2,'2006-07-08 18:03:06','wmqtrrgtjcrqimcw','mqtrrgtjcr','qtrrgtjcrqimcwinecvidykmb','2006-08-09 14:20:56','trrgtjc','his','rrgtjc'),
1340 (53,'up',0,54,NULL,'for','rgqwmxgyfudxbwpy',1,NULL,'you\'re','gqwmxgyfud','qwmxgyfud','2009-08-07 12:57:18','were','w','mxgyfudxb'),
1341 (36,'ijaucjmfvm',1,59,NULL,'your','jaucjm',1,NULL,'and','something','aucjmfvmijr','2007-10-07 03:51:46','ucjmfvmijrhcfwfhrtsrm','cjmfvmijrh','is'),
1342 (0,'could',1,60,'2001-01-06 14:07:30','jm','mfvmijr',3,NULL,'could','fvmijrhcfw','vmijrhcfwfhrtsrm','2009-10-25 09:22:22','one','mijrhcfwfh','her'),
1343 (15,'was',2,10,NULL,'wvcjraczxgmmiyok','no',3,'2000-01-28 19:39:56','vcjraczxgmmiyo','was','mean',NULL,'her','really','cjraczxgmmi'),
1344 (48,'was',3,27,'2002-06-05 03:23:00','vmepoukwnoiwm','mep',0,'2009-03-13 02:44:02','epoukwnoiwmq','me','didn\'t','2009-07-19 18:40:33','poukwnoiwmqtr','oukwnoiwmq','be'),
1345 (5,'gr',0,32,NULL,'roxgzcdblegxjugb','oxgzcdblegxjugbp',2,NULL,'xgzcdblegxjugbpy','okay','for',NULL,'gzcdb','zcdblegxju','had'),
1346 (54,'I',2,70,NULL,'at','nlouvznulgadkvmn',2,'2002-12-02 23:33:59','there','louvznulga','it',NULL,'ouvznulgadkvmnzpaijrisreoqj','like','uvznulgadkvmnzpaijris'),
1347 (16,'can\'t',0,18,NULL,'tiocaurwrurjc','iocaur',3,'2003-12-19 23:12:43','ocaurwrurjcqcm','now','I\'m',NULL,'caurwrurjcqcmbfesk','for','if'),
1348 (41,'time',1,21,NULL,'it\'s','you',1,'2007-08-25 06:34:00','that\'s','utifbuveaa','tifbuveaaotpjpyxexlnhzmmfice','2002-10-14 00:35:45','some','ifbuvea','my'),
1349 (31,'it',0,61,NULL,'your','me',NULL,NULL,'fwfhrtsrmnkvszvl','so','something','2007-08-02 11:32:15','ok','wfhrtsrmnk','like'),
1350 (6,'got',1,20,NULL,'mbfeskaajihutif','they',3,'2003-12-18 22:56:28','of','bfeskaajih','feskaaj',NULL,'eskaa','why','or'),
1351 (84,'would',1,52,'2006-03-16 10:06:34','really','to',2,'2009-02-03 16:08:58','was','here','ymzlgzjxixrgqwmxgyfudxbwpynoqr','2005-10-09 19:39:32','mzlgzjxixrgqwmxgyfudxbwpyn','zlgzjxixrg','yes'),
1352 (95,'so',3,53,NULL,'you','his',0,NULL,'xix','get','ixrgqwmxgyfudxbwpyn',NULL,'I\'m','xrgqwmxg','like'),
1353 (61,'ynoqr',1,57,NULL,'noqruosotlcgymop','how',3,NULL,'about','don\'t','up',NULL,'oqruosotlcgymop','what','know'),
1354 (17,'ok',1,22,NULL,'fbuveaaotpjpyxex','at',0,NULL,'buveaaotpjpyxexl','he\'s','uveaaotpjpyxexlnhzmm',NULL,'veaaotpjpyxe','eaaotpjp','aaot'),
1355 (94,'miwt',3,14,NULL,'iwtvqrgvkgtgmnli','what',1,NULL,'not','wtvq','how',NULL,'tvqrg','vqrgvkgtgm','qrgvkg'),
1356 (7,'oxrklyhniq',2,72,'2009-02-05 10:16:36','there','xrklyhniqobiooeu',2,NULL,'know','it\'s','really',NULL,'rklyhniqobiooeuikzjhwa','klyhniqobi','look'),
1357 (76,'rgvkgtgmnl',2,15,NULL,'gvkgtg','vkgtgmn',0,NULL,'kg','gtgmnlixti','tell',NULL,'look','a','because'),
1358 (98,'tell',2,11,NULL,'gmmiyokptuplfuka','m',2,NULL,'no','want','out','2003-08-04 13:39:40','time','miyokptupl','iyokptuplfukamiwtvq'),
1359 (NULL,'me',1,66,NULL,'dvpqmsncjmvzdljh','vpqmsncjmvzdljhw',0,NULL,'pqmsncjmvzd','but','qmsncjmvzdljhwl','2001-09-17 20:46:42','ms','sn','oh'),
1360 (59,'like',2,31,NULL,'cvidykmbzcsqtykg','for',0,'2008-08-11 23:19:31','I','vidykmbzcs','have',NULL,'something','idykmbzcsq','dykmbzcsqtyk'),
1361 (80,'from',0,62,'2001-08-03 02:22:51','fhrtsrmnkvszvlax','hrtsrmnkvszvlaxq',1,'2002-05-01 15:52:03','up','then','rtsrmnkvszvl',NULL,'right','tsrmnkvs','srmnkvszvlaxqcfwwfbwqbyprcggta'),
1362 (20,'say',1,1,NULL,'in','time',1,'2005-12-12 03:56:30','so','who','going',NULL,'ytbomhrgibp','tbom','with'),
1363 (38,'wwfbwq',0,64,NULL,'wfbw','come',1,NULL,'on','that\'s','get','2009-08-01 05:08:44','fbwqbyprcggtau','so','were'),
1364 (NULL,'your',0,6,NULL,'right','azxvmidxalz',3,NULL,'her','to','zxvmidxalztdtgbwvcjraczxgmm','2002-02-21 06:10:31','xvmidxalztdtgbwvcjracz','vmidxalz','is'),
1365 (82,'qhppxnnxzl',0,23,NULL,'just','hppxnnxzldznlzjr',0,'2003-01-13 04:21:29','in','ppxnnxzldz','no',NULL,'got','pxnnxzldzn','xnnxzldznlzjreefnxwbl'),
1366 (81,'r',0,68,'2006-05-27 11:40:28','me','exudwrhju',0,'2008-08-19 02:17:55','I\'ll','on','xudw',NULL,'ud','he\'s','dwrhjutwilyufanlouvz'),
1367 (87,'then',2,13,'2005-09-19 17:58:40','kptu','like',2,NULL,'don\'t','yes','hey','2002-02-24 07:46:27','ptu','tuplfukami','uplfukamiwtvqrgvkgtgmnlix'),
1368 (19,'can',1,63,NULL,'rmnkvszvlaxqcfww','how',3,'2003-08-19 18:57:55','or','this','what','2007-07-28 05:36:28','is','mnkvszvlax','nkvszvlaxqcfwwfb'),
1369 (11,'reefnxwblv',0,26,NULL,'eefnxwblvmepoukw','I',1,NULL,'it','efnxwblvme','fnxwblvmepoukwnoiwm','2007-10-17 00:51:35','nxwb','of','is'),
1370 (75,'know',3,25,'2005-10-13 18:18:12','to','or',NULL,NULL,'n','lzjreefnxw','oh','2006-05-27 06:46:41','zjreef','jreefnxwbl','good'),
1371 (32,'udxb',1,56,NULL,'oh','dxbwpynoqruosotl',3,'2005-12-15 03:47:16','get','xbwpynoqru','just',NULL,'bwpynoqruosotlcgymopmfmzeij','wpynoq','pynoqruoso'),
1372 (9,'xgyfudxbwp',3,55,'2005-04-26 15:39:18','okay','gyfudx',1,'2007-04-27 02:12:00','think','all','yes',NULL,'up','yfudxbwpyn','fudxbwpynoqruosotlc'),
1373 (10,'ixtiocaurw',1,17,NULL,'want','had',1,'2000-02-24 21:19:09','out','they','that\'s',NULL,'xtiocaurwr','one','do'),
1374 (51,'bomhrgibpk',1,2,NULL,'omhrgibpkgiyshfs','your',3,'2008-11-12 14:18:10','mhrgibpkgiyshf','hrgibpkgiy','rgibpkgiy',NULL,'gibpkgiyshfs','mean','out'),
1375 (92,'cgymopmfmz',3,58,'2008-03-24 14:35:07','something','out',3,'2004-10-24 02:38:56','gymopmfmzeijaucj','ymopmfmzei','or',NULL,'that\'s','if','about'),
1376 (78,'something',2,29,NULL,'about','rgtjcrqimcwi',2,NULL,'gtjcrqimcwinecvi','tjcrqimcwi','jcrqim',NULL,'crqimcwinecvidykmbzcs','rqimcwinec','I\'ll'),
1377 (52,'one',0,16,NULL,'is','tgmnlixtiocaurwr',2,'2001-03-13 08:10:45','gmnlixtiocaurwr','ok','mnlixtiocaurwrurjc','2005-04-07 21:25:23','nlixtiocaurwrurjcqcmbfesk','lixtiocaur','was'),
1378 (69,'vznulgad',2,71,'2008-03-22 06:46:56','he','I',3,NULL,'znulgadkvmnzpaij','the','nulg','2008-10-24 08:49:46','ulgadkvmnzpaijrisreoqjseooxrkly','you\'re','about'),
1379 (56,'qi',2,30,'2000-04-16 17:05:02','and','her',0,'2009-11-04 00:38:34','imc','were','back',NULL,'can\'t','that\'s','be'),
1380 (2,'me',3,69,'2008-03-04 21:34:48','yufanlouvznulga','she',0,'2004-12-12 20:01:34','but','ufanlouv','fanlouvzn','2005-07-21 03:13:40','anlouvznulgadkvmnzpaijris','will','was'),
1381 (74,'go',3,24,'2001-12-10 21:01:37','as','nnxzldznlzjreefn',2,'2006-09-25 19:50:35','nxzldznlz','xzldznlzjr','zldznlz','2009-04-21 02:58:02','ldznlzjreefnxwblvmepoukwnoiwmq','dznl','z'),
1382 (64,'why',2,33,NULL,'cdblegxjugbpymzl','dblegxjugbpymzlg',3,NULL,'blegxjugbpymzlgz','are','had',NULL,'legxjugbpymzlgzjxixrgqwmxgyf','egxjugbpym','be'),
1383 (43,'giyshfsuyp',0,4,'2006-04-09 09:29:25','iyshfsuypvwazx','she',1,NULL,'yshfsuypvwazxv','shfsuypvwa','hfsuypvwazxvmidx',NULL,'fsuypvwazxvmidxalztdtgbwv','suypvwa','I\'m'),
1384 (18,'rmieqrexud',3,67,NULL,'mieqrexudwrhjutw','ok',1,'2004-04-24 23:28:36','ieqrexudwrhjutwi','as','eqr',NULL,'qrexudwrhjutwilyufanlou','from','want'),
1385 (8,'good',1,65,NULL,'that\'s','really',2,NULL,'t','will','qldvpqmsncjmvzdljhwltzxnflrfdd','2001-11-25 18:24:30','want','ldvpqmsncj','a'),
1386 (67,'you',2,8,'2002-08-21 18:38:51','would','lztdtgbwvcjraczx',3,'2007-06-28 17:25:57','ztdtgbwvcjraczxg','you','tdtgbwvcjraczx','2003-06-16 05:22:11','here','dtgbwvcjra','who');
1387
1388
1389 ANALYZE TABLE a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z;
1390
1391 ##################################################
1392 ############### Captured queries #################
1393 ##################################################
1394
1395 --enable_query_log
1396 --enable_warnings
1397
1398 ################################################################
1399 ######## Collection of queries returning incorrect ###########
1400 ######## results in first pushed version of WL#7636. ###########
1401 ######## Fixed before release, so no bug# ###########
1402 ################################################################
1403
1404 # Trigger conditions are being evaluated on top of a set
1405 # of 'inner-tables', instead of on the table they are attached to.
1406 # We had code for identifying such triggers, which may disallow
1407 # join pushdown. However it didn't correctly identify 'IS NULL'
1408 # in a trigger. Neither did it handle triggers nested inside
1409 # triggers.
1410 #
1411
1412 let $query=
1413 SELECT STRAIGHT_JOIN
1414 table1.pk, table2.pk, table3.pk
1415 FROM n AS table1
1416 LEFT JOIN w AS table2
1417 LEFT JOIN w AS table3 ON table2.col_varchar_256_unique = table3.col_char_16_unique
1418 ON table1.col_int = table2.col_int_key AND table3.col_int IS NULL;
1419
1420 --replace_regex / \(cost=.*//
1421 eval explain format=tree $query;
1422 --sorted_result
1423 eval $query;
1424
1425
1426
1427 ##############
1428 # The below query has the join-nest structure:
1429 #
1430 # t2 (t3) t1 (t4) (t5) (t6)
1431 #
1432 # There are join-condition dependencies on previous outer joins:
1433 # - t5 depends on the outer joined t3
1434 # - t6 depends on the outer joined t5 (and t1 from upper nest)
1435 #
1436 # These tables upto t5 would result in this tree of pushed
1437 # table joins:
1438 #
1439 # t2
1440 # / | \
1441 # (t3) (t4) t1
1442 # |
1443 # (t5)
1444 #
1445 # When attempting to also push t6 as part of this tree,
1446 # is_outer_nests_referable() incorrectly concluded that t6 could be
1447 # attached as well, and we ended up with the query topology:
1448 #
1449 # t2
1450 # / |
1451 # (t3) (t4)
1452 # |
1453 # t1
1454 # |
1455 # (t5)
1456 # |
1457 # (t6)
1458 #
1459 # Thus we have incorrectly introduced a t1 dependency on the
1460 # outer joined t3. This was due to that the set of outer_nest-table
1461 # referrences being incorrectly set up.
1462 #####################
1463
1464 let $query=
1465 SELECT straight_join
1466 table2.pk, table3.pk, table1.pk, table4.pk, table5.pk, table6.pk
1467 FROM r AS table2
1468 LEFT JOIN c AS table3 ON table2.col_int_unique = table3.col_int_unique
1469 INNER JOIN m AS table1 ON table1.col_int_key = table2.pk
1470 LEFT JOIN r AS table4 ON table2.pk = table4.col_int_key
1471 LEFT JOIN e AS table5 ON table3.col_int_unique = table5.col_int_unique
1472 LEFT JOIN s AS table6 ON table1.col_int = table6.col_int
1473 AND table5.col_int_unique = table6.col_int_unique
1474 where table2.pk between 2 and 3;
1475
1476 --replace_regex / \(cost=.*//
1477 eval explain format=tree $query;
1478 --sorted_result
1479 eval $query;
1480
1481
1482 #####################
1483 # In order to push a firstMatch, the firstMatch-return-table
1484 # need to be the parent of the firstMatch-sj-nest
1485
1486 let $query=
1487 SELECT
1488 table1.pk, table3.pk, table4.pk
1489 FROM e AS table1
1490 JOIN w AS table3
1491 JOIN w AS table4 ON table3.col_int = table4.col_int
1492 AND table3.col_int_key = table4.col_int_key
1493 ON table1.col_int_unique = table3.col_int_key
1494 WHERE table4.col_int IN (
1495 SELECT table2s.col_int AS field3
1496 FROM o AS table1s
1497 LEFT JOIN x AS table2s ON table1s.col_varchar_256_key = table2s.col_varchar_256_unique
1498 ) and table1.pk between 3 and 3;
1499
1500 --replace_regex / \(cost=.*//
1501 eval explain format=tree $query;
1502 --sorted_result
1503 eval $query;
1504
1505
1506 ####################
1507 # FirstMatch elimination can not be specified to SPJ APJ
1508 # if there are unpushed conditions in the semi-join.
1509 # ( ... or unpushes tables which we already checked for)
1510 # The semijoin itself may still be pushed though.
1511
1512 let $query=
1513 SELECT
1514 table1.pk, table2.pk
1515 FROM f AS table1
1516 LEFT JOIN y AS table2 ON table1.col_int NOT IN (1, 9)
1517 WHERE EXISTS (
1518 SELECT table2s.pk, table1s.pk, table3s.pk
1519 FROM r AS table1s
1520 JOIN c AS table2s ON table1s.col_int = table2s.col_int_key
1521 JOIN g AS table3s ON table2s.col_int = table3s.col_int AND # <<- unpushed
1522 table1s.col_int_unique = table3s.col_int_unique
1523 )
1524 and table1.pk < 3;
1525
1526 --replace_regex / \(cost=.*//
1527 eval explain format=tree $query;
1528 --sorted_result
1529 eval $query;
1530
1531
1532 #####################
1533 # There is a limitation in the result processing in SPJ API
1534 # (NdbResultStream::prepareResultSet): In order to determine when
1535 # NULL extended rows should be generate for an outer-joined-nest
1536 # the nest itself has to either be a descendant or a sibling
1537 # of its upper nest. Enforced in code by setting the enforced
1538 # m_ancestors to contain the same m_ancestors as its upper nest.
1539
1540 let $query=
1541 SELECT straight_join
1542 table1.pk, table2.pk, table3.pk, table4.pk
1543 FROM h AS table1
1544 JOIN y AS table2
1545 LEFT JOIN q AS table3
1546 LEFT JOIN k AS table4 ON table3.col_int = table4.pk
1547 ON table2.col_int = table3.col_int AND table2.col_int_unique = table3.col_int_unique
1548 ON table1.col_int_unique = table2.col_int;
1549
1550 --replace_regex / \(cost=.*//
1551 eval explain format=tree $query;
1552 --sorted_result
1553 eval $query;
1554
1555
1556 # Another query, facing similar limitations as above
1557
1558 let $query=
1559 SELECT straight_join
1560 table1.pk, table2.pk, table3.pk, table4.pk, table5.pk, table6.pk
1561 FROM e AS table1
1562 JOIN d as table2 ON table2.col_int_unique = table1.pk
1563 LEFT JOIN m AS table3
1564 LEFT JOIN q AS table4 ON table3.col_int_key = table4.col_int
1565 ON table1.col_int_key = table3.col_int_key
1566 LEFT JOIN s AS table5 ON table3.col_int_unique = table5.col_int
1567 LEFT JOIN t AS table6 ON table4.col_int = table6.col_int
1568 AND table2.col_int_key = table6.col_int_key
1569 AND table5.col_int_unique = table6.col_int_unique
1570 where table1.pk between 1 and 3;
1571
1572 --replace_regex / \(cost=.*//
1573 eval explain format=tree $query;
1574 --sorted_result
1575 eval $query;
1576
1577
1578 # And yet another with similar requirements:
1579
1580 let $query=
1581 SELECT
1582 table1.pk, table2.pk, table3.pk, table4.pk
1583 FROM c AS table1
1584 INNER JOIN f AS table2 ON table1.col_int_unique = table2.col_int
1585 LEFT JOIN p AS table3
1586 LEFT JOIN u AS table4 ON table3.col_int_key = table4.col_int
1587 AND table3.col_int_unique = table4.pk
1588 ON table1.col_int = table3.col_int
1589 AND table2.col_int_key = table3.col_int_key
1590 AND table1.col_int_unique = table3.col_int_unique;
1591
1592 --replace_regex / \(cost=.*//
1593 eval explain format=tree $query;
1594 --sorted_result
1595 eval $query;
1596
1597
1598 #################################################################
1599 ######## Collection of other interesting RQG queries. ###########
1600 ######## Caused problems during development, but not ###########
1601 ######## Related to product bugs as such. ###########
1602 #################################################################
1603
1604
1605 let $query=
1606 SELECT
1607 # NOTE: NO_BNL is a synonym for NO_HASH_JOIN
1608 /*+ JOIN_ORDER(table3,table2,table1,table4,table5) NO_BNL() */
1609 table3.pk, table2.pk, table1.pk, table4.pk, table5.pk
1610 FROM u AS table1
1611 JOIN q AS table2 USE INDEX FOR JOIN(ix1)
1612 JOIN h AS table3 ON table2.col_int = table3.col_int
1613 ON table1.col_int_key = table2.col_int_key
1614 LEFT JOIN n AS table4
1615 LEFT JOIN q AS table5 ON table4.col_int = table5.col_int
1616 ON table2.col_int = table4.col_int AND
1617 table1.col_int_key = table4.col_int_key AND
1618 table2.col_int_unique = table4.col_int_unique
1619 # Limits output somewhat:
1620 where table3.pk between 0 and 1
1621 and table2.pk between 4 and 5;
1622
1623 --replace_regex / \(cost=.*//
1624 eval explain format=tree $query;
1625 --sorted_result
1626 eval $query;
1627
1628
1629 let $query=
1630 SELECT
1631 table1.pk, table2.pk
1632 FROM x AS table1
1633 JOIN y AS table2 ON table1.col_int = table2.col_int
1634 AND table1.col_int_unique = table2.col_int_unique
1635 WHERE table1.pk IN (
1636 SELECT
1637 table1s.pk AS field3
1638 FROM d AS table1s
1639 JOIN m AS table2s ON table1s.pk = table2s.col_int_key
1640 );
1641
1642 --replace_regex / \(cost=.*//
1643 eval explain format=tree $query;
1644 --sorted_result
1645 eval $query;
1646
1647
1648 let $query=
1649 SELECT straight_join
1650 table1.pk, table3.pk, table2.pk, table4.pk
1651 FROM t AS table1
1652 LEFT JOIN (q AS table3
1653 INNER JOIN m AS table2 ON table2.col_int = table3.col_int_key)
1654 LEFT JOIN r AS table4 ON table2.col_int_key = table4.col_int
1655 ON table1.col_int_unique = table3.col_int_key
1656 where table1.pk between 14 and 14;
1657
1658 --replace_regex / \(cost=.*//
1659 eval explain format=tree $query;
1660 --sorted_result
1661 eval $query;
1662
1663
1664 let $query=
1665 SELECT STRAIGHT_JOIN
1666 table1.pk, table2.pk, table3.pk
1667 FROM r AS table1
1668 LEFT JOIN z AS table2
1669 LEFT JOIN f AS table3 ON table2.col_int_key = table3.col_int_unique
1670 ON table1.col_int_unique = table3.col_int_unique;
1671
1672 --replace_regex / \(cost=.*//
1673 eval explain format=tree $query;
1674 --sorted_result
1675 eval $query;
1676
1677
1678 let $query=
1679 SELECT
1680 table2.pk AS field1, table2.col_int_unique AS field2
1681 FROM v AS table1
1682 LEFT JOIN g AS table2
1683 LEFT JOIN u AS table3 ON table2.col_int_unique = table3.col_int_key
1684 ON table1.col_int_key = table2.col_int_unique;
1685
1686 --replace_regex / \(cost=.*//
1687 eval explain format=tree $query;
1688 --sorted_result
1689 eval $query;
1690
1691
1692 let $query=
1693 SELECT
1694 table1.pk, table2.pk, table4.pk, table3.pk
1695 FROM t AS table1
1696 LEFT JOIN f AS table2
1697 INNER JOIN
1698 (r AS table3 inner JOIN i AS table4 ON table3.col_int_key = table4.col_int_key)
1699 ON table2.col_int_unique = table4.col_int
1700 ON table1.col_int = table2.col_int_unique
1701 where table1.pk > 8 and table1.pk < 11;
1702
1703 --replace_regex / \(cost=.*//
1704 eval explain format=tree $query;
1705 --sorted_result
1706 eval $query;
1707
1708
1709 let $query=
1710 SELECT
1711 table1.pk, table2.pk, table4.pk, table3.pk
1712 FROM i AS table1
1713 LEFT JOIN j AS table2
1714 LEFT JOIN d AS table3
1715 JOIN e AS table4 ON table3.col_int_key = table4.col_int_unique
1716 ON table2.col_int_key = table4.col_int_unique
1717 ON table1.col_int_key = table2.col_int_key
1718 where table1.pk > 2 and table1.pk < 5;
1719
1720 --replace_regex / \(cost=.*//
1721 eval explain format=tree $query;
1722 --sorted_result
1723 eval $query;
1724
1725
1726 let $query=
1727 SELECT straight_join
1728 table1.pk, table2.pk, table3.pk, table4.pk
1729 FROM s AS table1
1730 LEFT JOIN t AS table2
1731 LEFT JOIN q AS table3 ON table2.col_int_key = table3.col_int_unique AND table2.col_int_unique = table3.col_int_unique
1732 LEFT JOIN o AS table4 ON table2.pk = table4.col_int
1733 ON table4.col_int IS NULL AND table1.col_int_unique = table2.col_int_key;
1734
1735 --replace_regex / \(cost=.*//
1736 eval explain format=tree $query;
1737 --sorted_result
1738 eval $query;
1739
1740
1741 let $query=
1742 SELECT straight_join
1743 table1.pk, table2.pk, table3.pk
1744 FROM c AS table1
1745 INNER JOIN x AS table2 ON table1.col_int_unique = table2.col_int_unique
1746 LEFT JOIN j AS table3 ON table2.col_int_unique = table3.col_int_key;
1747
1748 --replace_regex / \(cost=.*//
1749 eval explain format=tree $query;
1750 --sorted_result
1751 eval $query;
1752
1753
1754 let $query=
1755 SELECT straight_join
1756 table1.pk, table2.pk, table3.pk
1757 FROM s AS table1
1758 LEFT OUTER JOIN c AS table2 ON table1.col_int = table2.pk
1759 LEFT OUTER JOIN w AS table3 ON table2.col_int = table3.col_int_key;
1760
1761 --replace_regex / \(cost=.*//
1762 eval explain format=tree $query;
1763 --sorted_result
1764 eval $query;
1765
1766
1767 let $query=
1768 SELECT straight_join
1769 table1.pk, table2.pk, table3.pk
1770 FROM r AS table1
1771 LEFT JOIN g AS table2
1772 LEFT JOIN j AS table3 ON table2.col_int_unique = table3.col_int_key
1773 ON table1.pk = table2.col_int_unique
1774 WHERE table1.pk < 3;
1775
1776 --replace_regex / \(cost=.*//
1777 eval explain format=tree $query;
1778 --sorted_result
1779 eval $query;
1780
1781
1782 let $query=
1783 SELECT straight_join
1784 table1.pk, table2.pk, table3.pk
1785 FROM c AS table1
1786 INNER JOIN p AS table2 ON table1.pk = table2.pk
1787 LEFT OUTER JOIN i AS table3 ON table2.col_int_unique = table3.col_int;
1788
1789 --replace_regex / \(cost=.*//
1790 eval explain format=tree $query;
1791 --sorted_result
1792 eval $query;
1793
1794
1795 let $query=
1796 SELECT
1797 table2.col_int_key AS field2
1798 FROM z AS table2
1799 WHERE NOT table2.col_int_unique IN (
1800 SELECT table1s.col_int_key AS field3
1801 FROM f AS table1s
1802 left JOIN u AS table2s ON table2s.col_int IN (6, 6, 7)
1803 WHERE table2.pk = 9 OR table2s.col_int = 1
1804 ) IS TRUE ;
1805
1806 --replace_regex / \(cost=.*//
1807 eval explain format=tree $query;
1808 --sorted_result
1809 eval $query;
1810
1811
1812 # antijoin require entire antijoin-nest to be pushed in order to
1813 # setMatchType(NdbQueryOptions::MatchNullOnly), which enable
1814 # 'Not exists' elimination of matching rows in the SPJ API.
1815
1816 let $query=
1817 SELECT
1818 table1.col_int_key AS field1
1819 FROM t AS table1
1820 WHERE table1.col_int NOT IN (
1821 SELECT table1s.pk AS field2
1822 FROM z AS table1s
1823 JOIN v AS table2s ON table1s.col_int = table2s.col_int AND
1824 table1s.col_int_unique = table2s.col_int_unique
1825 );
1826
1827 --replace_regex / \(cost=.*//
1828 eval explain format=tree $query;
1829 --sorted_result
1830 eval $query;
1831
1832
1833 let $query=
1834 SELECT STRAIGHT_JOIN
1835 table1.pk, table2.pk, table3.pk
1836 FROM b AS table1
1837 LEFT JOIN z AS table2
1838 JOIN z AS table3 ON table2.pk = table3.col_int_key
1839 LEFT JOIN q AS table4
1840 LEFT JOIN b AS table5 ON table4.col_int = table5.col_int_key
1841 ON table2.col_int_key = table5.col_int_unique AND
1842 table2.col_int_unique = table4.col_int
1843 ON table1.col_int_key = table2.col_int_key;
1844
1845 --replace_regex / \(cost=.*//
1846 eval explain format=tree $query;
1847 --sorted_result
1848 eval $query;
1849
1850
1851 let $query=
1852 SELECT
1853 /*+ JOIN_ORDER(table2,table1,table2s,table1s) */
1854 table2.pk, table1.pk
1855 FROM p AS table2
1856 JOIN o AS table1 ON table1.col_int = table2.col_int
1857 WHERE table1.col_int_key IN (
1858 SELECT table2s.col_int_unique AS field3
1859 FROM l AS table1s USE INDEX FOR JOIN(PRIMARY)
1860 JOIN h AS table2s ON table1s.col_int = table2s.col_int
1861 );
1862
1863 --replace_regex / \(cost=.*//
1864 eval explain format=tree $query;
1865 --sorted_result
1866 eval $query;
1867
1868
1869 let $query=
1870 SELECT
1871 table1.pk
1872 FROM i AS table1
1873 WHERE table1.col_int IN (
1874 SELECT table1s.col_int
1875 FROM y AS table1s
1876 JOIN y AS table2s ON table1s.col_int_key = table2s.col_int_key
1877 );
1878
1879 --replace_regex / \(cost=.*//
1880 eval explain format=tree $query;
1881 --sorted_result
1882 eval $query;
1883
1884
1885 let $query=
1886 SELECT
1887 table1.pk, table2.pk
1888 FROM j AS table1
1889 JOIN z AS table2 ON table1.col_int_key = table2.col_int_key
1890 WHERE table1.col_int IN (
1891 SELECT table1s.col_int_key AS field3 FROM u AS table1s
1892 )
1893 and table1.pk in (1,2);
1894
1895 --replace_regex / \(cost=.*//
1896 eval explain format=tree $query;
1897 --sorted_result
1898 eval $query;
1899
1900
1901 let $query=
1902 SELECT
1903 table1.pk, table2.pk
1904 FROM j AS table1
1905 JOIN z AS table2 ON table1.col_int_key = table2.col_int_key
1906 WHERE table1.col_int IN (
1907 SELECT table1s.col_int_key AS field3 FROM u AS table1s
1908 )
1909 and table1.pk in (4,5);
1910
1911 --replace_regex / \(cost=.*//
1912 eval explain format=tree $query;
1913 --sorted_result
1914 eval $query;
1915
1916
1917 let $query=
1918 SELECT
1919 table1.pk, table2.pk
1920 FROM f AS table1
1921 JOIN r AS table2 ON table1.col_int_unique = table2.col_int_key
1922 WHERE table1.col_int IN (SELECT table1s.col_int_key AS field3 FROM w AS table1s);
1923
1924 --replace_regex / \(cost=.*//
1925 eval explain format=tree $query;
1926 --sorted_result
1927 eval $query;
1928
1929
1930 let $query=
1931 SELECT straight_join
1932 table1.pk, table2.pk, table3.pk, table4.pk
1933 FROM j AS table1
1934 LEFT JOIN a AS table2 ON table1.col_int_unique = table2.pk
1935 LEFT JOIN m AS table3
1936 LEFT JOIN o AS table4 ON table3.col_int_key = table4.col_int_key
1937 ON table1.col_int = table3.col_int AND
1938 table1.col_int_key = table3.col_int_key AND
1939 table2.col_int_unique = table3.col_int_unique;
1940
1941 --replace_regex / \(cost=.*//
1942 eval explain format=tree $query;
1943 --sorted_result
1944 eval $query;
1945
1946
1947 let $query=
1948 SELECT
1949 table1.pk, table2.pk
1950 FROM v AS table1
1951 LEFT JOIN o table2 ON table1.pk = table2.pk
1952 WHERE NOT EXISTS (
1953 SELECT *
1954 FROM m AS table2s
1955 WHERE table2s.pk = table2.pk
1956 )
1957 and table1.pk = 11;
1958
1959 --replace_regex / \(cost=.*//
1960 eval explain format=tree $query;
1961 --sorted_result
1962 eval $query;
1963
1964
1965 let $query=
1966 SELECT
1967 table1.pk, table2.pk
1968 FROM v AS table1
1969 left JOIN o AS table2 ON table1.pk = table2.pk
1970 WHERE NOT EXISTS (
1971 SELECT table1.col_int AS field4, table1s.col_char_16_key AS field5
1972 FROM d AS table1s
1973 JOIN m AS table2s ON table1s.col_char_16_key = table2s.col_char_16_key
1974 WHERE table2s.pk = table2.pk
1975 )
1976 and table1.pk = 11;
1977
1978 --replace_regex / \(cost=.*//
1979 eval explain format=tree $query;
1980 --sorted_result
1981 eval $query;
1982
1983
1984 ################################################
1985 #### Added as part of antijoin development #####
1986
1987 let $query=
1988 SELECT
1989 table1.pk, table2.pk
1990 FROM t AS table1
1991 JOIN x AS table2 ON table1.col_int_key = table2.col_int
1992 WHERE NOT EXISTS (
1993 SELECT *
1994 FROM b AS table1s WHERE table1.col_int_key = table1s.col_int_key
1995 ) and table1.pk between 2 and 2;
1996
1997 --replace_regex / \(cost=.*//
1998 eval explain format=tree $query;
1999 --sorted_result
2000 eval $query;
2001
2002
2003 let $query=
2004 SELECT
2005 table1.pk, table2.pk
2006 FROM v AS table1
2007 LEFT JOIN o table2 ON table1.pk = table2.pk
2008 WHERE NOT EXISTS (
2009 SELECT *
2010 FROM m AS table2s
2011 WHERE table2s.pk = table2.pk
2012 )
2013 and table1.pk = 11;
2014
2015 --replace_regex / \(cost=.*//
2016 eval explain format=tree $query;
2017 --sorted_result
2018 eval $query;
2019
2020
2021 let $query=
2022 SELECT
2023 table1.pk, table2.pk
2024 FROM v AS table1
2025 LEFT JOIN o table2 ON table1.pk = table2.pk
2026 WHERE NOT EXISTS (
2027 SELECT *
2028 FROM m AS table2s
2029 WHERE table2s.col_int = table2.pk
2030 )
2031 and table1.pk = 11;
2032
2033 --replace_regex / \(cost=.*//
2034 eval explain format=tree $query;
2035 --sorted_result
2036 eval $query;
2037
2038
2039 let $query=
2040 SELECT
2041 table1.pk, table2.pk
2042 FROM n AS table1
2043 JOIN t AS table2 ON table1.col_int_key = table2.col_int_key
2044 WHERE table1.pk IN (
2045 SELECT table1s.pk AS field3 FROM b AS table1s
2046 );
2047
2048 --replace_regex / \(cost=.*//
2049 eval explain format=tree $query;
2050 --sorted_result
2051 eval $query;
2052
2053
2054 let $query=
2055 SELECT
2056 table1.pk, table2.pk, table3.pk
2057 FROM w AS table1
2058 STRAIGHT_JOIN (
2059 v AS table2 LEFT JOIN i AS table3 ON table2.pk = table3.col_int_key
2060 AND table2.pk = table3.col_int
2061 ) ON table1.col_int_key = table2.pk
2062 AND table1.col_int_unique = table2.pk
2063 WHERE
2064 NOT EXISTS (
2065 SELECT *
2066 FROM u AS table1s
2067 WHERE table3.col_char_16 = table1s.col_char_16
2068 )
2069 and table1.pk between 4 and 6;
2070
2071 --replace_regex / \(cost=.*//
2072 eval explain format=tree $query;
2073 --sorted_result
2074 eval $query;
2075
2076
2077 ####################################################
2078 ## Bug#32354817
2079 ## CRASH IN HA_NDBCLUSTER HANDLER INTERFACE WHEN PREPARING A PUSHED JOIN
2080 ####################################################
2081 let $query=
2082 SELECT
2083 table6.col_varchar_256 AS field1, table3.col_varchar_256 AS field2
2084 FROM
2085 f AS table1
2086 LEFT JOIN a AS table2 ON table1.col_int = table2.col_int_unique
2087 LEFT JOIN r AS table3
2088 JOIN g AS table4 ON table3.col_int = table4.col_int AND
2089 table3.col_int_unique = table4.col_int_unique
2090 ON table3.col_int IN (9)
2091 LEFT JOIN f AS table5
2092 JOIN z AS table6 ON table5.col_int = table6.col_int
2093 JOIN g AS table7 ON table6.col_int_key = table7.pk
2094 LEFT JOIN b AS table8
2095 LEFT JOIN m AS table9 ON (table8.col_int = table9.col_int AND
2096 table8.col_int_key = table9.col_int_key AND
2097 table8.col_int_unique = table9.col_int_unique) IS TRUE
2098 LEFT JOIN h AS table10 ON table8.col_int_key = table10.col_int_key AND
2099 table9.col_int_unique = table10.col_int_unique
2100 ON table6.col_int = table8.col_int AND
2101 table6.col_int_unique = table8.col_int_unique
2102 ON table2.col_int = table6.col_int AND
2103 table2.col_int_unique = table6.col_int_unique;
2104
2105 --replace_regex / \(cost=.*//
2106 eval explain format=tree $query;
2107 --sorted_result
2108 eval $query;
2109
2110
2111 ################################################
2112 #### Added as part of WL#14388 development #####
2113
2114 # Due to ORDER BY on table1, only table2 join table2 is pushed.
2115 # table2 is a eq-ref with table3 having the condition 'table1.col_int = table3.col_int'
2116 # referring the 'const-at-exec' table1. Due to incomplete implementation of 'disable_cache'
2117 # in the table2-EQRefIterator::Read() we cant push the table3 condition above.
2118 #
2119 let $query=
2120 SELECT straight_join
2121 table1.pk, table2.pk, table3.pk,
2122 table1.col_int_unique AS field1, table1.col_varchar_256_unique AS field2
2123 FROM p AS table1
2124 JOIN m AS table2 ON table1.col_int_key = table2.pk
2125 LEFT JOIN h AS table3 ON table1.col_int = table3.col_int AND table2.col_int_unique = table3.col_int_unique
2126 ORDER BY field1,field2;
2127
2128 --replace_regex / \(cost=.*//
2129 eval explain format=tree $query;
2130 --sorted_result
2131 eval $query;
2132
2133
2134 # Query plan will be table1,table3,table2 with 'table3 join table2' pushed,
2135 # and hash joined with table1.
2136 # As table2 condition 'table1.col_int_unique = table2.col_int_unique' refer table1
2137 # 'across' the buffered hash join, that condition should not be pushed.
2138 #
2139 let $query=
2140 SELECT
2141 table1.pk, table2.pk, table3.pk
2142 FROM k AS table1
2143 LEFT JOIN m AS table2 ON table1.col_int_unique = table2.col_int_unique
2144 JOIN q AS table3 ON table2.col_int = table3.col_int AND table1.col_int_unique = table3.col_int_unique;
2145
2146 --replace_regex / \(cost=.*//
2147 eval explain format=tree $query;
2148 --sorted_result
2149 eval $query;
2150
2151
2152 # Another query with condition refering ancestor table prior to EQ-ref join root,
2153 let $query=
2154 SELECT
2155 DISTINCT table2.col_varchar_256_unique AS field1, table1.col_varchar_256_unique AS field2
2156 FROM d AS table1
2157 JOIN d AS table2
2158 JOIN h AS table3
2159 INNER JOIN e AS table4 ON table3.col_int_key = table4.col_int_key OR table3.col_int_unique = table4.col_int_unique
2160 ON table2.col_int_unique = table4.col_int_unique
2161 ON table1.col_int_unique = table2.col_int_unique;
2162
2163 --replace_regex / \(cost=.*//
2164 eval explain format=tree $query;
2165 --sorted_result
2166 eval $query;
2167
2168
2169 let $query=
2170 SELECT
2171 table1.pk, table2.pk
2172 FROM j AS table1
2173 JOIN r AS table2 ON table1.col_int = table2.col_int AND table1.col_int_unique = table2.col_int_unique
2174 WHERE table1.col_int_key IN (SELECT table1s.col_int_key AS field6 FROM z AS table1s);
2175
2176 --replace_regex / \(cost=.*//
2177 eval explain format=tree $query;
2178 --sorted_result
2179 eval $query;
2180
2181
2182 let $query=
2183 SELECT
2184 table2.col_int_unique AS field1, table1.col_int AS field
2185 FROM m AS table1
2186 JOIN x AS table2 ON table1.col_int_key = table2.col_int_key AND table1.col_int_unique = table2.col_int_unique
2187 WHERE table2.col_int_key IN (
2188 SELECT table2s.col_int_key AS field3
2189 FROM z AS table1s
2190 LEFT JOIN t AS table2s
2191 JOIN l AS table3s ON table2s.col_int = table3s.col_int_key
2192 ON table1s.pk = table2s.col_int_unique
2193 WHERE table1.col_int_unique = 4 IS UNKNOWN)
2194 AND table2.col_varchar_10_key = table1.col_varchar_256;
2195
2196 --replace_regex / \(cost=.*//
2197 eval explain format=tree $query;
2198 --sorted_result
2199 eval $query;
2200
2201
2202 # If the pushed condition has outer references, its referred ('used_tables')
2203 # need to be included in set of 'depend_parents' used to calculate and
2204 # check the set of 'm_tables[first_inner].m_ancestors'
2205 # Several such queries below.
2206
2207 let $query=
2208 SELECT
2209 table5.pk, table1.pk, table2.pk, table3.pk, table4.pk
2210 FROM q AS table1
2211 STRAIGHT_JOIN h AS table2 ON table1.col_int_key = table2.col_int_key AND
2212 table1.col_int_unique = table2.col_int_unique
2213 LEFT JOIN u AS table3
2214 STRAIGHT_JOIN x AS table4 ON table3.col_int_key = table4.col_int_key
2215 ON table2.col_int_key = table3.col_int_key AND
2216 table2.col_int_unique = table4.col_int_unique
2217 JOIN f AS table5 ON table2.col_int_key = table5.pk;
2218
2219 --replace_regex / \(cost=.*//
2220 eval explain format=tree $query;
2221 --sorted_result
2222 eval $query;
2223
2224
2225 let $query=
2226 SELECT
2227 table1.pk, table2.pk, table4.pk, table3.pk
2228 FROM n AS table1
2229 JOIN a AS table2 ON table1.col_int = table2.col_int AND table1.col_int_unique = table2.col_int_unique
2230 LEFT OUTER JOIN x AS table3
2231 INNER JOIN m AS table4 ON table3.col_int = table4.pk
2232 ON table2.col_int_key = table3.col_int_unique AND table2.col_int_unique = table3.col_int;
2233
2234 --replace_regex / \(cost=.*//
2235 eval explain format=tree $query;
2236 --sorted_result
2237 eval $query;
2238
2239
2240 let $query=
2241 SELECT
2242 table2.col_varchar_10_key AS field1
2243 FROM p AS table1
2244 INNER JOIN a AS table2
2245 JOIN v AS table3 ON table2.col_int = table3.col_int AND
2246 table2.col_int_unique = table3.col_int_unique
2247 ON table1.col_int = table3.col_int AND
2248 table1.col_int_key = table2.col_int_key AND
2249 table1.col_int_unique = table3.col_int_unique
2250 WHERE
2251 table3.col_int_unique = 7 AND
2252 table3.col_int = 4 OR
2253 NOT table3.col_int_unique = 9 OR
2254 table1.col_varchar_10 = table1.col_varchar_256_unique;
2255
2256 --replace_regex / \(cost=.*//
2257 eval explain format=tree $query;
2258 --sorted_result
2259 eval $query;
2260
2261 #
2262 # Tests which at some stage during development failed with
2263 # an incorrect result in the RQG test.
2264 #
2265
2266 let $query=
2267 SELECT
2268 table1.pk, table2.pk, table3.pk
2269 FROM i AS table1
2270 LEFT JOIN z AS table2 ON table1.col_int_key = table2.col_int_key AND
2271 table1.col_int_unique = table2.col_int_unique
2272 LEFT JOIN m AS table3 ON table2.col_int_key = table3.col_int_key;
2273
2274 --replace_regex / \(cost=.*//
2275 eval explain format=tree $query;
2276 --sorted_result
2277 eval $query;
2278
2279
2280 let $query=
2281 SELECT
2282 table1.pk, table3.pk, table2.pk, table5.pk, table4.pk, table6.pk
2283 FROM f AS table1
2284 LEFT JOIN ( j AS table3
2285 straight_JOIN x AS table2 ON table2.col_int_key = table3.col_int_key AND
2286 table2.col_int_unique = table3.col_int_unique)
2287 LEFT JOIN ((d AS table4
2288 straight_JOIN b AS table5 ON table4.pk = table5.col_int_unique)
2289 LEFT JOIN x AS table6 ON table5.col_int_unique = table6.col_int)
2290 ON table2.col_int_key = table5.col_int_unique AND
2291 table2.col_int_unique = table5.col_int_key
2292 ON table1.pk = table3.col_int_unique;
2293
2294 --replace_regex / \(cost=.*//
2295 eval explain format=tree $query;
2296 --sorted_result
2297 eval $query;
2298
2299
2300 let $query=
2301 SELECT
2302 table1.pk, table3.pk, table2.pk, table5.pk, table4.pk, table6.pk
2303 FROM f AS table1
2304 LEFT JOIN ( j AS table3
2305 straight_JOIN x AS table2 ON table2.col_int_key = table3.col_int_key AND
2306 table2.col_int_unique = table3.col_int_unique)
2307 LEFT JOIN (b AS table5
2308 JOIN d AS table4 ON table4.pk = table5.col_int_unique)
2309 LEFT JOIN x AS table6 ON table5.col_int_unique = table6.col_int
2310 ON table2.col_int_key = table5.col_int_unique AND
2311 table2.col_int_unique = table5.col_int_key
2312 ON table1.pk = table3.col_int_unique;
2313
2314 --replace_regex / \(cost=.*//
2315 eval explain format=tree $query;
2316 --sorted_result
2317 eval $query;
2318
2319
2320 let $query=
2321 SELECT
2322 table1.pk, table2.pk, table3.pk, table4.pk, table5.pk
2323 FROM
2324 (b AS table1
2325 JOIN b AS table2 ON table1.col_int_key = table2.col_int_unique AND
2326 table1.col_int_unique = table2.col_int_key)
2327 LEFT JOIN
2328 ((c AS table3 JOIN q AS table4 ON table3.col_int_key = table4.pk)
2329 JOIN i AS table5 ON table3.col_int_unique = table5.col_int_key
2330 )
2331 ON table2.col_int = table4.col_int AND
2332 table2.col_int_key = table5.col_int_key AND
2333 table1.col_int_unique = table3.col_int_unique;
2334
2335 --replace_regex / \(cost=.*//
2336 eval explain format=tree $query;
2337 --sorted_result
2338 eval $query;
2339
2340 #####################
2341 # Test for pushing a AT_MULTI_UNIQUE_KEY as root
2342 # AT_MULTI_UNIQUE_KEY is a MRR on a UNIQUE KEY ... USING HASH
2343 let $query=
2344 SELECT table1.pk, table2.pk
2345 FROM t AS table1
2346 JOIN b AS table2 on table2.pk = table1.pk
2347 WHERE table1.col_int IN (8,7) AND
2348 table1.col_int_unique = 4;
2349
2350 --replace_regex / \(cost=.*//
2351 eval explain format=tree $query;
2352 --sorted_result
2353 eval $query;
2354
2355
2356 ############################################################
2357 #### Added as part of WL-14370, AccessPath integration #####
2358
2359 # Test ANTI-join with FILTER condition 'table3.col_int is null'
2360 let $query=
2361 SELECT
2362 table1.pk, table2.pk, table3.pk
2363 FROM c AS table1
2364 JOIN g AS table2
2365 LEFT JOIN e AS table3 ON table2.col_int_key = table3.pk AND table2.col_int_unique = table3.col_int_unique
2366 ON table3.col_int IS NULL;
2367
2368 --replace_regex / \(cost=.*//
2369 eval explain format=tree $query;
2370 --sorted_result
2371 eval $query;
2372
2373
2374 # Test hash-join 'use_join_cache' logic across hash buckets
2375 let $query=
2376 SELECT DISTINCT
2377 table1.pk, table2.pk, table3.pk, table4.pk
2378 FROM a AS table1
2379 LEFT JOIN d AS table2
2380 LEFT JOIN r AS table3 ON table2.col_int IS NULL
2381 ON table1.col_int_key = table2.col_int AND
2382 table1.col_int_unique = table2.col_int
2383 LEFT JOIN q AS table4 ON table3.col_int = table4.col_int AND
2384 table2.col_int_key = table4.col_int_key AND
2385 table2.col_int_unique = table4.col_int_unique;
2386
2387 --replace_regex / \(cost=.*//
2388 eval explain format=tree $query;
2389 --sorted_result
2390 eval $query;
2391
2392
2393 # Antijoin between to inner joins incorrectly identified
2394 # the inner joined tables as an antijoin'ed as well.
2395 let $query=
2396 SELECT table1.pk, table2.pk
2397 FROM p AS table1
2398 JOIN d AS table2 ON table1.col_int_unique = table2.pk
2399 WHERE NOT EXISTS (
2400 SELECT table1.col_varchar_10_unique
2401 FROM k AS table1s JOIN c AS table2s ON table1s.pk = table2s.pk
2402 );
2403
2404 --replace_regex / \(cost=.*//
2405 eval explain format=tree $query;
2406 --sorted_result
2407 eval $query;
2408
2409
2410 # A (Having-)FILTER can be placed on top of an INNER-join as well
2411 # (Not only on OUTER joins as the more common case)
2412 let $query=
2413 SELECT DISTINCT
2414 table1.pk AS field1
2415 FROM y AS table1
2416 JOIN d AS table2 ON table1.col_int_key = table2.col_int_unique
2417 JOIN y AS table3 ON table1.col_int_key = table3.col_int_unique
2418 WHERE table2.pk < table2.col_int_key AND NOT table2.col_int = 5
2419 HAVING field1 <= 2;
2420
2421 --replace_regex / \(cost=.*//
2422 eval explain format=tree $query;
2423 --sorted_result
2424 eval $query;
2425
2426
2427 # Sets a FILTER on a 'Left hash join'
2428 let $query=
2429 SELECT DISTINCT
2430 table2.col_int_key AS field1, table2.col_int AS field2, table2.col_int_key AS field3
2431 FROM t AS table1
2432 LEFT JOIN z AS table2 ON table1.pk = table2.col_int
2433 JOIN c AS table3 ON NOT (table1.col_int_key = table3.col_int_key AND table1.col_int_unique = table3.col_int_unique)
2434 WHERE table2.pk = table3.pk OR table3.col_int BETWEEN 3 AND 3+3
2435 HAVING field1 != 6;
2436
2437 --replace_regex / \(cost=.*//
2438 eval explain format=tree $query;
2439 --sorted_result
2440 eval $query;
2441
2442
2443 # Take care to update 'last_table_in-nest' when there is a
2444 # Hash-bucked filled before returning to the upper-inner-nest.
2445 # Which might have a filter, which failed on the
2446 # 'assert(nest_ctx->m_first_inner == m_table_accesses.size());'
2447 let $query=
2448 SELECT
2449 /*+ JOIN_ORDER(table2s@subq1, table1s@subq1, table2, table1, table1s@subq2, table2s@subq2)
2450 SEMIJOIN(@subq1 MATERIALIZATION)
2451 */
2452 table1.col_varchar_10_unique AS field1, table1.col_char_16 AS field2
2453 FROM e AS table1
2454 LEFT OUTER JOIN c AS table2 ON table1.col_int_key = table2.col_int_key AND
2455 table1.col_int_unique = table2.col_int_unique
2456 WHERE table1.col_varchar_256 IN (
2457 SELECT /*+ QB_NAME(subq1)*/ table2s.col_varchar_10 AS field3
2458 FROM (j AS table1s
2459 JOIN d AS table2s ON table1s.col_int_key = table2s.col_int_key)
2460 )
2461 AND table2.col_varchar_10_unique = ANY (
2462 SELECT /*+ QB_NAME(subq2)*/ DISTINCT table1s.col_varchar_10 AS field4
2463 FROM e AS table1s
2464 JOIN u AS table2s ON table1s.col_int = table2s.col_int AND
2465 table1s.col_int_unique = table2s.col_int_unique
2466 )
2467 AND table1.col_int_unique <> 2;
2468
2469 --replace_regex / \(cost=.*//
2470 eval explain format=tree $query;
2471 --sorted_result
2472 eval $query;
2473
2474
2475 # A 'LIMIT 1' should not be propogated through the ORDER BY and
2476 # cause an INNER JOIN to be treated like a firstMatch SEMI join:
2477 let $query=
2478 SELECT
2479 table2.col_int AS field1
2480 FROM j AS table1
2481 INNER JOIN v AS table2 ON table1.pk = table2.col_int_key
2482 ORDER BY field1 LIMIT 1;
2483
2484 --replace_regex / \(cost=.*//
2485 eval explain format=tree $query;
2486 --sorted_result
2487 eval $query;
2488
2489
2490 # A specific HASH_JOIN AccessPath causing problems:
2491 let $query=
2492 SELECT
2493 table6.col_int AS field1, table6.col_varchar_10_key AS field2
2494 FROM f AS table1
2495 JOIN q AS table2 ON table1.col_int_key = table2.col_int_key AND table1.col_int_unique = table2.col_int_unique
2496 JOIN u AS table3 ON table1.col_int_key = table3.pk AND table2.col_int_unique = table3.pk
2497 JOIN w AS table4 ON table3.col_int_unique = table4.col_int_key
2498 LEFT JOIN b AS table5 ON table3.col_int IN (5)
2499 JOIN d AS table6 ON table4.col_int_key = table6.col_int_key;
2500
2501 --replace_regex / \(cost=.*//
2502 eval explain format=tree $query;
2503 --sorted_result
2504 eval $query;
2505
2506
2507 # A LIMIT 1 may cause an extra SEMI-Join_nest to be created inside
2508 # an already existing SEMI-Join_nest. Do we handle?
2509 let $query=
2510 SELECT
2511 table2.col_int AS field1
2512 FROM q AS table1
2513 JOIN i AS table2 ON table1.pk = table2.col_int_key AND table1.col_int IN (5)
2514 WHERE 'vp' = ANY (
2515 SELECT DISTINCT table2.col_varchar_10 AS field2
2516 FROM b AS table1s
2517 LEFT JOIN w AS table2s ON table1s.col_int = table2s.col_int
2518 )
2519 HAVING field1 <= 3
2520 ORDER BY field1 LIMIT 1;
2521
2522 --replace_regex / \(cost=.*//
2523 eval explain format=tree $query;
2524 --sorted_result
2525 eval $query;
2526
2527
2528 # Test case for a join push being rejected due to a
2529 # too strict ::uses_join_cache() test. Fixed with the new
2530 # ::uses_join_buffer(other) method.
2531 let $query=
2532 SELECT DISTINCT
2533 table5.col_varchar_256 AS field1, table2.col_varchar_10_key AS field2, table5.col_int_key AS field3
2534 FROM x AS table1
2535 JOIN p AS table2 ON table2.col_int IN (5,9)
2536 JOIN j AS table3 ON table2.pk = table3.col_int_unique
2537 LEFT JOIN n AS table4
2538 LEFT JOIN s AS table5 ON table4.col_int = table5.col_int
2539 AND table4.col_int_unique = table5.col_int_unique
2540 ON table1.col_int_unique = table4.col_int_unique
2541 HAVING field1 != 6 OR field3 < 6;
2542
2543 --replace_regex / \(cost=.*//
2544 eval explain format=tree $query;
2545 --sorted_result
2546 eval $query;
2547
2548
2549 # Test case where uses_join_buffer(other) correctly reject push
2550 # During development we asserted that the stricter uses_join_cache()
2551 # rejected query this as well.
2552 # OJA TODO: Unsure if query actually does as claimed above ...
2553 let $query=
2554 SELECT
2555 /*+ JOIN_ORDER(table6,table5,table3,table4,table7,table2,table1,table8) */
2556 table3.col_varchar_10 AS field1, 5 + (CHAR_LENGTH(table7.col_varchar_256_key)) AS field2
2557 FROM k AS table1
2558 JOIN x AS table2 ON table1.col_int_unique = table2.col_int_unique
2559 LEFT JOIN y AS table3
2560 LEFT JOIN m AS table4 ON table3.col_int_key = table4.col_int_key
2561 AND table3.col_int_unique = table4.col_int_unique
2562 LEFT JOIN h AS table5
2563 JOIN c AS table6 ON table5.pk = table6.col_int_key
2564 ON table3.col_int = table5.col_int AND table4.col_int_unique = table6.col_int_unique
2565 LEFT JOIN c AS table7 USE INDEX FOR JOIN(ix1)
2566 ON table3.col_int_key = table7.col_int_key
2567 AND table5.col_int_unique = table7.col_int_unique
2568 ON table2.col_int_key = table5.col_int_unique
2569 JOIN z AS table8 ON table3.pk = table8.col_int_key;
2570
2571
2572 --replace_regex / \(cost=.*//
2573 eval explain format=tree $query;
2574 --sorted_result
2575 eval $query;
2576
2577
2578 # Test case where potential root of pushed join is in a
2579 # semi-join-nest, while the to-be-pushed child is not.
2580 let $query=
2581 SELECT STRAIGHT_JOIN
2582 table1.col_int AS field1, table1.col_int_key AS field2
2583 FROM a AS table1 WHERE EXISTS (
2584 SELECT table1s.col_varchar_256_unique AS field3, table2s.col_char_16_key AS field4
2585 FROM f AS table1s
2586 LEFT JOIN g AS table2s ON table1s.col_int_unique = table2s.col_int_key
2587 GROUP BY field3, field4)
2588 HAVING field1 = 9
2589 ORDER BY field2,field1;
2590
2591 --replace_regex / \(cost=.*//
2592 eval explain format=tree $query;
2593 --sorted_result
2594 eval $query;
2595
2596 # Semi-join nest of table1s..table3s had table3s in an
2597 # other-nest within the semijoin-nest with table1s and table2s.
2598 # When returning from the table3s outer-nest we failed to correctly
2599 # set up the sj_nest we returned to (fix in ha_ndbcluster_push.cc)
2600 let $query=
2601 SELECT DISTINCT
2602 table2.col_char_16_unique AS field1
2603 FROM y AS table1
2604 JOIN m AS table2 ON table1.col_int_unique = table2.col_int_key
2605 LEFT JOIN h AS table3 ON table1.col_int = table3.col_int
2606 AND table1.col_int_unique = table3.col_int_unique
2607 WHERE 'sgxf' != ANY (
2608 SELECT 'ls' AS field2
2609 FROM r AS table1s
2610 JOIN c AS table2s ON table1s.col_int = table2s.col_int
2611 LEFT JOIN x AS table3s ON table2s.col_varchar_10_key = table3s.col_varchar_256_unique
2612 WHERE table3.col_int_unique <> 6)
2613 HAVING field1 >= 7 AND field1 = 4;
2614
2615 --replace_regex / \(cost=.*//
2616 eval explain format=tree $query;
2617 --sorted_result
2618 eval $query;
2619
2620 # Another test case also testing pushing withing a semijoin
2621 # sub nest
2622 let $query=
2623 SELECT
2624 'gscm' AS field1, table2.col_char_16 AS field2
2625 FROM c AS table1
2626 LEFT JOIN x AS table2 ON table1.col_int_unique = table2.col_int_key
2627 LEFT JOIN m AS table3 ON table2.col_int = table3.pk
2628 WHERE NOT table1.pk = 5
2629 AND 144 < ALL (
2630 SELECT 3 AS field3
2631 FROM g AS table1s
2632 JOIN n AS table2s
2633 LEFT JOIN c AS table3s ON table2s.col_int = table3s.col_int_key
2634 ON table1s.col_int_key = table2s.col_int
2635 WHERE NOT table3.col_int_key BETWEEN 2 AND 2+3)
2636 ORDER BY field1, field1;
2637
2638 --replace_regex / \(cost=.*//
2639 eval explain format=tree $query;
2640 --sorted_result
2641 eval $query;
2642
2643
2644 # Do not allow 'Item_equal' to be replaced across a Query_scope.
2645 let $query=
2646 SELECT
2647 table2.col_char_16_unique AS field1, table3.col_int_key AS field2
2648 FROM t AS table1
2649 LEFT JOIN n AS table2
2650 JOIN l AS table3 ON table2.col_int_key = table3.col_int_unique
2651 ON table1.col_int_unique = table3.col_int_unique
2652 WHERE table2.col_int = table2.col_int ;
2653
2654 --replace_regex / \(cost=.*//
2655 eval explain format=tree $query;
2656 --sorted_result
2657 eval $query;
2658
2659
2660 # SEMI-nest containing an embedded OUTER-nest (table3s)
2661 # Even if table3s is inside a non-SEMI nest, it should
2662 # still count as a SEMI-join (firstMatch'ed tables) as it is
2663 # embedded within a SEMI-join.
2664 let $query=
2665 SELECT STRAIGHT_JOIN
2666 table2.col_int_unique AS field1, table1.col_varchar_10 AS field2, table2.col_varchar_256_unique AS field3
2667 FROM (s AS table2
2668 JOIN w AS table3 ON table2.col_int_key = table3.pk)
2669 JOIN z AS table1 ON table1.pk = table3.col_int_unique
2670 WHERE EXISTS (
2671 SELECT STRAIGHT_JOIN *
2672 FROM k AS table1s
2673 JOIN l AS table2s ON table1s.col_int = table2s.col_int
2674 AND table1s.col_int_unique = table2s.col_int_unique
2675 LEFT JOIN h AS table3s ON table1s.col_int_key = table3s.col_int_key
2676 AND table1s.col_int_unique = table3s.col_int_unique
2677 );
2678
2679 --replace_regex / \(cost=.*//
2680 eval explain format=tree $query;
2681 --sorted_result
2682 eval $query;
2683
2684
2685 # Nested SEMI joins:
2686 # Old QEP_TAB based integration didn't represent SEMI joins as nested,
2687 # AccessPath does!
2688 # (Or actually, we add SEMI-nest where limit_1 was added to AccessPath
2689 let $query=
2690 SELECT STRAIGHT_JOIN
2691 table1.pk
2692 FROM s AS table1
2693 WHERE 'xyz' IN (
2694 SELECT table1.col_varchar_10 AS field4
2695 FROM i AS table1s
2696 JOIN c AS table2s ON table1s.col_int_key = table2s.col_int_unique
2697 WHERE EXISTS (
2698 SELECT *
2699 FROM s AS table1ss
2700 WHERE table1s.col_int_key = 5
2701 )
2702 );
2703
2704 --replace_regex / \(cost=.*//
2705 eval explain format=tree $query;
2706 --sorted_result
2707 eval $query;
2708
2709
2710 # Test case for AccessPath::REMOVE_DUPLICATES instead of
2711 # representing it as a SEMI-join nest. ::construct() will
2712 # 'revert' this logic from the optimizer and insert a SEMI-nest
2713 # around the REMOVE_DUPLICATES branch
2714 let $query=
2715 SELECT
2716 table2.col_int_key
2717 FROM h AS table1
2718 JOIN s AS table2 ON table1.col_int_unique = table2.col_int_key
2719 WHERE table1.pk IN (
2720 SELECT /*+ SEMIJOIN(LOOSESCAN)*/ table2s.col_int_key
2721 FROM p AS table1s
2722 LEFT JOIN l AS table2s ON table1s.pk = table2s.col_int
2723 WHERE table2s.col_int = 8
2724 );
2725
2726 --replace_regex / \(cost=.*//
2727 eval explain format=tree $query;
2728 --sorted_result
2729 eval $query;
2730
2731
2732 # Added as part of investigating bug#34231798.:
2733 #
2734 # Above query slightly modified to avoid empty result set, still same plan:
2735 # -> Incorrect result if table2 is pushed as child of the
2736 # REMOVE_DUPLICATES_ON_INDEX table2s
2737 #
2738 let $query=
2739 SELECT
2740 table2.col_int_key
2741 FROM h AS table1
2742 JOIN s AS table2 ON table1.col_int_unique = table2.col_int_key
2743 WHERE table1.col_int_unique IN (
2744 SELECT /*+ SEMIJOIN(LOOSESCAN)*/ table2s.col_int_key
2745 FROM p AS table1s
2746 LEFT JOIN l AS table2s ON table1s.pk = table2s.col_int
2747 WHERE table2s.col_int = 1
2748 );
2749
2750 --replace_regex / \(cost=.*//
2751 eval explain format=tree $query;
2752 --sorted_result
2753 eval $query;
2754
2755
2756 # Single table in exist-subqry represented with a limit_1 in
2757 # the AccessPath -> An extra semijoin-nest added by our
2758 # 'construct' in the handler integration
2759 let $query=
2760 SELECT DISTINCT
2761 table1.col_int AS field1, table2.col_char_16_key AS field2
2762 FROM a AS table1
2763 LEFT JOIN n AS table2 ON table1.col_int = table2.col_int
2764 WHERE EXISTS (SELECT * FROM i AS table1s)
2765 AND table1.col_int_key = 9;
2766
2767 --replace_regex / \(cost=.*//
2768 eval explain format=tree $query;
2769 --sorted_result
2770 eval $query;
2771
2772
2773 # A AccessPath::MATERIALIZE encapsulated in a LIMIT 1
2774 # Let the 'limit 1' -> semijoin nest conversion also take
2775 # effect inside the MATERIALIZE
2776 let $query=
2777 SELECT DISTINCT
2778 4 AS field1
2779 FROM f AS table1
2780 LEFT JOIN p AS table2 ON table1.col_int IS NULL;
2781
2782 --replace_regex / \(cost=.*//
2783 eval explain format=tree $query;
2784 --sorted_result
2785 eval $query;
2786
2787
2788 # AccessPath for distinct-subquery has a LIMIT 1 node.
2789 # That triggers the SEMI-nest/firstMatch conversion.
2790 let $query=
2791 SELECT table3.col_int_key AS field1
2792 FROM k AS table1
2793 LEFT JOIN w AS table2
2794 LEFT JOIN v AS table3 ON table2.col_int_unique = table3.col_int_key
2795 ON table1.col_int_unique = table3.col_int_unique
2796 WHERE table2.col_int = ALL (
2797 SELECT DISTINCT table1s.pk
2798 FROM w AS table1s JOIN i AS table2s ON table1s.col_int_key = table2s.pk
2799 HAVING table1s.pk = 6
2800 );
2801
2802 --replace_regex / \(cost=.*//
2803 eval explain format=tree $query;
2804 --sorted_result
2805 eval $query;
2806
2807 # Test case where 'Multi-range index lookup on table3'
2808 # refers no key values from the table2 'Batch input rows'
2809 # That could result in table3 becomming a child in a table1-table3
2810 # pushed join, if not explicitely checked for.
2811 # (Using BKA access here really does not make sense,
2812 # but that is on the optimizer)
2813
2814 let $query=
2815 SELECT STRAIGHT_JOIN
2816 table1.pk, table2.pk, table3.pk
2817 FROM h AS table1
2818 LEFT JOIN v AS table2
2819 JOIN t AS table3 ON table2.col_int_key = table3.pk
2820 AND table2.col_int_unique = table3.col_int
2821 ON table1.col_int = table3.col_int
2822 AND table1.col_int_key = table2.col_int_key;
2823
2824 SET optimizer_switch='batched_key_access=on';
2825
2826 --replace_regex / \(cost=.*//
2827 eval explain format=tree $query;
2828 --sorted_result
2829 eval $query;
2830
2831 SET optimizer_switch='batched_key_access=default';
2832
2833 # Filters on top of a materialized subquery should not be
2834 # pushed down as conditions inside the materialize table.
2835 let $query=
2836 SELECT
2837 table1.pk
2838 FROM u AS table1 WHERE NOT EXISTS (
2839 SELECT /*+ SEMIJOIN(MATERIALIZATION)*/ *
2840 FROM p AS table1s WHERE table1.pk = 9
2841 );
2842
2843 --replace_regex / \(cost=.*//
2844 eval explain format=tree $query;
2845 --sorted_result
2846 eval $query;
2847
2848
2849 # A materialized subquery will evaluate the subquert and store
2850 # the result into a temporary table, possibly creating an index
2851 # and other structures on that temporary table. Thus we cant allow
2852 # a pushed join across such a materialization.
2853 # (Note the subquery WHERE 'table2s.col_int_key = table2.col_int'
2854 # which suggest that table2s could be a child of table2)
2855 let $query=
2856 SELECT
2857 table1.pk, table2.pk
2858 FROM x AS table1
2859 LEFT JOIN b AS table2 ON table1.pk = table2.col_int_unique
2860 WHERE EXISTS (
2861 SELECT /*+ SEMIJOIN(MATERIALIZATION)*/ *
2862 FROM r AS table1s
2863 JOIN e AS table2s ON table1s.pk = table2s.col_int_key
2864 WHERE table2s.col_int_key = table2.col_int
2865 );
2866
2867 --replace_regex / \(cost=.*//
2868 eval explain format=tree $query;
2869 --sorted_result
2870 eval $query;
2871
2872
2873 # Don't carry the 'limit_1', added as part of 'distinct' AccessPath,
2874 # through to the materialized subquery. (-> Too few rows in the
2875 # materialized temp-table.)
2876 # Since Bug#35842412 query plan will no longer contain a 'limit_1' part.
2877
2878 let $query=
2879 SELECT DISTINCT
2880 table1.pk
2881 FROM y AS table1
2882 WHERE table1.col_int_unique IN (
2883 SELECT /*+ SEMIJOIN(MATERIALIZATION)*/ table2s.pk AS field3
2884 FROM o AS table1s
2885 JOIN i AS table2s ON table1s.col_int_unique = table2s.col_int
2886 WHERE table1s.col_int_unique BETWEEN 2 AND 10)
2887 ;
2888
2889 --replace_regex / \(cost=.*//
2890 eval explain format=tree $query;
2891 --sorted_result
2892 eval $query;
2893
2894
2895 # Test case for 'm_has_pending_cond.is_overlapping(nest)' (1b,1c)
2896 # in ndb_pushed_builder_ctx::is_pushable_within_nest()
2897 let $query=
2898 SELECT
2899 table1.pk, table2.pk, table3.pk, table4.pk
2900 #table3.col_int AS field1, table3.col_int_key AS field2
2901 FROM r AS table1
2902 JOIN s AS table2 ON table1.pk = table2.col_int_unique
2903 LEFT JOIN k AS table3
2904 LEFT JOIN e AS table4 ON table3.col_int_key = table4.col_int_unique
2905 ON table1.col_int_key = table4.col_int_unique AND
2906 table1.col_int_unique = table4.col_int_unique
2907 WHERE table2.col_int_key <> 5;
2908
2909 --replace_regex / \(cost=.*//
2910 eval explain format=tree $query;
2911 --sorted_result
2912 eval $query;
2913
2914
2915 # Test case for rejecting push if there is another index scan
2916 # inbetween a semi-join/firstmatch/distinct child and the parent
2917 # it is referring.
2918 let $query=
2919 SELECT DISTINCT
2920 table3.col_int_key AS field1, table1.col_int AS field2, table1.col_int AS field3
2921 FROM t AS table1
2922 JOIN u AS table2 ON table1.col_int_key = table2.col_int_key
2923 LEFT JOIN i AS table3 ON table1.col_int = table3.col_int_key;
2924
2925 --replace_regex / \(cost=.*//
2926 eval explain format=tree $query;
2927 --sorted_result
2928 eval $query;
2929
2930
2931 # Test case for Item_equal substitute and semi-join nest.
2932 # Query will produce the plan: '(Sort(t1) SJ (t1s J t2s)) J t2'
2933 # where a substitute could end up making t2 a child of one of the
2934 # SJ'ed tables, instead of the referred t1 table (which can not
2935 # be pushed due to 'sort').
2936 # Correct decision will be to reject push of t2.
2937 #
2938 let $query=
2939 SELECT
2940 table1.pk, table2.pk, table1.col_varchar_10_unique AS field3
2941 FROM l AS table1
2942 JOIN j AS table2 ON table1.pk = table2.col_int_key
2943 WHERE table1.pk IN (
2944 SELECT table1s.col_int
2945 FROM i AS table1s
2946 JOIN z AS table2s ON table1s.col_int = table2s.col_int_key
2947 ) ORDER BY field3;
2948
2949 --replace_regex / \(cost=.*//
2950 eval explain format=tree $query;
2951 --sorted_result
2952 eval $query;
2953
2954
2955 # Optimizer generated a AccessPath plan with a synthesised 'limit 1'
2956 # on table 1. aka:
2957 # distinct( join( join(t2,t3,t4), limit_1(t1)))
2958 # As t1 was not joined with t2, not its immediate predecessor
2959 # t4, we can not specify 'FirstMatch' in the SPJ plan.
2960 let $query=
2961 SELECT
2962 DISTINCT table4.col_int_unique
2963 FROM u AS table1
2964 JOIN v AS table2 ON table1.col_int_key = table2.col_int_unique
2965 LEFT JOIN w AS table3 ON table2.col_varchar_256_unique = table3.col_varchar_256_unique
2966 JOIN c AS table4 ON table2.col_int_unique = table4.col_int;
2967
2968 --replace_regex / \(cost=.*//
2969 eval explain format=tree $query;
2970 --sorted_result
2971 eval $query;
2972
2973
2974 # Test case where multiple semi-join nest will be nested (inside each other)
2975 # with the new AccessPath based query plan: The 'Select distinct..' will
2976 # be optimized with a 'Limit 1' operation, which in turn is nested inside the
2977 # SEMI-join from the IN-subqry. The 'Limit 1' will in turn need to be handled
2978 # as a semi-join itself in order to be pushed (and avoid batch-repeat duplicates)
2979 let $query=
2980 SELECT DISTINCT
2981 table3.col_char_16_unique AS field1, table2.col_varchar_256_unique AS field2
2982 FROM w AS table1
2983 LEFT JOIN c AS table2
2984 JOIN d AS table3 ON table2.pk = table3.pk
2985 ON table1.col_int_key = table2.col_int AND table1.col_int_unique = table2.col_int
2986 JOIN r AS table4 ON table3.col_int IS NULL
2987 WHERE table4.col_varchar_10_key IN (
2988 SELECT
2989 table2.col_varchar_256 AS field3
2990 FROM t AS table1s
2991 LEFT JOIN i AS table2s
2992 LEFT JOIN b AS table3s ON table2s.col_int = table3s.col_int AND table2s.col_int_unique = table3s.col_int_unique
2993 ON table1s.col_varchar_10_key = table2s.col_varchar_256_unique
2994 WHERE table3s.pk = table3.col_int_key);
2995
2996 --replace_regex / \(cost=.*//
2997 eval explain format=tree $query;
2998 --sorted_result
2999 eval $query;
3000
3001
3002 # Test that m_const_scope does not include buffered 'out of scope'
3003 # tables.
3004 # table1 will be hash joined with table3, with table3 in the
3005 # hash bucket. condition 'table1.pk = table3.pk' is a candidate
3006 # to be pushed. However pushing it will refer 'unstable' t3 rows
3007 # in the hash bucket
3008 let $query=
3009 SELECT table1.col_varchar_256_unique AS field1
3010 FROM o AS table1
3011 JOIN x AS table2 ON table1.col_int_key = table2.pk
3012 JOIN n AS table3 ON table1.pk = table3.pk
3013 GROUP BY field1;
3014
3015 --replace_regex / \(cost=.*//
3016 eval explain format=tree $query;
3017 --sorted_result
3018 eval $query;
3019
3020
3021 # Test use AccessPath::NESTED_LOOP_SEMIJOIN_WITH_DUPLICATE_REMOVAL:
3022 # This execution strategy seems to be very rarely used.
3023 # Believe this is the only test case we managed to dig out for that.
3024 #
3025 # Should explain as: 'Nested loop semijoin with duplicate removal ..'
3026 let $query=
3027 SELECT table1.pk, table2.pk
3028 FROM x AS table1
3029 JOIN b AS table2 ON table1.col_int_key = table2.pk
3030 WHERE #table2.col_int_unique != 7 AND
3031 table1.col_int_key IN (
3032 SELECT
3033 table1s.col_int AS field2
3034 FROM f AS table1s
3035 JOIN g AS table2s ON table1s.col_int_unique = table2s.col_int_unique
3036 );
3037
3038 --replace_regex / \(cost=.*//
3039 eval explain format=tree $query;
3040 --sorted_result
3041 eval $query;
3042
3043
3044 # Above query slightly modified, still same plan:
3045 #
3046 # Added as part of investigating bug#34231798. Added in order to prove
3047 # that NESTED_LOOP_SEMIJOIN_WITH_DUPLICATE_REMOVAL need a double set
3048 # of semi_join nests to be set up in ndb_pushed_builder_ctx::construct()
3049 #
3050 # Introduced expression '<column>+0' in join condition for table2s to
3051 # make it unpushable. That should also cause the other semi-joined table1s
3052 # to be rejected as scanned tables need all tables in the nest
3053 # to be pushed.
3054 let $query=
3055 SELECT table1.pk, table2.pk
3056 FROM x AS table1
3057 JOIN b AS table2 ON table1.col_int_key = table2.pk
3058 WHERE #table2.col_int_unique != 7 AND
3059 table1.col_int_key IN (
3060 SELECT
3061 table1s.col_int AS field2
3062 FROM f AS table1s
3063 JOIN g AS table2s ON table1s.col_int_unique+0 = table2s.col_int_unique
3064 );
3065
3066 --replace_regex / \(cost=.*//
3067 eval explain format=tree $query;
3068 --sorted_result
3069 eval $query;
3070
3071 # WEEDOUT:
3072 # Query use 'Remove duplicate ... using temporary table (weedout)'
3073 # Note that only some of the tables in a weedout are duplicate
3074 # eliminated from. Thus the branch is not a full semi-join.
3075 let $query=
3076 SELECT
3077 /*+ JOIN_ORDER(table2,table2s@subq,table1) SEMIJOIN(@subq DUPSWEEDOUT) */
3078 table1.pk, table2.pk
3079 FROM z AS table1
3080 JOIN b AS table2 ON table1.col_int_key = table2.pk
3081 WHERE table1.col_int_key IN (
3082 SELECT /*+ QB_NAME(subq) */
3083 table2s.col_int_key
3084 FROM q AS table2s
3085 );
3086
3087 --replace_regex / \(cost=.*//
3088 eval explain format=tree $query;
3089 --sorted_result
3090 eval $query;
3091
3092 ###########################################
3093 # BKA-join using MRR for inner part returned incorrect result.
3094 # Filed and fixed as seperate bug#33416308, keep original
3095 # testcase her as well.
3096
3097 set optimizer_switch='batched_key_access=on';
3098
3099 let $query=
3100 SELECT straight_join
3101 table1.pk, table2.pk, table3.pk
3102 FROM i AS table2
3103 JOIN i AS table3 ON table2.col_int = table3.col_int AND
3104 table2.col_int_key = table3.col_int_key AND
3105 table2.col_int_unique = table3.col_int_unique
3106 JOIN t as table1
3107 ON table1.col_int = table2.col_int AND
3108 table1.col_int_unique = table3.col_int_unique;
3109
3110 --replace_regex / \(cost=.*//
3111 eval explain format=tree $query;
3112 --sorted_result
3113 eval $query;
3114
3115 set optimizer_switch='batched_key_access=default';
3116
3117
3118 --echo ##################
3119 --echo #
3120 --echo # Bug#33670002: Pushed outer join fails:
3121 --echo # Error 4829 'FirstInner/Upper has to be an ancestor or a sibling'
3122 --echo #
3123 --echo ##################
3124 # The mandatory 'ancestor' dependencies between join nests was not
3125 # correctly propogated to upper nest levels.
3126 let $query=
3127 SELECT
3128 table2.pk, table1.pk, table3.pk, table5.pk, table4.pk
3129 FROM (v AS table2
3130 STRAIGHT_JOIN u AS table1 ON table1.col_int_key = table2.col_int)
3131 LEFT JOIN m AS table3
3132 LEFT JOIN (u AS table5
3133 STRAIGHT_JOIN n AS table4 ON table4.col_int_key = table5.col_int_key)
3134 ON table3.col_int_unique = table5.col_int_key
3135 ON table1.col_int = table3.col_int AND
3136 table2.col_int_unique = table3.col_int_unique;
3137
3138 --replace_regex / \(cost=.*//
3139 eval explain format=tree $query;
3140 --sorted_result
3141 eval $query;
3142
3143
3144 --echo ##################
3145 --echo #
3146 --echo # Bug#34379950 Pushed join execution fails with:
3147 --echo # error 4800 'Required argument is NULL'
3148 --echo #
3149 --echo ##################
3150
3151 ################
3152 # Generated query plan is: t1, t3s, t2s, t1s
3153 # Initially find that t1, t3s, t2s can be pushed
3154 #
3155 # t1s not pushed due to:
3156 # 'col_varchar_256_unique' does not have same datatype as ref'ed column 'table3s.col_char_16_key'
3157 #
3158 # t3s later fails the final 'validate_join_nest-check' and is removed.
3159 # : Can't push semi joined table 'table3s' as child of 'table1',
3160 # some tables in embedding join-nest(s) are not part of pushed join
3161 #
3162 # t2s had the pushed condition 'table2s.pk = table3s.col_int_key' (t3s referred as a parameter)
3163 # Thus the t2s pushed condition can't be pushed either as it referred t3s.
3164
3165 let $query=
3166 SELECT
3167 table1.pk
3168 FROM v AS table1
3169 WHERE table1.col_int_unique IN (
3170 SELECT table3s.col_int_key
3171 FROM q AS table1s
3172 RIGHT JOIN d AS table2s
3173 RIGHT JOIN w AS table3s ON table2s.pk = table3s.col_int_key
3174 ON table1s.col_varchar_256_unique = table3s.col_char_16_key
3175 );
3176
3177 --replace_regex / \(cost=.*//
3178 eval explain format=tree $query;
3179 --sorted_result
3180 eval $query;
3181
3182
3183 --echo ##################
3184 --echo # Bug#34486874 Error 4829:
3185 --echo # 'FirstInner/Upper has to be an ancestor or a sibling'
3186 --echo ##################
3187
3188 # Join plan is: (Tables renamed acording to join order)
3189 # t0, t1, (t2, t3, t4), (t5)
3190 #
3191 # - t5 is joined with both t3 and t1
3192 # - t5 refers t3 as first parent (Note: t3 not in t5's upper nests)
3193 # - The remaining t5 parent 't1' is recorded as an required ancestor of t3
3194 # -- t1 was not recorded as an nest ancestor in the first_inner-table t2 !!
3195 #
3196 # - t4 required dependencies are then collected by adding ancestors
3197 # - Add t4.ancestors.
3198 # - Add further ancestors noted in the first_inner-table t2
3199 # -- as t1 was not recorded above, it is missed out from
3200 # required t4 dependencies
3201 # -> t0 is set up as the t4 parent, instead of t1.
3202 #
3203 # - t3 is later joined with t1, which is set as parent
3204 #
3205 # There is a requirement that all out-of-nest dependencies has
3206 # to be resolved such they all join with a common upper-parent,
3207 # which was broken by the above.
3208 #
3209 # -> Error 4829 ....
3210 #
3211 let $query=
3212 SELECT
3213 table1.pk, table2.pk, table3.pk, table4.pk, table5.pk, table6.pk
3214 FROM (j AS table1
3215 JOIN w AS table2 ON table1.col_int = table2.col_int AND
3216 table1.col_int_key = table2.col_int_key AND
3217 table1.col_int_unique = table2.col_int_unique
3218 JOIN n AS table3 ON table2.pk = table3.col_int_key
3219 RIGHT JOIN c AS table4
3220 JOIN g AS table5 ON table4.col_int_key = table5.col_int_key
3221 ON table2.pk = table5.col_int_key)
3222 LEFT JOIN s AS table6 ON table1.col_int_key = table6.col_int_key AND
3223 table5.col_int_unique = table6.col_int_unique;
3224
3225 --replace_regex / \(cost=.*//
3226 eval explain format=tree $query;
3227 --sorted_result
3228 eval $query;
3229
3230
3231 ###########
3232 # Another query challenging the fix for the same bug#
3233 #
3234 let $query=
3235 SELECT
3236 table1.pk, table2.pk, table3.pk, table4.pk, table5.pk
3237 FROM d AS table1
3238 LEFT JOIN v AS table2
3239 INNER JOIN q AS table3 ON table2.col_int_key = table3.col_int_key AND
3240 table2.col_int_unique = table3.col_int_unique
3241 ON table1.col_int_key = table2.col_int_key AND
3242 table1.col_int_unique = table2.col_int_unique
3243 RIGHT JOIN p AS table4
3244 RIGHT JOIN q AS table5 ON table4.col_int_key = table5.col_int_key AND
3245 table4.col_int_unique = table5.col_int_unique OR
3246 table4.pk = table5.col_int_key
3247 ON table1.col_int_key = table5.col_int_key AND
3248 table1.col_int_unique = table5.col_int_unique;
3249
3250 --replace_regex / \(cost=.*//
3251 eval explain format=tree $query;
3252 --sorted_result
3253 eval $query;
3254
3255
3256 #########
3257 # Guard against regression introduced in one of the attempted patch:
3258 # -> Got error 4806 'Multiple 'parents' specified in linkedValues
3259 #
3260 let $query=
3261 SELECT
3262 table1.pk, table2.pk, table3.pk, table4.pk, table5.pk
3263 FROM j AS table1
3264 JOIN j AS table2 ON table1.col_int_key = table2.col_int_key
3265 LEFT JOIN w AS table3 ON table2.pk = table3.col_int_key
3266 LEFT JOIN w AS table4
3267 JOIN x AS table5 ON table4.col_int_unique = table5.pk
3268 ON table1.col_int = table5.col_int AND
3269 table3.col_int_key = table4.col_int_key AND
3270 table1.col_int_unique = table5.col_int_unique;
3271
3272 --replace_regex / \(cost=.*//
3273 eval explain format=tree $query;
3274 --sorted_result
3275 eval $query;
3276
3277
3278 ########
3279 # Yet another regression guard
3280 let $query=
3281 SELECT
3282 table1.pk, table2.pk, table3.pk, table4.pk
3283 FROM y AS table1
3284 RIGHT JOIN n AS table2
3285 JOIN w AS table3 ON table2.col_int = table3.col_int AND
3286 table2.col_int_key = table3.col_int_key AND
3287 table2.col_int_unique = table3.col_int_unique
3288 ON table1.col_int = table3.col_int_unique
3289 INNER JOIN l AS table4 ON table4.col_int IS NULL OR
3290 table1.col_int_unique = table4.col_int_key;
3291
3292 --replace_regex / \(cost=.*//
3293 eval explain format=tree $query;
3294 --sorted_result
3295 eval $query;
3296
3297
3298 --echo ##################
3299 --echo #
3300 --echo # Bug#34508948 Allow more conditions to be pushed down
3301 --echo #
3302 --echo ##################
3303
3304 ##########
3305 # In order to push a condition as part of pushed join, all tables
3306 # refererd from the pushed condition need to be ancestors of the table
3307 # having the pushed condition.
3308 #
3309 # In test case below t3 will have the filter:
3310 # WHERE t1.pk = 8 OR t1.col_varchar_256_key = t3.col_varchar_256
3311 #
3312 # While, the t3 join condition is:
3313 # ON table3.col_int_key = table1.col_int
3314 #
3315 # As only t1 is refererd by the join condition, t1 becomes the natural
3316 # ancestor of t3 in the pushed join. However, SPJ allows us to add extra
3317 # 'proxy' ancestors when they have common ancestors. Thus, by detecting that
3318 # t2 also has t1 as an ancestor, it can be forced as an ancestor of t3, such
3319 # that t3 get the ancestor set [t1,t2] -> t3 condition becomes pushable
3320 #
3321 let $query=
3322 SELECT STRAIGHT_JOIN
3323 table1.pk, table2.pk, table3.pk
3324 FROM p AS table1
3325 JOIN g AS table2 ON table2.col_int_unique = table1.col_int_unique
3326 JOIN n AS table3 ON table3.col_int_key = table1.col_int
3327 WHERE table3.pk = 8 OR table3.col_varchar_256_key = table2.col_varchar_256;
3328
3329 --replace_regex / \(cost=.*//
3330 eval explain format=tree $query;
3331 --sorted_result
3332 eval $query;
3333
3334
3335 ##########
3336 # ~Same query with t2 join condition changed from an unique-key lookup
3337 # on 't2.col_int_unique' to use the non-unique 'table2.col_int_key'.
3338 # Forcing t2 as an proxy-ancestor to t3 would result in a t3 lookup for
3339 # each t2 row matching 'table2.col_int_key = table1.col_int_key'.
3340 # Depending on the fanout of this join condition, it could result in
3341 # a prohibitive increase in t3 accesses.
3342 # Thus, we intentionally do not add tables having a non-unique access
3343 # as extra ancestors -> t3 condition not pushable
3344 #
3345 let $query=
3346 SELECT STRAIGHT_JOIN
3347 table1.pk, table2.pk, table3.pk
3348 FROM p AS table1
3349 JOIN g AS table2 ON table2.col_int_key = table1.col_int_key
3350 JOIN n AS table3 ON table3.col_int_key = table1.col_int
3351 WHERE table3.pk = 8 OR table3.col_varchar_256_key = table2.col_varchar_256;
3352
3353 --replace_regex / \(cost=.*//
3354 eval explain format=tree $query;
3355 --sorted_result
3356 eval $query;
3357
3358
3359 ##############
3360 # ~Same query again, this time t2 is outer joined with an unique-lookup
3361 #
3362 # Query plan is: t1, (outer join t2), t3 'with filter'.
3363 #
3364 # The outer joined table2 is referred from the filter:
3365 # t3.pk = 8 OR t3.col_varchar_256_key = t2.col_varchar_256
3366 #
3367 # As t3 is inner joined with t1, t2 is *not* in t3's scope of
3368 # 'embedding_nests'.
3369 # Pushing the filter condition, would have required adding
3370 # t2 as an ancestor of t3, which would implicitely add a not-null
3371 # requirement on t2 as well - Effectively changing the outer join
3372 # semantic to an inner join.
3373 #
3374 # -> Do NOT push the filter condition!
3375 #
3376 let $query=
3377 SELECT STRAIGHT_JOIN
3378 table1.pk, table2.pk, table3.pk
3379 FROM p AS table1
3380 LEFT JOIN g AS table2 ON table2.col_int_unique = table1.col_int_unique
3381 JOIN n AS table3 ON table3.col_int_key = table1.col_int
3382 WHERE table3.pk = 8 OR table3.col_varchar_256_key = table2.col_varchar_256;
3383
3384 --replace_regex / \(cost=.*//
3385 eval explain format=tree $query;
3386 --sorted_result
3387 eval $query;
3388
3389
3390 #######
3391 # Some other random queries picked up from RQG testing. Which
3392 # demonstrate the enhanced condition pushdown as well as
3393 # protecting agains some cases where we found a too eager
3394 # condition pushdown
3395
3396 let $query=
3397 SELECT
3398 table1.pk, table2.pk, table3.pk, table4.pk
3399 FROM c AS table1
3400 RIGHT JOIN a AS table2
3401 RIGHT JOIN d AS table3 ON table2.pk = table3.col_int
3402 RIGHT JOIN d AS table4 ON table3.col_int_key = table4.col_int_key AND
3403 table2.col_int_unique = table4.col_int_unique
3404 ON table1.pk = table2.col_int_unique
3405 WHERE table1.col_int_unique > 9;
3406
3407 --replace_regex / \(cost=.*//
3408 eval explain format=tree $query;
3409 --sorted_result
3410 eval $query;
3411
3412
3413 let $query=
3414 SELECT table3.col_char_16_unique AS field1
3415 FROM d AS table1
3416 JOIN m AS table2 ON table1.col_int_unique = table2.pk
3417 JOIN m AS table3 ON table1.pk = table3.col_int_unique
3418 RIGHT JOIN j AS table4 ON table3.col_int_key = table4.col_int AND
3419 table2.col_int_unique = table4.col_int_key
3420 WHERE table2.col_int = 76;
3421
3422 --replace_regex / \(cost=.*//
3423 eval explain format=tree $query;
3424 --sorted_result
3425 eval $query;
3426
3427
3428 let $query=
3429 SELECT
3430 table2.col_int_key AS field1
3431 FROM d AS table1
3432 JOIN f AS table2
3433 LEFT JOIN m AS table3
3434 RIGHT JOIN e AS table4 ON table3.col_int_key = table4.col_int_unique
3435 ON table2.pk = table3.col_int
3436 ON table1.col_int_unique = table2.col_int_key
3437 JOIN h AS table5 ON table4.col_int_key = table5.col_int_key AND
3438 table2.col_int_unique = table5.col_int_unique;
3439
3440 --replace_regex / \(cost=.*//
3441 eval explain format=tree $query;
3442 --sorted_result
3443 eval $query;
3444
3445
3446 let $query=
3447 SELECT
3448 #table2.col_char_16_unique AS field1
3449 table1.pk, table2.pk, table3.pk, table4.pk, table5.pk, table6.pk
3450 FROM a AS table1
3451 JOIN k AS table2 ON table1.col_int_unique = table2.col_int
3452 RIGHT JOIN r AS table3 ON table1.col_varchar_10_key = table3.col_varchar_10_key
3453 RIGHT JOIN w AS table4
3454 JOIN l AS table5
3455 RIGHT JOIN v AS table6 ON table5.col_varchar_10_unique = table6.col_varchar_10_unique
3456 ON table4.pk = table6.col_int_unique
3457 ON table2.col_int_key = table5.col_int_key AND
3458 table3.col_int_unique = table4.col_int_unique
3459 WHERE table4.pk >= 3;
3460
3461 --replace_regex / \(cost=.*//
3462 eval explain format=tree $query;
3463 --sorted_result
3464 eval $query;
3465
3466 # end bug#34508948
3467 ################
3468
3469
3470 --echo ##################
3471 --echo #
3472 --echo # Bug#34231798 Incorrect query result from pushed join with IN-subquery
3473 --echo #
3474 --echo ##################
3475 #
3476 # Yet another multiple batch induced problem:
3477 # Semi-join skipping to next row when a match has been found, could result in
3478 # also skipping results from other non-semi-joined tables depending on the semi-join
3479 # when results from these tables had to be retrieved over multiple batches.
3480 # Thus we can not push such dependent scan-tables
3481 let $query=
3482 SELECT DISTINCT
3483 table2.col_varchar_256_unique
3484 FROM r AS table1
3485 JOIN q AS table2 ON table2.col_int IS NOT NULL
3486 WHERE table2.col_int IN (SELECT /*+ SEMIJOIN(LOOSESCAN)*/ col_int_key FROM u);
3487
3488 --replace_regex / \(cost=.*//
3489 eval explain format=tree $query;
3490 --sorted_result
3491 eval $query;
3492
3493 let $query=
3494 SELECT
3495 table2.col_int_key AS field1,
3496 table1.col_int_unique AS field2,
3497 table2.col_int AS field3
3498 FROM (q AS table1
3499 JOIN h AS table2 ON table1.col_int = table2.col_int_key )
3500 WHERE ( table2.col_int_unique = ANY (
3501 SELECT /*+ SEMIJOIN(LOOSESCAN)*/
3502 table2s.col_int_key
3503 FROM o AS table1s
3504 INNER JOIN l AS table2s ON table1s.col_int = table2s.col_int)
3505 AND table2.col_int_unique <= 3);
3506
3507 --replace_regex / \(cost=.*//
3508 eval explain format=tree $query;
3509 --sorted_result
3510 eval $query;
3511
3512
3513 --echo ##################
3514 --echo #
3515 --echo # Bug#34782276:
3516 --echo # Improve SPJ-internal execution plan, evaluate inner-joins first
3517 --echo #
3518 --echo ##################
3519 #
3520 # Note that it is test case for this bug# in join_pushdown* as well.
3521 # This test case is for second part of that bug, where we didn't correctly
3522 # set the 'active nodes' sent to the SPJ API. (Which needed a more complicated
3523 # test case, found with RQG testing.)
3524 #
3525 let $query=
3526 SELECT
3527 table1.pk, table2.pk, table3.pk, table4.pk
3528 FROM x AS table1
3529 JOIN q AS table2
3530 RIGHT OUTER JOIN q AS table3
3531 LEFT OUTER JOIN x AS table4 ON table3.pk = table4.col_int_key
3532 ON table2.col_int = table3.col_int AND
3533 table2.col_int_unique = table3.col_int_unique
3534 ON table1.col_int = table4.col_int_unique;
3535
3536 --replace_regex / \(cost=.*//
3537 eval explain format=tree $query;
3538 --sorted_result
3539 eval $query;
3540
3541
3542 ######################################################
3543 DROP TABLE a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z;
3544
3545
3546 #####################################################
3547 # Some test cases not using the tables a..z (anymore).
3548 # These were originally found using the RQG test suite
3549 # and the above tables, but were simplified into smaller
3550 # test cases during bug fixing.
3551 # They also need the 'BatchSize=1' config to reproduce
3552 # the failure.
3553
3554 --echo ##################
3555 --echo #
3556 --echo # Bug #33181964 Incorrect result for pushed join
3557 --echo # w/ outer join inside an exists-subqry
3558 --echo #
3559 --echo ##################
3560
3561 create table t (
3562 pk int NOT NULL,
3563 col_int int NOT NULL,
3564 primary key(col_int,pk)
3565 ) engine=ndbcluster;
3566
3567 insert into t values
3568 (1, 0), (3, 0), (2, 0), (4, 0), (5, 0), (7, 0);
3569
3570
3571 create table x (
3572 col_int int
3573 ) engine=ndbcluster ;
3574
3575 # Make table 'x' larger than 't'
3576 insert into x select pk from t;
3577 insert into x select pk from t;
3578
3579 let $query=
3580 select * from x
3581 where exists (
3582 select *
3583 from t as t1
3584 left join (
3585 t as t2 join t as t3 on
3586 t2.pk = 999 # 999 -> no t2 matches
3587 )
3588 on t1.col_int = t3.col_int and
3589 t1.col_int = t2.col_int
3590 );
3591
3592 --echo ######################################
3593 --echo # Expect 'firstMatch' algorithm to be
3594 --echo # used for pushed join over [t1..t3]
3595 --echo ######################################
3596 eval explain format=traditional $query;
3597
3598 --sorted_result
3599 eval $query;
3600
3601 drop table t,x;