summaryrefslogtreecommitdiff
path: root/mysql-test/r/cte_recursive.result
diff options
context:
space:
mode:
authorNirbhay Choubey <nirbhay@mariadb.com>2016-12-19 16:28:19 -0500
committerNirbhay Choubey <nirbhay@mariadb.com>2017-02-10 06:30:42 -0500
commit185d140f191f550d030550f6718103a89eb64212 (patch)
tree21d3960b504cea7182ea60eaff6e2d4dffee1319 /mysql-test/r/cte_recursive.result
parent25f6d1dad70a5f5b35692a23586a46c066f8f26d (diff)
downloadmariadb-git-185d140f191f550d030550f6718103a89eb64212.tar.gz
MDEV-7635: Renamed standards_compliant_cte to standard_compliant_cte
Diffstat (limited to 'mysql-test/r/cte_recursive.result')
-rw-r--r--mysql-test/r/cte_recursive.result10
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/r/cte_recursive.result b/mysql-test/r/cte_recursive.result
index 20ca5c8f8cb..0624099e365 100644
--- a/mysql-test/r/cte_recursive.result
+++ b/mysql-test/r/cte_recursive.result
@@ -955,7 +955,7 @@ where folks.id = ma.id and (mother not in (select id from ancestor_ids))
select generation, name from ancestor_ids a, folks
where a.id = folks.id;
ERROR HY000: Restrictions imposed on recursive definitions are violated for table 'ancestor_ids'
-set standards_compliant_cte=0;
+set standard_compliant_cte=0;
with recursive
ancestor_ids (id, generation)
as
@@ -999,7 +999,7 @@ generation name
2 Grandma Sally
2 Grandpa Ben
3 Grandgrandma Martha
-set standards_compliant_cte=1;
+set standard_compliant_cte=1;
with recursive
coupled_ancestor_ids (id)
as
@@ -1023,7 +1023,7 @@ n.father is not null and n.mother is not null
select p.* from coupled_ancestor_ids a, folks p
where a.id = p.id;
ERROR HY000: Restrictions imposed on recursive definitions are violated for table 'coupled_ancestor_ids'
-set statement standards_compliant_cte=0 for
+set statement standard_compliant_cte=0 for
with recursive
coupled_ancestor_ids (id)
as
@@ -1073,7 +1073,7 @@ where p.id = a.id
)
select * from ancestors;
ERROR HY000: Restrictions imposed on recursive definitions are violated for table 'ancestor_ids'
-set statement standards_compliant_cte=0 for
+set statement standard_compliant_cte=0 for
with recursive
ancestor_ids (id)
as
@@ -1156,7 +1156,7 @@ where p.id = a.id
)
select * from ancestors;
ERROR HY000: Restrictions imposed on recursive definitions are violated for table 'ancestor_ids'
-set statement standards_compliant_cte=0 for
+set statement standard_compliant_cte=0 for
with recursive
ancestor_ids (id, generation)
as