| /dports/databases/pg_citus/citus-10.2.3/src/test/regress/sql/ |
| H A D | locally_execute_intermediate_results.sql | 53 cte_2 AS MATERIALIZED (SELECT * FROM table_2)
79 cte_3 AS MATERIALIZED (SELECT * FROM table_2)
115 cte_3 AS MATERIALIZED (SELECT * FROM table_2)
145 cte_2 AS MATERIALIZED (SELECT * FROM table_1)
165 WITH a AS MATERIALIZED (SELECT * FROM table_1)
185 cte_2 AS MATERIALIZED (SELECT * FROM cte_1),
191 cte_2 AS MATERIALIZED (SELECT * FROM cte_1),
197 cte_2 AS MATERIALIZED (SELECT * FROM cte_1),
430 cte_2 AS MATERIALIZED (SELECT * FROM cte_1),
438 cte_2 AS MATERIALIZED (SELECT * FROM cte_1),
[all …]
|
| H A D | limit_intermediate_size.sql | 10 WITH cte AS MATERIALIZED
14 cte2 AS MATERIALIZED (
21 WITH cte AS MATERIALIZED
32 cte2 AS MATERIALIZED(
97 cte3 AS MATERIALIZED(
113 cte3 AS MATERIALIZED(
132 cte4 AS MATERIALIZED (
150 cte4 AS MATERIALIZED (
170 cte4 AS MATERIALIZED (
188 cte2 AS MATERIALIZED (
[all …]
|
| /dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
| H A D | matview.sql | 31 ) CREATE MATERIALIZED VIEW mvtest_tm AS
40 CREATE MATERIALIZED VIEW mvtest_tm AS
63 REFRESH MATERIALIZED VIEW mvtest_tm;
92 CREATE MATERIALIZED VIEW mvtest_tvm AS
105 CREATE MATERIALIZED VIEW mvtest_tmm AS
149 CREATE MATERIALIZED VIEW mvtest_bb AS
193 REFRESH MATERIALIZED VIEW mvtest_tvm;
251 REFRESH MATERIALIZED VIEW mvtest_tmm;
350 CREATE MATERIALIZED VIEW mv_test2 AS
364 CREATE MATERIALIZED VIEW mv_test3 AS
[all …]
|
| /dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql14-contrib/postgresql-14.1/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql14-client/postgresql-14.1/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|
| /dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/ |
| H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm;
63 REFRESH MATERIALIZED VIEW mvtest_tvm;
78 REFRESH MATERIALIZED VIEW mvtest_tmm;
80 REFRESH MATERIALIZED VIEW mvtest_tvmm;
81 REFRESH MATERIALIZED VIEW mvtest_tvvm;
130 REFRESH MATERIALIZED VIEW mvtest_mv;
142 REFRESH MATERIALIZED VIEW mvtest_mv;
176 REFRESH MATERIALIZED VIEW mvtest_mv_v;
179 REFRESH MATERIALIZED VIEW mvtest_mv_v_2;
180 REFRESH MATERIALIZED VIEW mvtest_mv_v_3;
[all …]
|