diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2015-11-03 09:31:20 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2015-11-05 17:50:59 +0100 |
| commit | 5041de97e15e4af05003a8c6c14bfff106da570b (patch) | |
| tree | 4937735c3ae99e1df7732ffa9f12c94d18f2910e /mysql-test | |
| parent | d9119710c44d0cd785447080c43bf3c2ba2e4cac (diff) | |
| download | mariadb-git-5041de97e15e4af05003a8c6c14bfff106da570b.tar.gz | |
MDEV-8701 Crash on derived query
Make unique table check after setup_fields of update because unique table can materialize table and we do not need field resolving after materialization.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/update.result | 35 | ||||
| -rw-r--r-- | mysql-test/t/update.test | 41 |
2 files changed, 76 insertions, 0 deletions
diff --git a/mysql-test/r/update.result b/mysql-test/r/update.result index db7c2380398..2e883aa5680 100644 --- a/mysql-test/r/update.result +++ b/mysql-test/r/update.result @@ -644,4 +644,39 @@ Handler_read_rnd 2 Handler_read_rnd_deleted 0 Handler_read_rnd_next 0 drop table t1, t2; +# +#MDEV-8701: Crash on derived query +# +CREATE TABLE t1 ( +data_exit_entry_id int(11) NOT NULL, +data_entry_id int(11) NOT NULL, +data_entry_exit_id int(11) NOT NULL, +data_exit_entry_quantity double NOT NULL +) DEFAULT CHARSET=utf8; +CREATE TABLE t2 ( +data_entry_id int(11) NOT NULL, +data_entry_cost double NOT NULL, +data_entry_quantity double NOT NULL +) DEFAULT CHARSET=utf8; +create algorithm=temptable view v1 as SELECT data_entry_exit_id, data_exit_entry_quantity, data_entry_cost +FROM t1 INNER JOIN t2 as dt ON dt.data_entry_id = t1.data_entry_id; +UPDATE t2 +SET data_entry_cost += ( ( SELECT SUM(data_exit_entry_quantity * data_entry_cost) +FROM +v1 AS query +WHERE data_entry_exit_id = t2.data_entry_id +) +); +UPDATE t2 +SET data_entry_cost += ( ( SELECT SUM(data_exit_entry_quantity * data_entry_cost) +FROM +( SELECT data_entry_exit_id, data_exit_entry_quantity, data_entry_cost +FROM t1 INNER JOIN t2 as dt ON dt.data_entry_id = t1.data_entry_id) AS query +WHERE data_entry_exit_id = t2.data_entry_id +) +); +drop view v1; +drop table t1, t2; # End of MariaDB 10.0 tests diff --git a/mysql-test/t/update.test b/mysql-test/t/update.test index 05f9ce39bec..c0334a75bff 100644 --- a/mysql-test/t/update.test +++ b/mysql-test/t/update.test @@ -580,4 +580,45 @@ show status like 'Handler_read%'; drop table t1, t2; +--echo # +--echo #MDEV-8701: Crash on derived query +--echo # + +CREATE TABLE t1 ( + data_exit_entry_id int(11) NOT NULL, + data_entry_id int(11) NOT NULL, + data_entry_exit_id int(11) NOT NULL, + data_exit_entry_quantity double NOT NULL +) DEFAULT CHARSET=utf8; + +CREATE TABLE t2 ( + data_entry_id int(11) NOT NULL, + data_entry_cost double NOT NULL, + data_entry_quantity double NOT NULL +) DEFAULT CHARSET=utf8; + +create algorithm=temptable view v1 as SELECT data_entry_exit_id, data_exit_entry_quantity, data_entry_cost + FROM t1 INNER JOIN t2 as dt ON dt.data_entry_id = t1.data_entry_id; + +UPDATE t2 +SET data_entry_cost + = ( ( SELECT SUM(data_exit_entry_quantity * data_entry_cost) + FROM + v1 AS query + WHERE data_entry_exit_id = t2.data_entry_id + ) + ); + +UPDATE t2 +SET data_entry_cost + = ( ( SELECT SUM(data_exit_entry_quantity * data_entry_cost) + FROM + ( SELECT data_entry_exit_id, data_exit_entry_quantity, data_entry_cost + FROM t1 INNER JOIN t2 as dt ON dt.data_entry_id = t1.data_entry_id) AS query + WHERE data_entry_exit_id = t2.data_entry_id + ) + ); + +drop view v1; +drop table t1, t2; --echo # End of MariaDB 10.0 tests |