← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/include/read_many_rows.inc

  • Committer: Padraig O'Sullivan
  • Date: 2009-12-17 04:48:59 UTC
  • mto: This revision was merged to the branch mainline in revision 1246.
  • Revision ID: osullivan.padraig@gmail.com-20091217044859-qorpkp4911zypfv3
Added some dtrace probes for tracing the optimizer.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/include/read_many_rows.inc
43
43
INSERT INTO t1 SELECT id+512 FROM t1;
44
44
INSERT INTO t1 SELECT id+1024 FROM t1;
45
45
INSERT INTO t1 SELECT id+2048 FROM t1;
46
 
INSERT INTO t1 SELECT SQL_BIG_RESULT id+4096 FROM t1;
47
 
INSERT INTO t1 SELECT SQL_BIG_RESULT id+8192 FROM t1;
48
 
INSERT INTO t1 SELECT SQL_BIG_RESULT id+16384 FROM t1;
49
 
INSERT INTO t1 SELECT SQL_BIG_RESULT id+32768 FROM t1;
50
 
INSERT INTO t1 SELECT SQL_BIG_RESULT id+65536 FROM t1;
51
 
INSERT INTO t1 SELECT SQL_BIG_RESULT id+131072 FROM t1;
52
 
INSERT INTO t1 SELECT SQL_BIG_RESULT id+262144 FROM t1;
53
 
INSERT INTO t1 SELECT SQL_BIG_RESULT id+524288 FROM t1;
54
 
INSERT INTO t1 SELECT SQL_BIG_RESULT id+1048576 FROM t1;
 
46
INSERT INTO t1 SELECT id+4096 FROM t1;
 
47
INSERT INTO t1 SELECT id+8192 FROM t1;
 
48
INSERT INTO t1 SELECT id+16384 FROM t1;
 
49
INSERT INTO t1 SELECT id+32768 FROM t1;
 
50
INSERT INTO t1 SELECT id+65536 FROM t1;
 
51
INSERT INTO t1 SELECT id+131072 FROM t1;
 
52
INSERT INTO t1 SELECT id+262144 FROM t1;
 
53
INSERT INTO t1 SELECT id+524288 FROM t1;
 
54
INSERT INTO t1 SELECT id+1048576 FROM t1;
55
55
 
56
56
INSERT INTO t2 SELECT * FROM t1;
57
57
INSERT INTO t3 SELECT CONCAT(id),id FROM t2 ORDER BY -id;
58
58
INSERT INTO t4 SELECT * FROM t3 ORDER BY CONCAT(a);
59
59
SELECT SUM(id) FROM t3;
60
60
 
61
 
COMMIT;
62
61
DROP TABLE t1,t2,t3,t4;
63
62