Changeset: 861afffbd446 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/861afffbd446
Removed Files:
sql/test/cte/Tests/recursive_cte_correlated_subquery.test
Modified Files:
sql/test/cte/Tests/All
Branch: recursive_cte
Log Message:
removed too large (time consuming) test
diffs (45 lines):
diff --git a/sql/test/cte/Tests/All b/sql/test/cte/Tests/All
--- a/sql/test/cte/Tests/All
+++ b/sql/test/cte/Tests/All
@@ -3,7 +3,6 @@ game_of_life
incorrect_recursive_cte
insert_cte_bug_3417
recursive_cte_complex_pipelines
-#recursive_cte_correlated_subquery
recursive_cte_error
recursive_hang_2745
test_correlated_recursive_cte
diff --git a/sql/test/cte/Tests/recursive_cte_correlated_subquery.test
b/sql/test/cte/Tests/recursive_cte_correlated_subquery.test
deleted file mode 100644
--- a/sql/test/cte/Tests/recursive_cte_correlated_subquery.test
+++ /dev/null
@@ -1,29 +0,0 @@
-query I
-WITH RECURSIVE
-input(sud) AS (
-VALUES('53..7....6..195....98....6.8...6...34..8.3..17...2...6.6....28....419..5....8..79')
-),
-digits(z, lp) AS (
-SELECT CAST(lp+1 AS TEXT), cast(lp as int)+1 FROM generate_series(0,8+1,1)
t(lp)
-),
-x(s, ind) AS (
-SELECT sud, contains(sud, '.') FROM input
-UNION ALL
-SELECT
-substr(s, 1, cast(ind as int)-1) || z || substr(s, cast(ind as int)+1),
-contains(substr(s, 1, cast(ind as int)-1) || z || substr(s, cast(ind as
int)+1), '.' )
-FROM x, digits AS z
-WHERE cast(ind as int) >0
-AND NOT EXISTS (
-SELECT 1
-FROM digits AS lp
-WHERE z.z = substr(s, ((cast(ind as int)-1)/9)*9 + lp, 1)
-OR z.z = substr(s, ((cast(ind as int)-1)%9) + (lp-1)*9 + 1, 1)
-OR z.z = substr(s, (((cast(ind as int)-1)/3) % 3) * 3
-+ ((cast(ind as int)-1)/27) * 27 + lp
-+ ((lp-1) / 3) * 6, 1)
-)
-)
-SELECT s FROM x WHERE cast(ind as int)=0;
-----
-534678912672195348198342567859761423426853791713924856961537284287419635345286179
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
