« back to all changes in this revision
Viewing changes to tests/t/optimizer.test
- browse files at revision 1637.5.10
- compare with another revision
- compare with revision 1637.5.10
- download diff
- download tarball
- view history from revision 1637.5.10
- Committer: Prafulla Tekawade
- Date: 2010-07-19 02:14:50 UTC
- mto: (1662.1.4 rollup)
- mto: This revision was merged to the branch mainline in revision 1664.
- Revision ID: prafulla_t@users.sourceforge.net-20100719021450-6thmyhdeyyninq6u
Adding test for Bug #592444
- files modified:
- drizzled/show.cc
added
removed
tests/t/optimizer.test
115
115
116
116
DROP TABLE BB;
117
117
--echo End Bug#595305 test
118
119
--echo Bug#592444
120
--echo - Segfault - operator= (join=0x1fd0fd8, tables=<value optimized out>, conds=<value optimized out>, keyuse_array=<value optimized out>) at ./drizzled/join_table.h:73
121
--disable_warnings
122
DROP TABLE IF EXISTS `p`;
123
--enable_warnings
124
CREATE TABLE `p` (
125
`pk` int NOT NULL AUTO_INCREMENT,
126
`col_int_key` int DEFAULT NULL,
127
PRIMARY KEY (`pk`),
128
KEY `col_int_key` (`col_int_key`)
129
) ENGINE=InnoDB;
130
131
ALTER TABLE `p` DISABLE KEYS;
132
INSERT INTO `p` VALUES (1,NULL),(2,261947392),(3,-1761017856),(4,NULL),(5,NULL),(6,NULL),(7,1941635072),(8,-610992128),(9,NULL),(10,-1486618624),(11,1047199744),(12,5),(13,2),(14,NULL),(15,NULL),(16,-828899328),(17,5),(18,NULL),(19,-1573322752),(20,NULL),(21,1),(22,1080360960),(23,NULL),(24,9),(25,243335168),(26,NULL),(27,2),(28,351469568),(29,NULL),(30,0),(31,1626865664),(32,NULL),(33,NULL),(34,6),(35,NULL),(36,6),(37,NULL),(38,838598656),(39,-1732706304),(40,-120061952),(41,NULL),(42,3),(43,2),(44,8),(45,-1234436096),(46,4),(47,-1542324224),(48,NULL),(49,1607073792),(50,0),(51,9),(52,NULL),(53,NULL),(54,-921174016),(55,-184877056),(56,NULL),(57,-1291059200),(58,0),(59,NULL),(60,565379072),(61,NULL),(62,506855424),(63,NULL),(64,NULL),(65,NULL),(66,5),(67,5),(68,5),(69,2),(70,6),(71,NULL),(72,9),(73,7),(74,-2108555264),(75,6),(76,1057095680),(77,8),(78,-409468928),(79,-438960128),(80,-939393024),(81,-927203328),(82,NULL),(83,-1834680320),(84,NULL),(85,1984561152),(86,8),(87,NULL),(88,8),(89,-326500352),(90,NULL),(91,4),(92,NULL),(93,NULL),(94,-1369833472),(95,NULL),(96,0),(97,31260672),(98,NULL),(99,NULL),(100,0);
133
ALTER TABLE `p` ENABLE KEYS;
134
135
DROP TABLE IF EXISTS `n`;
136
CREATE TABLE `n` (
137
`pk` int NOT NULL AUTO_INCREMENT,
138
`col_varchar_10_key` varchar(10) DEFAULT NULL,
139
PRIMARY KEY (`pk`),
140
KEY `col_varchar_10_key` (`col_varchar_10_key`)
141
) ENGINE=InnoDB;
142
143
ALTER TABLE `n` DISABLE KEYS;
144
INSERT INTO `n` VALUES (1,'rdtxodtcmi'),(2,'corrdtxodt'),(3,'v'),(4,'dcorrdtxod'),(5,'s'),(6,'my'),(7,'e'),(8,'qxszmrdcor'),(9,'bqxszmrdco'),(10,'wbqxszmrdc'),(11,'v'),(12,'kywbqxszmr'),(13,'v'),(14,'lngrakywbq'),(15,'umtlngraky'),(16,'could'),(17,'peiywumtln'),(18,'will'),(19,'tell'),(20,'w'),(21,'jenpeiywum'),(22,'cejenpeiyw'),(23,'x'),(24,'vxcejenpei');
145
ALTER TABLE `n` ENABLE KEYS;
146
147
DROP TABLE IF EXISTS `d`;
148
CREATE TABLE `d` (
149
`pk` int NOT NULL AUTO_INCREMENT,
150
`col_varchar_10` varchar(10) DEFAULT NULL,
151
PRIMARY KEY (`pk`)
152
) ENGINE=InnoDB;
153
154
ALTER TABLE `d` DISABLE KEYS;
155
INSERT INTO `d` VALUES (1,'f'),(2,'zdvoleqxer'),(3,'i'),(4,'u'),(5,'q');
156
ALTER TABLE `d` ENABLE KEYS;
157
158
DROP TABLE IF EXISTS `h`;
159
CREATE TABLE `h` (
160
`col_varchar_10` varchar(10) DEFAULT NULL,
161
`pk` int NOT NULL AUTO_INCREMENT,
162
`col_varchar_10_key` varchar(10) DEFAULT NULL,
163
`col_int_key` int DEFAULT NULL,
164
PRIMARY KEY (`pk`),
165
KEY `col_varchar_10_key` (`col_varchar_10_key`),
166
KEY `col_int_key` (`col_int_key`)
167
) ENGINE=InnoDB;
168
169
ALTER TABLE `h` DISABLE KEYS;
170
INSERT INTO `h` VALUES ('n',1,'rshrrbmsyd',4),('h',2,'okay',NULL),('ok',3,'i',-802095104),('just',4,'z',6),('hfnrshrrbm',5,'his',8),('f',6,'xhfnrshrrb',1),('h',7,'wxhfnrshrr',7),('wtwxhfnrsh',8,'v',7),('of',9,'cwtwxhfnrs',-1258487808);
171
ALTER TABLE `h` ENABLE KEYS;
172
173
DROP TABLE IF EXISTS `a`;
174
CREATE TABLE `a` (
175
`pk` int NOT NULL AUTO_INCREMENT,
176
PRIMARY KEY (`pk`)
177
) ENGINE=InnoDB;
178
179
DROP TABLE IF EXISTS `k`;
180
CREATE TABLE `k` (
181
`pk` int NOT NULL AUTO_INCREMENT,
182
`col_varchar_10` varchar(10) DEFAULT NULL,
183
`col_varchar_10_key` varchar(10) DEFAULT NULL,
184
`col_int_key` int DEFAULT NULL,
185
PRIMARY KEY (`pk`),
186
KEY `col_varchar_10_key` (`col_varchar_10_key`),
187
KEY `col_int_key` (`col_int_key`)
188
) ENGINE=InnoDB;
189
190
ALTER TABLE `k` DISABLE KEYS;
191
INSERT INTO `k` VALUES (1,'bwylrhande','hbwylrhand',-522452992),(2,'how','about',2098200576),(3,'ephbwylrha','pephbwylrh',904331264),(4,'okay','ipephbwylr',-1176633344),(5,'but','one',-1177288704),(6,'tnwkipephb','j',5),(7,'hqtnwkipep','a',9),(8,'with','wdhqtnwkip',NULL),(9,'eyxwdhqtnw','jeyxwdhqtn',2),(10,'right','something',3),(11,'z','ujeyxwdhqt',5),(12,'yyujeyxwdh','we',NULL),(13,'can','syyujeyxwd',0),(14,'s','oh',21037056),(15,'ngvsyyujey','something',1224867840),(16,'gngvsyyuje','qgngvsyyuj',1),(17,'this','really',4),(18,'p','bbuqgngvsy',1865023488),(19,'okay','from',1),(20,'dmbbuqgngv','but',9),(21,'one','rdmbbuqgng',0);
192
ALTER TABLE `k` ENABLE KEYS;
193
194
SELECT
195
table2 . `pk` AS field4
196
FROM p AS table1 LEFT JOIN
197
n AS table2 LEFT JOIN
198
d AS table3
199
ON table2 . `pk` = table3 . `pk`
200
RIGHT OUTER JOIN h AS table4
201
LEFT OUTER JOIN a AS table5
202
ON table4 . `pk` = table5 . `pk`
203
ON table2 . `col_varchar_10_key` = table4 . `col_varchar_10_key`
204
ON table1 . `col_int_key` = table5 . `pk`
205
LEFT JOIN h AS table6
206
LEFT JOIN k AS table7
207
ON table6 . `col_int_key` = table7 . `col_int_key`
208
LEFT OUTER JOIN h AS table8
209
ON table7 . `col_varchar_10_key` = table8 . `col_varchar_10`
210
ON table3 . `col_varchar_10` = table7 . `col_varchar_10`
211
WHERE (
212
( table3 . `pk` IN (6) )
213
OR table7 . `col_int_key` IN (1, 1, 1, 2) ) ;
214
--echo End Bug#592444 test
Loggerhead is a web-based interface for Breezy
Version: 2.0.1