diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2017-02-09 12:08:57 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2017-02-10 10:22:03 +0100 |
| commit | ae3072c0af04ac5b18a81425a8aacb796126f8a2 (patch) | |
| tree | c5b173aef8a65c3ff1e29441c1f1ca7ebf68df67 /mysql-test/r/derived.result | |
| parent | ee51f5823621acf5b703254f723690576a713585 (diff) | |
| download | mariadb-git-ae3072c0af04ac5b18a81425a8aacb796126f8a2.tar.gz | |
MDEV-10554: Assertion `!derived->first_select()->exclude_from_table_unique_test || derived->outer_select()-> exclude_from_table_unique_test' failed in TABLE_LIST::set_check_merged()
Mark and check excluded because of merging derived tables and views.
Diffstat (limited to 'mysql-test/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index 9e550284163..a4c994f8745 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -1064,3 +1064,21 @@ DROP TABLE t1; # # End of 10.1 tests # +# +# MDEV-10554: Assertion `!derived->first_select()-> +# exclude_from_table_unique_test || derived->outer_select()-> +# exclude_from_table_unique_test' +# failed in TABLE_LIST::set_check_merged() +# +CREATE TABLE t1 (f INT); +CREATE ALGORITHM = TEMPTABLE VIEW v1 AS SELECT * FROM ( SELECT * FROM t1 ) AS sq; +PREPARE stmt FROM 'SELECT * FROM v1'; +EXECUTE stmt; +f +EXECUTE stmt; +f +drop view v1; +drop table t1; +# +# End of 10.2 tests +# |