diff options
| author | Sinisa@sinisa.nasamreza.org <> | 2003-04-21 21:03:32 +0300 |
|---|---|---|
| committer | Sinisa@sinisa.nasamreza.org <> | 2003-04-21 21:03:32 +0300 |
| commit | adb52cfc70b8624dfbf4d36fa966fc20b3b0452d (patch) | |
| tree | 7a08a3618a847d9c0596c98295a731eff9e349b0 /mysql-test/t/innodb.test | |
| parent | 8902b739e9243cd82a06ed4e0b75c646af002814 (diff) | |
| download | mariadb-git-adb52cfc70b8624dfbf4d36fa966fc20b3b0452d.tar.gz | |
Fix for a bug record #307.
Very nasty bug.
It was caused by double free()-ing memory of join->select and
join->quick.
I was able to pinpoint it only after using Valgrind.
Plus better fix for bug with TMP_TABLE_PARAM.
Plus new constructor for SELECT_LEX.
Diffstat (limited to 'mysql-test/t/innodb.test')
| -rw-r--r-- | mysql-test/t/innodb.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/innodb.test b/mysql-test/t/innodb.test index 4d1a620d67f..9773d1ec17c 100644 --- a/mysql-test/t/innodb.test +++ b/mysql-test/t/innodb.test @@ -805,3 +805,11 @@ select * from t1; select * from t2; drop table t1,t2; +CREATE TABLE t1 (col1 int(1))TYPE=InnoDB; +CREATE TABLE t2 (col1 int(1),stamp TIMESTAMP(+0),INDEX stamp_idx +(stamp))TYPE=InnoDB; +insert into t1 values (1),(2),(3); +insert into t2 values (1, 20020204130000),(2, 20020204130000),(4,20020204310000 ); +SELECT col1 FROM t1 UNION SELECT col1 FROM t2 WHERE stamp < +'20020204120000' GROUP BY col1; +drop table t1,t2; |