| /dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/ |
| H A D | partition_prune.sql | 11 explain (costs off) select * from lp;
14 explain (costs off) select * from lp where a = 'a';
17 explain (costs off) select * from lp where a is null;
20 explain (costs off) select * from lp where a <> 'g';
58 explain (costs off) select * from rlp where a < 1;
60 explain (costs off) select * from rlp where a <= 1;
61 explain (costs off) select * from rlp where a = 1;
65 explain (costs off) select * from rlp where a > 10;
66 explain (costs off) select * from rlp where a < 15;
69 explain (costs off) select * from rlp where a = 16;
[all …]
|
| /dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/ |
| H A D | partition_prune.sql | 11 explain (costs off) select * from lp;
14 explain (costs off) select * from lp where a = 'a';
17 explain (costs off) select * from lp where a is null;
20 explain (costs off) select * from lp where a <> 'g';
58 explain (costs off) select * from rlp where a < 1;
60 explain (costs off) select * from rlp where a <= 1;
61 explain (costs off) select * from rlp where a = 1;
65 explain (costs off) select * from rlp where a > 10;
66 explain (costs off) select * from rlp where a < 15;
69 explain (costs off) select * from rlp where a = 16;
[all …]
|
| /dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/ |
| H A D | partition_prune.sql | 11 explain (costs off) select * from lp;
14 explain (costs off) select * from lp where a = 'a';
17 explain (costs off) select * from lp where a is null;
20 explain (costs off) select * from lp where a <> 'g';
58 explain (costs off) select * from rlp where a < 1;
60 explain (costs off) select * from rlp where a <= 1;
61 explain (costs off) select * from rlp where a = 1;
65 explain (costs off) select * from rlp where a > 10;
66 explain (costs off) select * from rlp where a < 15;
69 explain (costs off) select * from rlp where a = 16;
[all …]
|
| /dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/ |
| H A D | partition_prune.sql | 11 explain (costs off) select * from lp;
14 explain (costs off) select * from lp where a = 'a';
17 explain (costs off) select * from lp where a is null;
20 explain (costs off) select * from lp where a <> 'g';
58 explain (costs off) select * from rlp where a < 1;
60 explain (costs off) select * from rlp where a <= 1;
61 explain (costs off) select * from rlp where a = 1;
65 explain (costs off) select * from rlp where a > 10;
66 explain (costs off) select * from rlp where a < 15;
69 explain (costs off) select * from rlp where a = 16;
[all …]
|
| /dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/ |
| H A D | partition_prune.sql | 11 explain (costs off) select * from lp;
14 explain (costs off) select * from lp where a = 'a';
17 explain (costs off) select * from lp where a is null;
20 explain (costs off) select * from lp where a <> 'g';
58 explain (costs off) select * from rlp where a < 1;
60 explain (costs off) select * from rlp where a <= 1;
61 explain (costs off) select * from rlp where a = 1;
65 explain (costs off) select * from rlp where a > 10;
66 explain (costs off) select * from rlp where a < 15;
69 explain (costs off) select * from rlp where a = 16;
[all …]
|
| /dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/ |
| H A D | partition_prune.sql | 11 explain (costs off) select * from lp;
14 explain (costs off) select * from lp where a = 'a';
17 explain (costs off) select * from lp where a is null;
20 explain (costs off) select * from lp where a <> 'g';
58 explain (costs off) select * from rlp where a < 1;
60 explain (costs off) select * from rlp where a <= 1;
61 explain (costs off) select * from rlp where a = 1;
65 explain (costs off) select * from rlp where a > 10;
66 explain (costs off) select * from rlp where a < 15;
69 explain (costs off) select * from rlp where a = 16;
[all …]
|
| /dports/databases/postgresql11-server/postgresql-11.14/src/test/regress/sql/ |
| H A D | partition_prune.sql | 11 explain (costs off) select * from lp;
14 explain (costs off) select * from lp where a = 'a';
17 explain (costs off) select * from lp where a is null;
20 explain (costs off) select * from lp where a <> 'g';
58 explain (costs off) select * from rlp where a < 1;
60 explain (costs off) select * from rlp where a <= 1;
61 explain (costs off) select * from rlp where a = 1;
65 explain (costs off) select * from rlp where a > 10;
66 explain (costs off) select * from rlp where a < 15;
69 explain (costs off) select * from rlp where a = 16;
[all …]
|
| /dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/ |
| H A D | partition_prune.sql | 15 explain (costs off) select * from lp;
18 explain (costs off) select * from lp where a = 'a';
21 explain (costs off) select * from lp where a is null;
24 explain (costs off) select * from lp where a <> 'g';
62 explain (costs off) select * from rlp where a < 1;
64 explain (costs off) select * from rlp where a <= 1;
65 explain (costs off) select * from rlp where a = 1;
69 explain (costs off) select * from rlp where a > 10;
70 explain (costs off) select * from rlp where a < 15;
998 explain (costs off)
[all …]
|
| /dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/ |
| H A D | partition_prune.sql | 15 explain (costs off) select * from lp;
18 explain (costs off) select * from lp where a = 'a';
21 explain (costs off) select * from lp where a is null;
24 explain (costs off) select * from lp where a <> 'g';
62 explain (costs off) select * from rlp where a < 1;
64 explain (costs off) select * from rlp where a <= 1;
65 explain (costs off) select * from rlp where a = 1;
69 explain (costs off) select * from rlp where a > 10;
70 explain (costs off) select * from rlp where a < 15;
998 explain (costs off)
[all …]
|
| /dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/ |
| H A D | partition_prune.sql | 15 explain (costs off) select * from lp;
18 explain (costs off) select * from lp where a = 'a';
21 explain (costs off) select * from lp where a is null;
24 explain (costs off) select * from lp where a <> 'g';
62 explain (costs off) select * from rlp where a < 1;
64 explain (costs off) select * from rlp where a <= 1;
65 explain (costs off) select * from rlp where a = 1;
69 explain (costs off) select * from rlp where a > 10;
70 explain (costs off) select * from rlp where a < 15;
998 explain (costs off)
[all …]
|
| /dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/ |
| H A D | partition_prune.sql | 15 explain (costs off) select * from lp;
18 explain (costs off) select * from lp where a = 'a';
21 explain (costs off) select * from lp where a is null;
24 explain (costs off) select * from lp where a <> 'g';
62 explain (costs off) select * from rlp where a < 1;
64 explain (costs off) select * from rlp where a <= 1;
65 explain (costs off) select * from rlp where a = 1;
69 explain (costs off) select * from rlp where a > 10;
70 explain (costs off) select * from rlp where a < 15;
998 explain (costs off)
[all …]
|
| /dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/ |
| H A D | partition_prune.sql | 15 explain (costs off) select * from lp;
18 explain (costs off) select * from lp where a = 'a';
21 explain (costs off) select * from lp where a is null;
24 explain (costs off) select * from lp where a <> 'g';
62 explain (costs off) select * from rlp where a < 1;
64 explain (costs off) select * from rlp where a <= 1;
65 explain (costs off) select * from rlp where a = 1;
69 explain (costs off) select * from rlp where a > 10;
70 explain (costs off) select * from rlp where a < 15;
998 explain (costs off)
[all …]
|
| /dports/databases/postgresql14-contrib/postgresql-14.1/src/test/regress/sql/ |
| H A D | partition_prune.sql | 15 explain (costs off) select * from lp;
18 explain (costs off) select * from lp where a = 'a';
21 explain (costs off) select * from lp where a is null;
24 explain (costs off) select * from lp where a <> 'g';
62 explain (costs off) select * from rlp where a < 1;
64 explain (costs off) select * from rlp where a <= 1;
65 explain (costs off) select * from rlp where a = 1;
69 explain (costs off) select * from rlp where a > 10;
70 explain (costs off) select * from rlp where a < 15;
998 explain (costs off)
[all …]
|
| /dports/databases/postgresql14-client/postgresql-14.1/src/test/regress/sql/ |
| H A D | partition_prune.sql | 15 explain (costs off) select * from lp;
18 explain (costs off) select * from lp where a = 'a';
21 explain (costs off) select * from lp where a is null;
24 explain (costs off) select * from lp where a <> 'g';
62 explain (costs off) select * from rlp where a < 1;
64 explain (costs off) select * from rlp where a <= 1;
65 explain (costs off) select * from rlp where a = 1;
69 explain (costs off) select * from rlp where a > 10;
70 explain (costs off) select * from rlp where a < 15;
998 explain (costs off)
[all …]
|
| /dports/databases/postgresql13-plpython/postgresql-13.5/src/test/regress/sql/ |
| H A D | partition_prune.sql | 15 explain (costs off) select * from lp;
18 explain (costs off) select * from lp where a = 'a';
21 explain (costs off) select * from lp where a is null;
24 explain (costs off) select * from lp where a <> 'g';
62 explain (costs off) select * from rlp where a < 1;
64 explain (costs off) select * from rlp where a <= 1;
65 explain (costs off) select * from rlp where a = 1;
69 explain (costs off) select * from rlp where a > 10;
70 explain (costs off) select * from rlp where a < 15;
996 explain (costs off)
[all …]
|
| /dports/databases/postgresql13-pltcl/postgresql-13.5/src/test/regress/sql/ |
| H A D | partition_prune.sql | 15 explain (costs off) select * from lp;
18 explain (costs off) select * from lp where a = 'a';
21 explain (costs off) select * from lp where a is null;
24 explain (costs off) select * from lp where a <> 'g';
62 explain (costs off) select * from rlp where a < 1;
64 explain (costs off) select * from rlp where a <= 1;
65 explain (costs off) select * from rlp where a = 1;
69 explain (costs off) select * from rlp where a > 10;
70 explain (costs off) select * from rlp where a < 15;
996 explain (costs off)
[all …]
|
| /dports/databases/postgresql13-server/postgresql-13.5/src/test/regress/sql/ |
| H A D | partition_prune.sql | 15 explain (costs off) select * from lp;
18 explain (costs off) select * from lp where a = 'a';
21 explain (costs off) select * from lp where a is null;
24 explain (costs off) select * from lp where a <> 'g';
62 explain (costs off) select * from rlp where a < 1;
64 explain (costs off) select * from rlp where a <= 1;
65 explain (costs off) select * from rlp where a = 1;
69 explain (costs off) select * from rlp where a > 10;
70 explain (costs off) select * from rlp where a < 15;
996 explain (costs off)
[all …]
|
| /dports/databases/postgresql13-contrib/postgresql-13.5/src/test/regress/sql/ |
| H A D | partition_prune.sql | 15 explain (costs off) select * from lp;
18 explain (costs off) select * from lp where a = 'a';
21 explain (costs off) select * from lp where a is null;
24 explain (costs off) select * from lp where a <> 'g';
62 explain (costs off) select * from rlp where a < 1;
64 explain (costs off) select * from rlp where a <= 1;
65 explain (costs off) select * from rlp where a = 1;
69 explain (costs off) select * from rlp where a > 10;
70 explain (costs off) select * from rlp where a < 15;
996 explain (costs off)
[all …]
|
| /dports/databases/postgresql13-client/postgresql-13.5/src/test/regress/sql/ |
| H A D | partition_prune.sql | 15 explain (costs off) select * from lp;
18 explain (costs off) select * from lp where a = 'a';
21 explain (costs off) select * from lp where a is null;
24 explain (costs off) select * from lp where a <> 'g';
62 explain (costs off) select * from rlp where a < 1;
64 explain (costs off) select * from rlp where a <= 1;
65 explain (costs off) select * from rlp where a = 1;
69 explain (costs off) select * from rlp where a > 10;
70 explain (costs off) select * from rlp where a < 15;
996 explain (costs off)
[all …]
|
| /dports/databases/postgresql13-plperl/postgresql-13.5/src/test/regress/sql/ |
| H A D | partition_prune.sql | 15 explain (costs off) select * from lp;
18 explain (costs off) select * from lp where a = 'a';
21 explain (costs off) select * from lp where a is null;
24 explain (costs off) select * from lp where a <> 'g';
62 explain (costs off) select * from rlp where a < 1;
64 explain (costs off) select * from rlp where a <= 1;
65 explain (costs off) select * from rlp where a = 1;
69 explain (costs off) select * from rlp where a > 10;
70 explain (costs off) select * from rlp where a < 15;
996 explain (costs off)
[all …]
|
| /dports/databases/postgresql13-docs/postgresql-13.5/src/test/regress/sql/ |
| H A D | partition_prune.sql | 15 explain (costs off) select * from lp;
18 explain (costs off) select * from lp where a = 'a';
21 explain (costs off) select * from lp where a is null;
24 explain (costs off) select * from lp where a <> 'g';
62 explain (costs off) select * from rlp where a < 1;
64 explain (costs off) select * from rlp where a <= 1;
65 explain (costs off) select * from rlp where a = 1;
69 explain (costs off) select * from rlp where a > 10;
70 explain (costs off) select * from rlp where a < 15;
996 explain (costs off)
[all …]
|
| /dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/ |
| H A D | partition_prune.sql | 11 explain (costs off) select * from lp;
14 explain (costs off) select * from lp where a = 'a';
17 explain (costs off) select * from lp where a is null;
20 explain (costs off) select * from lp where a <> 'g';
58 explain (costs off) select * from rlp where a < 1;
60 explain (costs off) select * from rlp where a <= 1;
61 explain (costs off) select * from rlp where a = 1;
65 explain (costs off) select * from rlp where a > 10;
66 explain (costs off) select * from rlp where a < 15;
1054 explain (costs off)
[all …]
|
| /dports/databases/postgresql12-contrib/postgresql-12.9/src/test/regress/sql/ |
| H A D | partition_prune.sql | 11 explain (costs off) select * from lp;
14 explain (costs off) select * from lp where a = 'a';
17 explain (costs off) select * from lp where a is null;
20 explain (costs off) select * from lp where a <> 'g';
58 explain (costs off) select * from rlp where a < 1;
60 explain (costs off) select * from rlp where a <= 1;
61 explain (costs off) select * from rlp where a = 1;
65 explain (costs off) select * from rlp where a > 10;
66 explain (costs off) select * from rlp where a < 15;
1054 explain (costs off)
[all …]
|
| /dports/databases/postgresql12-docs/postgresql-12.9/src/test/regress/sql/ |
| H A D | partition_prune.sql | 11 explain (costs off) select * from lp;
14 explain (costs off) select * from lp where a = 'a';
17 explain (costs off) select * from lp where a is null;
20 explain (costs off) select * from lp where a <> 'g';
58 explain (costs off) select * from rlp where a < 1;
60 explain (costs off) select * from rlp where a <= 1;
61 explain (costs off) select * from rlp where a = 1;
65 explain (costs off) select * from rlp where a > 10;
66 explain (costs off) select * from rlp where a < 15;
1054 explain (costs off)
[all …]
|
| /dports/databases/postgresql12-server/postgresql-12.9/src/test/regress/sql/ |
| H A D | partition_prune.sql | 11 explain (costs off) select * from lp;
14 explain (costs off) select * from lp where a = 'a';
17 explain (costs off) select * from lp where a is null;
20 explain (costs off) select * from lp where a <> 'g';
58 explain (costs off) select * from rlp where a < 1;
60 explain (costs off) select * from rlp where a <= 1;
61 explain (costs off) select * from rlp where a = 1;
65 explain (costs off) select * from rlp where a > 10;
66 explain (costs off) select * from rlp where a < 15;
1054 explain (costs off)
[all …]
|