diff options
| author | Martin Hansson <martin.hansson@oracle.com> | 2010-09-07 10:00:52 +0200 |
|---|---|---|
| committer | Martin Hansson <martin.hansson@oracle.com> | 2010-09-07 10:00:52 +0200 |
| commit | 5c5cd5764964def5ef85e9504a53f465c1ad6ec9 (patch) | |
| tree | 9f7e4eb9b1cbd07f92d0278414b67f7473532f06 /mysql-test/r/multi_update.result | |
| parent | 000c50afe6c2918d48384b691fbab1d865fee77a (diff) | |
| parent | 446cc653c0ab13a6fec8ab54de9f5596389b08bc (diff) | |
| download | mariadb-git-5c5cd5764964def5ef85e9504a53f465c1ad6ec9.tar.gz | |
Merge of fix for Bug#54543. Test case only (bug is not present in this tree).
Diffstat (limited to 'mysql-test/r/multi_update.result')
| -rw-r--r-- | mysql-test/r/multi_update.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/r/multi_update.result b/mysql-test/r/multi_update.result index 66fe104ba0b..07a92e2abf0 100644 --- a/mysql-test/r/multi_update.result +++ b/mysql-test/r/multi_update.result @@ -649,4 +649,24 @@ SET SESSION sql_safe_updates = 1; UPDATE IGNORE t1, t1 t1a SET t1.a = 1 WHERE t1a.a = 1; ERROR HY000: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column DROP TABLE t1; +# +# Bug#54543: update ignore with incorrect subquery leads to assertion +# failure: inited==INDEX +# +SET SESSION sql_safe_updates = 0; +CREATE TABLE t1 ( a INT ); +INSERT INTO t1 VALUES (1), (2); +CREATE TABLE t2 ( a INT ); +INSERT INTO t2 VALUES (1), (2); +CREATE TABLE t3 ( a INT ); +INSERT INTO t3 VALUES (1), (2); +# Should not crash +UPDATE IGNORE +( SELECT ( SELECT COUNT(*) FROM t1 GROUP BY a, @v ) a FROM t2 ) x, t3 +SET t3.a = 0; +Warnings: +Error 1242 Subquery returns more than 1 row +Error 1242 Subquery returns more than 1 row +DROP TABLE t1, t2, t3; +SET SESSION sql_safe_updates = DEFAULT; end of tests |