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

Error Function doen't exist in trigger

    XMLWordPrintable

Details

    Description

      I use 10.2.24 mariadb on debian stretch and I've got this error:

      SET NAMES utf8;
      SET time_zone = '+00:00';
      SET foreign_key_checks = 0;
      SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
       
      DROP TABLE IF EXISTS `t1`;
      CREATE TABLE `t1` (
        `col1` int(11) NOT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
       
      INSERT INTO `t1` (`col1`) VALUES (3);
       
      DELIMITER ;;
       
      CREATE TRIGGER `t1_bu` BEFORE UPDATE ON `t1` FOR EACH ROW
      BEGIN 
          DECLARE TEST INT(11) DEFAULT 0;
       
      SET TEST=yopyop();
      END;;
       
      DELIMITER ;
       
      DROP TABLE IF EXISTS `t2`;
      CREATE TABLE `t2` (
        `col1` int(11) NOT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
       
      INSERT INTO `t2` (`col1`) VALUES
      (3);
       
      UPDATE t1,t2 SET t1.col1=4 WHERE t1.col1=3 AND t1.col1=t2.col1; 
      Error (1305): FUNCTION yop.yopyop does not exist 
      

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              Emmanuel Emmanuel
              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.