diff options
| author | Georgi Kodinov <Georgi.Kodinov@Oracle.com> | 2010-10-04 15:42:16 +0300 |
|---|---|---|
| committer | Georgi Kodinov <Georgi.Kodinov@Oracle.com> | 2010-10-04 15:42:16 +0300 |
| commit | dd2e3db48fce43f6249e1c23b3cf0f5057b41d4e (patch) | |
| tree | 0b41fbab5c8e486500b5c53bbe818e62f6f583f2 /mysql-test/r/handler_innodb.result | |
| parent | 99039957feba6543c7d52b6dcfc5b9f349ee0047 (diff) | |
| parent | 774a5778d5db1062c26bd55d02a09c5d98a74525 (diff) | |
| download | mariadb-git-dd2e3db48fce43f6249e1c23b3cf0f5057b41d4e.tar.gz | |
merge
Diffstat (limited to 'mysql-test/r/handler_innodb.result')
| -rw-r--r-- | mysql-test/r/handler_innodb.result | 17 |
1 files changed, 16 insertions, 1 deletions
diff --git a/mysql-test/r/handler_innodb.result b/mysql-test/r/handler_innodb.result index 121cfa89f1c..66914285733 100644 --- a/mysql-test/r/handler_innodb.result +++ b/mysql-test/r/handler_innodb.result @@ -1726,7 +1726,22 @@ CREATE TABLE t1(a INT); INSERT INTO t1 VALUES (1); HANDLER t1 OPEN; HANDLER t1 READ FIRST WHERE f1() = 1; -ERROR 42S02: Table 'test.t2' doesn't exist +ERROR 42000: This version of MySQL doesn't yet support 'stored functions in HANDLER ... READ' +HANDLER t1 CLOSE; +DROP FUNCTION f1; +DROP TABLE t1; +# +# Bug#54920 Stored functions are allowed in HANDLER statements, +# but broken. +# +DROP TABLE IF EXISTS t1; +DROP FUNCTION IF EXISTS f1; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (1), (2); +CREATE FUNCTION f1() RETURNS INT RETURN 1; +HANDLER t1 OPEN; +HANDLER t1 READ FIRST WHERE f1() = 1; +ERROR 42000: This version of MySQL doesn't yet support 'stored functions in HANDLER ... READ' HANDLER t1 CLOSE; DROP FUNCTION f1; DROP TABLE t1; |