diff options
Diffstat (limited to 'mysql-test/t/innobase.test')
-rw-r--r-- | mysql-test/t/innobase.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/innobase.test b/mysql-test/t/innobase.test index 4fa8d07bd52..66fb864f93c 100644 --- a/mysql-test/t/innobase.test +++ b/mysql-test/t/innobase.test @@ -408,3 +408,12 @@ CREATE TABLE t1 ( INSERT INTO t1 VALUES (1, 1); SELECT MIN(B),MAX(b) FROM t1 WHERE t1.a = 1; drop table t1; + +# +# Crash when using many tables (Test case by Jeremy D Zawodny) +# + +create table t1 (a int primary key,b int, c int, d int, e int, f int, g int, h int, i int, j int, k int, l int, m int, n int, o int, p int, q int, r int, s int, t int, u int, v int, w int, x int, y int, z int, a1 int, a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int, a9 int, b1 int, b2 int, b3 int, b4 int, b5 int, b6 int) type = Innobase; +insert into t1 values (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1); +explain select * from t1 where a > 0 and a < 50; +drop table t1; |