diff options
author | Galina Shalygina <galashalygina@gmail.com> | 2016-05-19 22:07:53 +0300 |
---|---|---|
committer | Galina Shalygina <galashalygina@gmail.com> | 2016-05-19 22:07:53 +0300 |
commit | 46a2e4139830d176c31be1c53e533167ea4f95b9 (patch) | |
tree | bb940fefff718b925609a85dabba3ba86c26cf50 /sql/share | |
parent | 3b47632bfc74a548c2f0a057f39e99a8a761a57a (diff) | |
download | mariadb-git-46a2e4139830d176c31be1c53e533167ea4f95b9.tar.gz |
Fixed many problems in the code of With_element::check_unrestricted_recursive().
Added the check whether there are set functions in the specifications of recursive CTE.
Added the check whether there are recursive references in subqueries.
Introduced boolean system variable 'standards_compliant_cte'. By default it's set to 'on'.
When it's set to 'off' non-standard compliant CTE can be executed.
Diffstat (limited to 'sql/share')
-rw-r--r-- | sql/share/errmsg-utf8.txt | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/share/errmsg-utf8.txt b/sql/share/errmsg-utf8.txt index 38b05ca9dce..00228ee1062 100644 --- a/sql/share/errmsg-utf8.txt +++ b/sql/share/errmsg-utf8.txt @@ -7156,6 +7156,8 @@ ER_RECURSIVE_WITHOUT_ANCHORS eng "No anchors for recursive WITH element '%s'" ER_REF_TO_RECURSIVE_WITH_TABLE_IN_DERIVED eng "Reference to recursive WITH table '%s' in materiazed derived" +ER_NOT_STANDARDS_COMPLIANT_RECURSIVE + eng "Restrictions imposed on recursive definitions are violated for table '%s'" # # Internal errors, not used # |