diff options
| author | Alexey Kopytov <Alexey.Kopytov@Sun.com> | 2009-12-25 13:56:50 +0300 |
|---|---|---|
| committer | Alexey Kopytov <Alexey.Kopytov@Sun.com> | 2009-12-25 13:56:50 +0300 |
| commit | 24fc798fc7a993a60b3f8dbfc56b37005dcdf530 (patch) | |
| tree | d33ce0a47fbf5181f9c5ebfeddb7830a2e9f7223 /mysql-test/r/sp.result | |
| parent | 1d13320d9aebc198f0b84c8c1454f92978b3e89b (diff) | |
| parent | b367b03bcb3be508f0ffad37e9aa78f62c680252 (diff) | |
| download | mariadb-git-24fc798fc7a993a60b3f8dbfc56b37005dcdf530.tar.gz | |
Manual merge of mysql-5.1-bugteam into mysql-trunk-merge.
Conflicts:
mysql-test/collections/default.experimental
Diffstat (limited to 'mysql-test/r/sp.result')
| -rw-r--r-- | mysql-test/r/sp.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result index 91a4ceae55c..be74186b005 100644 --- a/mysql-test/r/sp.result +++ b/mysql-test/r/sp.result @@ -6907,6 +6907,22 @@ CALL p1(); CALL p1(); DROP PROCEDURE p1; DROP TABLE t1; +CREATE TABLE t1 ( f1 integer, primary key (f1)); +CREATE TABLE t2 LIKE t1; +CREATE TEMPORARY TABLE t3 LIKE t1; +CREATE PROCEDURE p1 () BEGIN SELECT f1 FROM t3 AS A WHERE A.f1 IN ( SELECT f1 FROM t3 ) ; +END| +CALL p1; +ERROR HY000: Can't reopen table: 'A' +CREATE VIEW t3 AS SELECT f1 FROM t2 A WHERE A.f1 IN ( SELECT f1 FROM t2 ); +DROP TABLE t3; +CALL p1; +f1 +CALL p1; +f1 +DROP PROCEDURE p1; +DROP TABLE t1, t2; +DROP VIEW t3; # # Bug #46629: Item_in_subselect::val_int(): Assertion `0' # on subquery inside a SP |