diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2019-12-12 14:41:51 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2019-12-12 14:41:51 +0200 |
| commit | 0a20e5ab77f8a6532b41ea2518626397059ccf42 (patch) | |
| tree | 1ef90ec718bc16d80ca65eb89537f697e1482f09 /mysql-test/main/cte_nonrecursive.test | |
| parent | e0f9540bcc6ab1618b6fd475f02e019401c4c295 (diff) | |
| parent | beec9c0e19284a0e50d3629f4cb2486007b0333b (diff) | |
| download | mariadb-git-0a20e5ab77f8a6532b41ea2518626397059ccf42.tar.gz | |
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/main/cte_nonrecursive.test')
| -rw-r--r-- | mysql-test/main/cte_nonrecursive.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/main/cte_nonrecursive.test b/mysql-test/main/cte_nonrecursive.test index bd8af55071a..41a5b815bc7 100644 --- a/mysql-test/main/cte_nonrecursive.test +++ b/mysql-test/main/cte_nonrecursive.test @@ -1182,3 +1182,23 @@ with t as (select 1 as t) select * from t; with columns as (select 1 as t) select * from columns; use test; + +--echo # +--echo # MDEV-18460: Server crashed in strmake / tdc_create_key / +--echo # THD::create_tmp_table_def_key +--echo # + +--connect con1,localhost,root,, +--change_user root,, + +CREATE TEMPORARY TABLE test.t (a INT); +WITH cte AS (SELECT 1) SELECT * FROM cte; +WITH t AS (SELECT 1) SELECT * FROM t; +--error ER_NO_DB_ERROR +WITH cte AS (SELECT 1) SELECT * FROM t; +DROP TABLE test.t; + +--connection default +--disconnect con1 + +--echo # End of 10.2 tests |