diff options
| author | andrey@lmy004. <> | 2005-09-08 21:30:05 +0200 |
|---|---|---|
| committer | andrey@lmy004. <> | 2005-09-08 21:30:05 +0200 |
| commit | 1a46ea1057ef0a102e337e95731b7bd9d41b8618 (patch) | |
| tree | cd57feea4289bdb595fdb50a324b5904d8ee07eb /mysql-test/r/ps.result | |
| parent | b5583947dff1011a4fcc85aa36f8a0e9412ffa08 (diff) | |
| download | mariadb-git-1a46ea1057ef0a102e337e95731b7bd9d41b8618.tar.gz | |
fix for bug #12651 (item of a prepared query allocated on non-permanent
are thus dangling later)
Diffstat (limited to 'mysql-test/r/ps.result')
| -rw-r--r-- | mysql-test/r/ps.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/ps.result b/mysql-test/r/ps.result index dc78f8d04ea..f1c3672083d 100644 --- a/mysql-test/r/ps.result +++ b/mysql-test/r/ps.result @@ -773,6 +773,14 @@ ERROR 42000: You have an error in your SQL syntax; check the manual that corresp select ? from t1; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? from t1' at line 1 drop table t1; +CREATE TABLE b12651_T1(a int) ENGINE=MYISAM; +CREATE TABLE b12651_T2(b int) ENGINE=MYISAM; +CREATE VIEW b12651_V1 as SELECT b FROM b12651_T2; +PREPARE b12651 FROM 'SELECT 1 FROM b12651_T1 WHERE a IN (SELECT b FROM b12651_V1)'; +EXECUTE b12651; +1 +DROP VIEW b12651_V1; +DROP TABLE b12651_T1, b12651_T2; prepare stmt from "select @@time_zone"; execute stmt; @@time_zone |