diff options
| author | Igor Babaev <igor@askmonty.org> | 2018-02-22 10:08:49 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2018-02-22 10:26:56 -0800 |
| commit | 907b236112d95681cb09be98197b97bbd2b525dd (patch) | |
| tree | 79eee71c3ea4bb29a7f8e0168f31b922693a798f /sql/sql_cte.h | |
| parent | 988ec800edb3dd9238b6f3948157d21bdb0c083b (diff) | |
| download | mariadb-git-907b236112d95681cb09be98197b97bbd2b525dd.tar.gz | |
Fixed MDEV-14883 Usage of EXCEPT and INTERSECT in recursive CTE
is not supported
Allowed to use recursive references in derived tables.
As a result usage of recursive references in operands of
INTERSECT / EXCEPT is now supported.
Diffstat (limited to 'sql/sql_cte.h')
| -rw-r--r-- | sql/sql_cte.h | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/sql/sql_cte.h b/sql/sql_cte.h index 13e9b83955c..16b473f0665 100644 --- a/sql/sql_cte.h +++ b/sql/sql_cte.h @@ -146,7 +146,9 @@ public: select_union_recursive *rec_result; /* List of Item_subselects containing recursive references to this CTE */ - SQL_I_List<Item_subselect> sq_with_rec_ref; + SQL_I_List<Item_subselect> sq_with_rec_ref; + /* List of derived tables containing recursive references to this CTE */ + SQL_I_List<TABLE_LIST> derived_with_rec_ref; With_element(LEX_CSTRING *name, List <LEX_CSTRING> list, |