maria-developers team mailing list archive

Thread
Date

Re: dd32ca1: MDEV-5973: MySQL Bug#11757486:49539: NON-DESCRIPTIVE ERR (ERROR 0 FROM STORAGE ENGINE) WITH MULTI-TABLE UPDATE

To: maria-developers@xxxxxxxxxxxxxxxxxxx
From: Sergei Golubchik <serg@xxxxxxxxxxx>
Date: Tue, 21 Jun 2016 17:18:20 +0200
Cc: sanja@xxxxxxxxxxx
In-reply-to: <5767e331.c445c20a.9300e.ffffd3b6@mx.google.com>
User-agent: Mutt/1.5.24 (2015-08-30)

Hi, Oleksandr!

On Jun 20, Oleksandr Byelkin wrote:
> revision-id: dd32ca182246fccc7ba8d7c612af3ddd27fbf4af (mariadb-10.0.25-11-gdd32ca1)
> parent(s): 70ad689b11bfbd8a30a777f4893a5384628c00e7
> committer: Oleksandr Byelkin
> timestamp: 2016-06-20 14:35:58 +0200
> message:
> 
> MDEV-5973: MySQL  Bug#11757486:49539: NON-DESCRIPTIVE ERR (ERROR 0 FROM STORAGE ENGINE) WITH MULTI-TABLE UPDATE
> 
> Condition in processing IGNORE clause for UPDATE & multi-table UPDATE made the same.
> 
> diff --git a/mysql-test/r/multi_update.result b/mysql-test/r/multi_update.result
> index 688184f..9e47fe2 100644
> --- a/mysql-test/r/multi_update.result
> +++ b/mysql-test/r/multi_update.result
> @@ -1039,4 +1039,24 @@ f1	f2
>  1	97
>  DROP TABLE t1, t2;
>  DROP VIEW v1;
> +#
> +# MDEV-5973: MySQL  Bug#11757486:49539: NON-DESCRIPTIVE ERR (ERROR 0
> +# FROM STORAGE ENGINE) WITH MULTI-TABLE UPDATE
> +#
> +CREATE TABLE table_11757486 (field1 tinyint) ENGINE=INNODB;
> +INSERT INTO table_11757486 VALUES (0),(0);
> +SET SESSION SQL_MODE='STRICT_ALL_TABLES';
> +UPDATE IGNORE (SELECT 128 as col1) x, table_11757486 SET field1=x.col1;

Please add same tests in a single-table update version:

  UPDATE IGNORE table_11757486 SET field1=128;

all three UPDATEs should be in both single and multi-table versions.

Regards,
Sergei
Chief Architect MariaDB
and security@xxxxxxxxxxx