Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.2(EOL)
-
None
Description
I'm testing the MDEV-10134 feature tree, branch bb-10.2-default.
I add this script to mysql-test/t/udf.test and run "./mtr udf"
--replace_result $UDF_EXAMPLE_SO UDF_EXAMPLE_LIB
|
eval CREATE FUNCTION metaphon RETURNS STRING SONAME "$UDF_EXAMPLE_SO";
|
SELECT METAPHON('Hello');
|
CREATE TABLE t1 (a VARCHAR(10), b VARCHAR(10) DEFAULT METAPHON(a));
|
INSERT INTO t1 (a) VALUES ('Hello');
|
SELECT * FROM t1;
|
DROP FUNCTION METAPHON;
|
# QQ: this should return an error
|
INSERT INTO t1 (a) VALUES ('Hello');
|
SELECT * FROM t1;
|
DROP TABLE t1;
|
After the function METAPHON is dropped, INSERT still uses it.
It should return an error in the INSERT which goes after "DROP FUNCTION".
Attachments
Issue Links
- blocks
-
MDEV-10134 Add full support for DEFAULT
- Closed