~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/func_in.test

  • Committer: Brian Aker
  • Date: 2009-10-15 00:22:33 UTC
  • mto: (1183.1.11 merge)
  • mto: This revision was merged to the branch mainline in revision 1198.
  • Revision ID: brian@gaz-20091015002233-fa4ao2mbc67wls91
First pass of information engine. OMG, ponies... is it so much easier to
deal with creating and engine.

The list table iterator though... its ass, needs to go. We should also
abstract out share. Very few engines need a custom one. Just say'in

Show diffs side-by-side

added added

removed removed

Lines of Context:
262
262
INSERT INTO t4 VALUES (1,1),(2,2),(1000,1000),(1001,1001),(1002,1002),
263
263
       (1003,1003),(1004,1004);
264
264
 
265
 
--sorted_result
266
265
EXPLAIN SELECT STRAIGHT_JOIN * FROM t3 
267
266
  JOIN t1 ON t3.a=t1.a 
268
267
  JOIN t2 ON t3.a=t2.a
273
272
  JOIN t2 ON t3.a=t2.a
274
273
  JOIN t4 WHERE t4.a IN (t1.b, t2.b);
275
274
 
276
 
--sorted_result
277
275
EXPLAIN SELECT STRAIGHT_JOIN 
278
276
   (SELECT SUM(t4.a) FROM t4 WHERE t4.a IN (t1.b, t2.b)) 
279
277
  FROM t3, t1, t2
362
360
CREATE TABLE t1 (id int not null);
363
361
INSERT INTO t1 VALUES (1),(2);
364
362
 
365
 
--error ER_DIVISION_BY_ZERO
366
363
SELECT id FROM t1 WHERE id IN(4564, (SELECT IF(1=0,1,1/0)) );
367
364
 
368
365
DROP TABLE t1;