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

INSERT ... RETURNING sends metadata on error

    XMLWordPrintable

    Details

      Description

      When INSERT ... RETURNING fails, it sends metadata and afterwards error packet:

        rc= mysql_query(mysql, "CREATE TEMPORARY TABLE t1 (a int not null auto_increment primary key, b json)");
        check_mysql_rc(rc, mysql);
       
        rc= mysql_query(mysql, "INSERT INTO t1 (a,b) VALUES (NULL, '[incorrect json]') RETURNING a");
        check_mysql_rc(rc, mysql);  /* <- this should fail */
       
        result= mysql_store_result(mysql);
        mysql_free_result(result);
       
        diag("Error: %s", mysql_error(mysql));
      

      Output:

      Error: CONSTRAINT `t1.b` failed for `test`.`t1`
      

        Attachments

          Activity

            People

            Assignee:
            sanja Oleksandr Byelkin
            Reporter:
            georg Georg Richter
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated: