Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10207

DEFAULT udf(x) does not return an error when UDF is dropped

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.2(EOL)
    • N/A
    • OTHER
    • 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

          Activity

            People

              serg Sergei Golubchik
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.