Home
last modified time | relevance | path

Searched refs:cte (Results 1 – 25 of 2425) sorted by relevance

12345678910>>...97

/dports/databases/postgresql14-pltcl/postgresql-14.1/src/backend/rewrite/
H A DrewriteSearchCycle.c226 Assert(cte->search_clause || cte->cycle_clause); in rewriteSearchAndCycle()
228 cte = copyObject(cte); in rewriteSearchAndCycle()
652 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, search_seq_type); in rewriteSearchAndCycle()
653 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, -1); in rewriteSearchAndCycle()
654 cte->ctecolcollations = lappend_oid(cte->ctecolcollations, InvalidOid); in rewriteSearchAndCycle()
658 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, cte->cycle_clause->cycle_mark_type); in rewriteSearchAndCycle()
659 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, cte->cycle_clause->cycle_mark_typmod); in rewriteSearchAndCycle()
660 …cte->ctecolcollations = lappend_oid(cte->ctecolcollations, cte->cycle_clause->cycle_mark_collation… in rewriteSearchAndCycle()
662 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, RECORDARRAYOID); in rewriteSearchAndCycle()
663 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, -1); in rewriteSearchAndCycle()
[all …]
/dports/databases/postgresql14-server/postgresql-14.1/src/backend/rewrite/
H A DrewriteSearchCycle.c226 Assert(cte->search_clause || cte->cycle_clause); in rewriteSearchAndCycle()
228 cte = copyObject(cte); in rewriteSearchAndCycle()
652 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, search_seq_type); in rewriteSearchAndCycle()
653 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, -1); in rewriteSearchAndCycle()
654 cte->ctecolcollations = lappend_oid(cte->ctecolcollations, InvalidOid); in rewriteSearchAndCycle()
658 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, cte->cycle_clause->cycle_mark_type); in rewriteSearchAndCycle()
659 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, cte->cycle_clause->cycle_mark_typmod); in rewriteSearchAndCycle()
660 …cte->ctecolcollations = lappend_oid(cte->ctecolcollations, cte->cycle_clause->cycle_mark_collation… in rewriteSearchAndCycle()
662 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, RECORDARRAYOID); in rewriteSearchAndCycle()
663 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, -1); in rewriteSearchAndCycle()
[all …]
/dports/databases/postgresql14-contrib/postgresql-14.1/src/backend/rewrite/
H A DrewriteSearchCycle.c226 Assert(cte->search_clause || cte->cycle_clause); in rewriteSearchAndCycle()
228 cte = copyObject(cte); in rewriteSearchAndCycle()
652 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, search_seq_type); in rewriteSearchAndCycle()
653 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, -1); in rewriteSearchAndCycle()
654 cte->ctecolcollations = lappend_oid(cte->ctecolcollations, InvalidOid); in rewriteSearchAndCycle()
658 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, cte->cycle_clause->cycle_mark_type); in rewriteSearchAndCycle()
659 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, cte->cycle_clause->cycle_mark_typmod); in rewriteSearchAndCycle()
660 …cte->ctecolcollations = lappend_oid(cte->ctecolcollations, cte->cycle_clause->cycle_mark_collation… in rewriteSearchAndCycle()
662 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, RECORDARRAYOID); in rewriteSearchAndCycle()
663 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, -1); in rewriteSearchAndCycle()
[all …]
/dports/databases/postgresql14-docs/postgresql-14.1/src/backend/rewrite/
H A DrewriteSearchCycle.c226 Assert(cte->search_clause || cte->cycle_clause); in rewriteSearchAndCycle()
228 cte = copyObject(cte); in rewriteSearchAndCycle()
652 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, search_seq_type); in rewriteSearchAndCycle()
653 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, -1); in rewriteSearchAndCycle()
654 cte->ctecolcollations = lappend_oid(cte->ctecolcollations, InvalidOid); in rewriteSearchAndCycle()
658 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, cte->cycle_clause->cycle_mark_type); in rewriteSearchAndCycle()
659 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, cte->cycle_clause->cycle_mark_typmod); in rewriteSearchAndCycle()
660 …cte->ctecolcollations = lappend_oid(cte->ctecolcollations, cte->cycle_clause->cycle_mark_collation… in rewriteSearchAndCycle()
662 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, RECORDARRAYOID); in rewriteSearchAndCycle()
663 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, -1); in rewriteSearchAndCycle()
[all …]
/dports/databases/postgresql14-plpython/postgresql-14.1/src/backend/rewrite/
H A DrewriteSearchCycle.c226 Assert(cte->search_clause || cte->cycle_clause); in rewriteSearchAndCycle()
228 cte = copyObject(cte); in rewriteSearchAndCycle()
652 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, search_seq_type); in rewriteSearchAndCycle()
653 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, -1); in rewriteSearchAndCycle()
654 cte->ctecolcollations = lappend_oid(cte->ctecolcollations, InvalidOid); in rewriteSearchAndCycle()
658 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, cte->cycle_clause->cycle_mark_type); in rewriteSearchAndCycle()
659 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, cte->cycle_clause->cycle_mark_typmod); in rewriteSearchAndCycle()
660 …cte->ctecolcollations = lappend_oid(cte->ctecolcollations, cte->cycle_clause->cycle_mark_collation… in rewriteSearchAndCycle()
662 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, RECORDARRAYOID); in rewriteSearchAndCycle()
663 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, -1); in rewriteSearchAndCycle()
[all …]
/dports/databases/postgresql14-plperl/postgresql-14.1/src/backend/rewrite/
H A DrewriteSearchCycle.c226 Assert(cte->search_clause || cte->cycle_clause); in rewriteSearchAndCycle()
228 cte = copyObject(cte); in rewriteSearchAndCycle()
652 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, search_seq_type); in rewriteSearchAndCycle()
653 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, -1); in rewriteSearchAndCycle()
654 cte->ctecolcollations = lappend_oid(cte->ctecolcollations, InvalidOid); in rewriteSearchAndCycle()
658 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, cte->cycle_clause->cycle_mark_type); in rewriteSearchAndCycle()
659 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, cte->cycle_clause->cycle_mark_typmod); in rewriteSearchAndCycle()
660 …cte->ctecolcollations = lappend_oid(cte->ctecolcollations, cte->cycle_clause->cycle_mark_collation… in rewriteSearchAndCycle()
662 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, RECORDARRAYOID); in rewriteSearchAndCycle()
663 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, -1); in rewriteSearchAndCycle()
[all …]
/dports/databases/postgresql14-client/postgresql-14.1/src/backend/rewrite/
H A DrewriteSearchCycle.c226 Assert(cte->search_clause || cte->cycle_clause); in rewriteSearchAndCycle()
228 cte = copyObject(cte); in rewriteSearchAndCycle()
652 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, search_seq_type); in rewriteSearchAndCycle()
653 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, -1); in rewriteSearchAndCycle()
654 cte->ctecolcollations = lappend_oid(cte->ctecolcollations, InvalidOid); in rewriteSearchAndCycle()
658 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, cte->cycle_clause->cycle_mark_type); in rewriteSearchAndCycle()
659 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, cte->cycle_clause->cycle_mark_typmod); in rewriteSearchAndCycle()
660 …cte->ctecolcollations = lappend_oid(cte->ctecolcollations, cte->cycle_clause->cycle_mark_collation… in rewriteSearchAndCycle()
662 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, RECORDARRAYOID); in rewriteSearchAndCycle()
663 cte->ctecoltypmods = lappend_int(cte->ctecoltypmods, -1); in rewriteSearchAndCycle()
[all …]
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/r/
H A Dderived_limit.result11 -> Table scan on cte
16 WITH cte AS (SELECT * FROM t1 LIMIT 5) SELECT * FROM cte;
24 SELECT * FROM cte;
26 -> Table scan on cte
34 SELECT * FROM cte;
42 SELECT * FROM cte;
52 SELECT * FROM cte;
335 SELECT /*+ no_bnl() */ * FROM cte cte1, cte cte2;
350 SELECT /*+ no_bnl() */ * FROM cte cte1, cte cte2;
370 FROM cte cte1,
[all …]
/dports/lang/ypsilon/ypsilon-0.9.6-update3/heap/boot/
H A Dcompile.scm72 (lambda (e cte)
91 (lambda (vars cte)
92 (cons vars cte)))
95 (lambda (e cte)
109 (lambda (e cte)
119 (let ((cte (cte-extend-iloc vars cte)))
237 (lambda (form cte)
290 (lambda (form cte)
298 (lambda (form cte)
398 (let ((cte (cte-extend-iloc (list (car binding)) cte)))
[all …]
/dports/databases/postgresql14-server/postgresql-14.1/src/backend/parser/
H A Dparse_cte.c195 CommonTableExpr *cte = cstate.items[i].cte; in transformWithClause() local
205 CommonTableExpr *cte = cstate.items[i].cte; in transformWithClause() local
281 analyzeCTETargetList(pstate, cte, GetCTETargetList(cte)); in analyzeCTE()
342 if (cte->search_clause || cte->cycle_clause) in analyzeCTE()
514 if (cte->search_clause && cte->cycle_clause) in analyzeCTE()
561 cte->ctecolnames = copyObject(cte->aliascolnames); in analyzeCTETargetList()
562 cte->ctecoltypes = cte->ctecoltypmods = cte->ctecolcollations = NIL; in analyzeCTETargetList()
604 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, coltype); in analyzeCTETargetList()
628 CommonTableExpr *cte = cstate->items[i].cte; in makeDependencyGraph() local
676 CommonTableExpr *cte = cstate->items[i].cte; in makeDependencyGraphWalker() local
[all …]
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/backend/parser/
H A Dparse_cte.c195 CommonTableExpr *cte = cstate.items[i].cte; in transformWithClause() local
205 CommonTableExpr *cte = cstate.items[i].cte; in transformWithClause() local
281 analyzeCTETargetList(pstate, cte, GetCTETargetList(cte)); in analyzeCTE()
342 if (cte->search_clause || cte->cycle_clause) in analyzeCTE()
514 if (cte->search_clause && cte->cycle_clause) in analyzeCTE()
561 cte->ctecolnames = copyObject(cte->aliascolnames); in analyzeCTETargetList()
562 cte->ctecoltypes = cte->ctecoltypmods = cte->ctecolcollations = NIL; in analyzeCTETargetList()
604 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, coltype); in analyzeCTETargetList()
628 CommonTableExpr *cte = cstate->items[i].cte; in makeDependencyGraph() local
676 CommonTableExpr *cte = cstate->items[i].cte; in makeDependencyGraphWalker() local
[all …]
/dports/databases/postgresql14-contrib/postgresql-14.1/src/backend/parser/
H A Dparse_cte.c195 CommonTableExpr *cte = cstate.items[i].cte; in transformWithClause() local
205 CommonTableExpr *cte = cstate.items[i].cte; in transformWithClause() local
281 analyzeCTETargetList(pstate, cte, GetCTETargetList(cte)); in analyzeCTE()
342 if (cte->search_clause || cte->cycle_clause) in analyzeCTE()
514 if (cte->search_clause && cte->cycle_clause) in analyzeCTE()
561 cte->ctecolnames = copyObject(cte->aliascolnames); in analyzeCTETargetList()
562 cte->ctecoltypes = cte->ctecoltypmods = cte->ctecolcollations = NIL; in analyzeCTETargetList()
604 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, coltype); in analyzeCTETargetList()
628 CommonTableExpr *cte = cstate->items[i].cte; in makeDependencyGraph() local
676 CommonTableExpr *cte = cstate->items[i].cte; in makeDependencyGraphWalker() local
[all …]
/dports/databases/postgresql14-plpython/postgresql-14.1/src/backend/parser/
H A Dparse_cte.c195 CommonTableExpr *cte = cstate.items[i].cte; in transformWithClause() local
205 CommonTableExpr *cte = cstate.items[i].cte; in transformWithClause() local
281 analyzeCTETargetList(pstate, cte, GetCTETargetList(cte)); in analyzeCTE()
342 if (cte->search_clause || cte->cycle_clause) in analyzeCTE()
514 if (cte->search_clause && cte->cycle_clause) in analyzeCTE()
561 cte->ctecolnames = copyObject(cte->aliascolnames); in analyzeCTETargetList()
562 cte->ctecoltypes = cte->ctecoltypmods = cte->ctecolcollations = NIL; in analyzeCTETargetList()
604 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, coltype); in analyzeCTETargetList()
628 CommonTableExpr *cte = cstate->items[i].cte; in makeDependencyGraph() local
676 CommonTableExpr *cte = cstate->items[i].cte; in makeDependencyGraphWalker() local
[all …]
/dports/databases/postgresql14-plperl/postgresql-14.1/src/backend/parser/
H A Dparse_cte.c195 CommonTableExpr *cte = cstate.items[i].cte; in transformWithClause() local
205 CommonTableExpr *cte = cstate.items[i].cte; in transformWithClause() local
281 analyzeCTETargetList(pstate, cte, GetCTETargetList(cte)); in analyzeCTE()
342 if (cte->search_clause || cte->cycle_clause) in analyzeCTE()
514 if (cte->search_clause && cte->cycle_clause) in analyzeCTE()
561 cte->ctecolnames = copyObject(cte->aliascolnames); in analyzeCTETargetList()
562 cte->ctecoltypes = cte->ctecoltypmods = cte->ctecolcollations = NIL; in analyzeCTETargetList()
604 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, coltype); in analyzeCTETargetList()
628 CommonTableExpr *cte = cstate->items[i].cte; in makeDependencyGraph() local
676 CommonTableExpr *cte = cstate->items[i].cte; in makeDependencyGraphWalker() local
[all …]
/dports/databases/postgresql14-client/postgresql-14.1/src/backend/parser/
H A Dparse_cte.c195 CommonTableExpr *cte = cstate.items[i].cte; in transformWithClause() local
205 CommonTableExpr *cte = cstate.items[i].cte; in transformWithClause() local
281 analyzeCTETargetList(pstate, cte, GetCTETargetList(cte)); in analyzeCTE()
342 if (cte->search_clause || cte->cycle_clause) in analyzeCTE()
514 if (cte->search_clause && cte->cycle_clause) in analyzeCTE()
561 cte->ctecolnames = copyObject(cte->aliascolnames); in analyzeCTETargetList()
562 cte->ctecoltypes = cte->ctecoltypmods = cte->ctecolcollations = NIL; in analyzeCTETargetList()
604 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, coltype); in analyzeCTETargetList()
628 CommonTableExpr *cte = cstate->items[i].cte; in makeDependencyGraph() local
676 CommonTableExpr *cte = cstate->items[i].cte; in makeDependencyGraphWalker() local
[all …]
/dports/databases/postgresql14-docs/postgresql-14.1/src/backend/parser/
H A Dparse_cte.c195 CommonTableExpr *cte = cstate.items[i].cte; in transformWithClause() local
205 CommonTableExpr *cte = cstate.items[i].cte; in transformWithClause() local
281 analyzeCTETargetList(pstate, cte, GetCTETargetList(cte)); in analyzeCTE()
342 if (cte->search_clause || cte->cycle_clause) in analyzeCTE()
514 if (cte->search_clause && cte->cycle_clause) in analyzeCTE()
561 cte->ctecolnames = copyObject(cte->aliascolnames); in analyzeCTETargetList()
562 cte->ctecoltypes = cte->ctecoltypmods = cte->ctecolcollations = NIL; in analyzeCTETargetList()
604 cte->ctecoltypes = lappend_oid(cte->ctecoltypes, coltype); in analyzeCTETargetList()
628 CommonTableExpr *cte = cstate->items[i].cte; in makeDependencyGraph() local
676 CommonTableExpr *cte = cstate->items[i].cte; in makeDependencyGraphWalker() local
[all …]
/dports/multimedia/v4l_compat/linux-5.13-rc2/drivers/staging/kpc2000/kpc2000/
H A Dcell_probe.c75 cte->type, in dbg_cte()
76 cte->offset, in dbg_cte()
78 cte->length, in dbg_cte()
80 (cte->s2c_dma_present ? cte->s2c_dma_channel_num : -1), in dbg_cte()
81 (cte->c2s_dma_present ? cte->c2s_dma_channel_num : -1), in dbg_cte()
116 cte.type, in probe_core_basic()
119 cte.offset, in probe_core_basic()
120 cte.length, in probe_core_basic()
130 resources[0].end = cte.offset + (cte.length - 1); in probe_core_basic()
306 cte.type, in probe_core_uio()
[all …]
/dports/multimedia/libv4l/linux-5.13-rc2/drivers/staging/kpc2000/kpc2000/
H A Dcell_probe.c75 cte->type, in dbg_cte()
76 cte->offset, in dbg_cte()
78 cte->length, in dbg_cte()
80 (cte->s2c_dma_present ? cte->s2c_dma_channel_num : -1), in dbg_cte()
81 (cte->c2s_dma_present ? cte->c2s_dma_channel_num : -1), in dbg_cte()
116 cte.type, in probe_core_basic()
119 cte.offset, in probe_core_basic()
120 cte.length, in probe_core_basic()
130 resources[0].end = cte.offset + (cte.length - 1); in probe_core_basic()
306 cte.type, in probe_core_uio()
[all …]
/dports/multimedia/v4l-utils/linux-5.13-rc2/drivers/staging/kpc2000/kpc2000/
H A Dcell_probe.c75 cte->type, in dbg_cte()
76 cte->offset, in dbg_cte()
78 cte->length, in dbg_cte()
80 (cte->s2c_dma_present ? cte->s2c_dma_channel_num : -1), in dbg_cte()
81 (cte->c2s_dma_present ? cte->c2s_dma_channel_num : -1), in dbg_cte()
116 cte.type, in probe_core_basic()
119 cte.offset, in probe_core_basic()
120 cte.length, in probe_core_basic()
130 resources[0].end = cte.offset + (cte.length - 1); in probe_core_basic()
306 cte.type, in probe_core_uio()
[all …]
/dports/databases/pg_citus/citus-10.2.3/src/test/regress/sql/
H A Dlimit_intermediate_size.sql10 WITH cte AS MATERIALIZED
17 SELECT cte.user_id, cte.value_2 FROM cte,cte2 ORDER BY 1,2 LIMIT 10;
21 WITH cte AS MATERIALIZED
36 cte.user_id, cte2.value_2
38 cte JOIN cte2 ON (cte.value_1 = cte2.event_type)
78 (SELECT * FROM cte)
103 SELECT count(*) FROM cte WHERE EXISTS (select * from cte);
177 WITH cte AS MATERIALIZED
194 cte JOIN cte2 ON (cte.value_1 = cte2.event_type)
201 WITH cte AS MATERIALIZED
[all …]
/dports/databases/py-sqlalchemy14/SQLAlchemy-1.4.27/test/sql/
H A Dtest_cte.py266 cte = cte.union_all(select(cte.c.x + 1).where(cte.c.x < 10))
280 cte = cte.union_all(select(cte.c.x + 1).where(cte.c.x < 10)).alias(
349 cte = cte.union_all(select(cte.c.x + 1).where(cte.c.x < 10))
350 bar = select(cte).cte("bar")
372 cte = cte.union_all(select(cte.c.x + 1).where(cte.c.x < 10)).alias(
397 bar = select(cte).cte("bar")
398 cte = cte.union_all(select(cte.c.x + 1).where(cte.c.x < 10))
448 cte = cte.union_all(select(cte.c.x + 1).where(cte.c.x < 10)).alias(
1255 cte = upd.cte("update_cte")
1281 cte = dlt.cte("delete_cte")
[all …]
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/t/
H A Dderived_limit.test17 WITH cte AS (SELECT * FROM t1 LIMIT 5) SELECT * FROM cte;
25 SELECT * FROM cte;
32 SELECT * FROM cte;
39 SELECT * FROM cte;
47 SELECT * FROM cte;
53 SELECT * FROM cte;
61 SELECT * FROM cte;
67 SELECT * FROM cte;
74 WITH cte AS (SELECT * FROM t1 LIMIT 5 OFFSET 1) SELECT * FROM cte;
122 SELECT /*+ no_bnl() */ * FROM cte cte1, cte cte2;
[all …]
/dports/databases/py-sqlalchemy12/SQLAlchemy-1.2.19/test/sql/
H A Dtest_cte.py217 cte = s1.cte(name="cte", recursive=True)
218 cte = cte.union_all(select([cte.c.x + 1]).where(cte.c.x < 10))
231 cte = s1.cte(name="cte", recursive=True)
232 cte = cte.union_all(select([cte.c.x + 1]).where(cte.c.x < 10)).alias(
305 cte = cte.union_all(select([cte.c.x + 1]).where(cte.c.x < 10))
306 bar = select([cte]).cte("bar")
328 cte = cte.union_all(select([cte.c.x + 1]).where(cte.c.x < 10)).alias(
353 bar = select([cte]).cte("bar")
354 cte = cte.union_all(select([cte.c.x + 1]).where(cte.c.x < 10))
403 cte = cte.union_all(select([cte.c.x + 1]).where(cte.c.x < 10)).alias(
[all …]
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/main/
H A Dcte_cycle.result4 WITH RECURSIVE cte AS (
8 SELECT * FROM cte;
14 SELECT * FROM cte;
16 WITH cte AS (
20 SELECT * FROM cte;
29 SELECT * FROM cte;
51 FROM t1, cte WHERE t1.from_ = cte.to_
65 FROM t1, cte WHERE t1.from_ = cte.to_
110 FROM t1, cte WHERE t1.from_ = cte.to_
130 FROM t1, cte WHERE t1.from_ = cte.to_
[all …]
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/main/
H A Dcte_cycle.result4 WITH RECURSIVE cte AS (
8 SELECT * FROM cte;
14 SELECT * FROM cte;
16 WITH cte AS (
20 SELECT * FROM cte;
29 SELECT * FROM cte;
51 FROM t1, cte WHERE t1.from_ = cte.to_
65 FROM t1, cte WHERE t1.from_ = cte.to_
110 FROM t1, cte WHERE t1.from_ = cte.to_
130 FROM t1, cte WHERE t1.from_ = cte.to_
[all …]

12345678910>>...97