diff options
| author | monty@mysql.com <> | 2004-10-23 03:30:27 +0300 |
|---|---|---|
| committer | monty@mysql.com <> | 2004-10-23 03:30:27 +0300 |
| commit | 8b6839e6446fde2931583d4d8b74bb531add5062 (patch) | |
| tree | 1f64399a0e4969a64a4f1500ed9f131f3cc00bf5 /mysql-test/t/ps.test | |
| parent | f5b33f6e6ae065496688f8fd1390c4d6a0826cd2 (diff) | |
| download | mariadb-git-8b6839e6446fde2931583d4d8b74bb531add5062.tar.gz | |
Fixed wrong range test code for HEAP tables. This caused a crash when doing a range test with a key that didn't have lower or upper bound (Bug #6082)
More test cases
Diffstat (limited to 'mysql-test/t/ps.test')
| -rw-r--r-- | mysql-test/t/ps.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/ps.test b/mysql-test/t/ps.test index 76da86dc6df..978ce2bc2c3 100644 --- a/mysql-test/t/ps.test +++ b/mysql-test/t/ps.test @@ -449,3 +449,16 @@ execute stmt; select found_rows(); deallocate prepare stmt; drop table t1; + +# +# Bug#6047 "permission problem when executing mysql_stmt_execute with derived +# table" +# + +CREATE TABLE t1 (N int, M tinyint); +INSERT INTO t1 VALUES (1,0),(1,0),(2,0),(2,0),(3,0); +PREPARE stmt FROM 'UPDATE t1 AS P1 INNER JOIN (SELECT N FROM t1 GROUP BY N HAVING COUNT(M) > 1) AS P2 ON P1.N = P2.N SET P1.M = 2'; +EXECUTE stmt; +DEALLOCATE PREPARE stmt; +DROP TABLE t1; + |