|
1
by brian
clean slate |
1 |
# include/read_many_rows.inc |
2 |
#
|
|
3 |
# Test how filesort and buffered-record-reads works |
|
4 |
# This test needs a lot of time. |
|
5 |
#
|
|
6 |
# The variables |
|
7 |
# $engine_type -- storage engine to be tested |
|
8 |
# $other_engine_type -- storage engine <> $engine_type, if possible |
|
9 |
# 1. $other_engine_type must allow to store many rows |
|
10 |
# without using non standard server options |
|
11 |
# (does not need a t/read_many_rows_*-master.opt file) |
|
12 |
# 2. $other_engine_type must point to an all time |
|
13 |
# available storage engine |
|
14 |
# 2006-08 MySQL 5.1 MyISAM and MEMORY only |
|
15 |
# have to be set before sourcing this script. |
|
16 |
#
|
|
17 |
# Last update: |
|
18 |
# 2006-08-03 ML test refactored (MySQL 5.1) |
|
19 |
# main code t/innodb-big.test --> include/read_many_rows.inc |
|
20 |
#
|
|
21 |
||
22 |
eval SET SESSION STORAGE_ENGINE = $engine_type; |
|
23 |
||
24 |
--disable_warnings |
|
25 |
DROP TABLE IF EXISTS t1, t2, t3, t4; |
|
26 |
--enable_warnings |
|
27 |
||
28 |
eval CREATE TABLE t1 (id INTEGER) ENGINE=$other_engine_type; |
|
29 |
CREATE TABLE t2 (id INTEGER PRIMARY KEY); |
|
30 |
CREATE TABLE t3 (a CHAR(32) PRIMARY KEY,id INTEGER); |
|
31 |
eval CREATE TABLE t4 (a CHAR(32) PRIMARY KEY,id INTEGER) ENGINE=$other_engine_type; |
|
|
673.3.9
by Stewart Smith
fix read_many_rows_innodb test |
32 |
begin; |
|
1
by brian
clean slate |
33 |
INSERT INTO t1 (id) VALUES (1); |
34 |
INSERT INTO t1 SELECT id+1 FROM t1; |
|
35 |
INSERT INTO t1 SELECT id+2 FROM t1; |
|
36 |
INSERT INTO t1 SELECT id+4 FROM t1; |
|
37 |
INSERT INTO t1 SELECT id+8 FROM t1; |
|
38 |
INSERT INTO t1 SELECT id+16 FROM t1; |
|
39 |
INSERT INTO t1 SELECT id+32 FROM t1; |
|
40 |
INSERT INTO t1 SELECT id+64 FROM t1; |
|
41 |
INSERT INTO t1 SELECT id+128 FROM t1; |
|
42 |
INSERT INTO t1 SELECT id+256 FROM t1; |
|
43 |
INSERT INTO t1 SELECT id+512 FROM t1; |
|
44 |
INSERT INTO t1 SELECT id+1024 FROM t1; |
|
45 |
INSERT INTO t1 SELECT id+2048 FROM t1; |
|
|
1504
by Brian Aker
Fixes for "big" suite. |
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; |
|
|
1
by brian
clean slate |
55 |
|
56 |
INSERT INTO t2 SELECT * FROM t1; |
|
57 |
INSERT INTO t3 SELECT CONCAT(id),id FROM t2 ORDER BY -id; |
|
58 |
INSERT INTO t4 SELECT * FROM t3 ORDER BY CONCAT(a); |
|
59 |
SELECT SUM(id) FROM t3; |
|
60 |
||
|
2100.1.4
by Lee Bieber
update big test, add COMMIT statement per Stewart's recent changes |
61 |
COMMIT; |
|
1
by brian
clean slate |
62 |
DROP TABLE t1,t2,t3,t4; |
63 |