| /dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | tablesample.sql | 7 SELECT t.id FROM test_tablesample AS t TABLESAMPLE SYSTEM (50) REPEATABLE (0);
8 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (100.0/11) REPEATABLE (0);
9 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
10 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (50) REPEATABLE (0);
11 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (5.5) REPEATABLE (0);
19 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (10*2) REPEATABLE (2);
28 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
34 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
51 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (2);
89 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (NULL);
[all …]
|
| /dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | tablesample.sql | 7 SELECT t.id FROM test_tablesample AS t TABLESAMPLE SYSTEM (50) REPEATABLE (0);
8 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (100.0/11) REPEATABLE (0);
9 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
10 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (50) REPEATABLE (0);
11 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (5.5) REPEATABLE (0);
19 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (10*2) REPEATABLE (2);
28 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
34 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
51 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (2);
89 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (NULL);
[all …]
|
| /dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | tablesample.sql | 7 SELECT t.id FROM test_tablesample AS t TABLESAMPLE SYSTEM (50) REPEATABLE (0);
8 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (100.0/11) REPEATABLE (0);
9 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
10 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (50) REPEATABLE (0);
11 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (5.5) REPEATABLE (0);
19 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (10*2) REPEATABLE (2);
28 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
34 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
51 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (2);
89 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (NULL);
[all …]
|
| /dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | tablesample.sql | 7 SELECT t.id FROM test_tablesample AS t TABLESAMPLE SYSTEM (50) REPEATABLE (0);
8 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (100.0/11) REPEATABLE (0);
9 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
10 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (50) REPEATABLE (0);
11 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (5.5) REPEATABLE (0);
19 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (10*2) REPEATABLE (2);
28 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
34 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
51 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (2);
89 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (NULL);
[all …]
|
| /dports/databases/postgresql96-docs/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | tablesample.sql | 7 SELECT t.id FROM test_tablesample AS t TABLESAMPLE SYSTEM (50) REPEATABLE (0);
8 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (100.0/11) REPEATABLE (0);
9 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
10 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (50) REPEATABLE (0);
11 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (5.5) REPEATABLE (0);
19 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (10*2) REPEATABLE (2);
28 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
34 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
51 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (2);
89 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (NULL);
[all …]
|
| /dports/databases/postgresql96-client/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | tablesample.sql | 7 SELECT t.id FROM test_tablesample AS t TABLESAMPLE SYSTEM (50) REPEATABLE (0);
8 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (100.0/11) REPEATABLE (0);
9 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
10 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (50) REPEATABLE (0);
11 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (5.5) REPEATABLE (0);
19 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (10*2) REPEATABLE (2);
28 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
34 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
51 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (2);
89 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (NULL);
[all …]
|
| /dports/databases/postgresql96-contrib/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | tablesample.sql | 7 SELECT t.id FROM test_tablesample AS t TABLESAMPLE SYSTEM (50) REPEATABLE (0);
8 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (100.0/11) REPEATABLE (0);
9 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
10 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (50) REPEATABLE (0);
11 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (5.5) REPEATABLE (0);
19 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (10*2) REPEATABLE (2);
28 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
34 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
51 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (2);
89 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (NULL);
[all …]
|
| /dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/sys_vars/r/ |
| H A D | tx_isolation_basic.result | 4 REPEATABLE-READ
8 REPEATABLE-READ
14 REPEATABLE-READ
18 REPEATABLE-READ
40 REPEATABLE-READ
56 REPEATABLE-READ
108 REPEATABLE-READ
133 REPEATABLE-READ
137 REPEATABLE-READ
141 REPEATABLE-READ
[all …]
|
| /dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/sys_vars/r/ |
| H A D | tx_isolation_basic.result | 4 REPEATABLE-READ
8 REPEATABLE-READ
14 REPEATABLE-READ
18 REPEATABLE-READ
40 REPEATABLE-READ
56 REPEATABLE-READ
108 REPEATABLE-READ
133 REPEATABLE-READ
137 REPEATABLE-READ
141 REPEATABLE-READ
[all …]
|
| /dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/suite/sys_vars/r/ |
| H A D | tx_isolation_basic.result | 4 REPEATABLE-READ
8 REPEATABLE-READ
14 REPEATABLE-READ
18 REPEATABLE-READ
40 REPEATABLE-READ
56 REPEATABLE-READ
108 REPEATABLE-READ
133 REPEATABLE-READ
137 REPEATABLE-READ
141 REPEATABLE-READ
[all …]
|
| /dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/sys_vars/r/ |
| H A D | tx_isolation_basic.result | 4 REPEATABLE-READ
8 REPEATABLE-READ
14 REPEATABLE-READ
18 REPEATABLE-READ
40 REPEATABLE-READ
56 REPEATABLE-READ
108 REPEATABLE-READ
133 REPEATABLE-READ
137 REPEATABLE-READ
141 REPEATABLE-READ
[all …]
|
| /dports/databases/mysql56-client/mysql-5.6.51/mysql-test/suite/sys_vars/r/ |
| H A D | tx_isolation_basic.result | 4 REPEATABLE-READ
8 REPEATABLE-READ
14 REPEATABLE-READ
18 REPEATABLE-READ
40 REPEATABLE-READ
56 REPEATABLE-READ
108 REPEATABLE-READ
133 REPEATABLE-READ
137 REPEATABLE-READ
141 REPEATABLE-READ
[all …]
|
| /dports/databases/mysql55-client/mysql-5.5.62/mysql-test/suite/sys_vars/r/ |
| H A D | tx_isolation_basic.result | 4 REPEATABLE-READ
8 REPEATABLE-READ
14 REPEATABLE-READ
18 REPEATABLE-READ
40 REPEATABLE-READ
56 REPEATABLE-READ
108 REPEATABLE-READ
133 REPEATABLE-READ
137 REPEATABLE-READ
141 REPEATABLE-READ
[all …]
|
| /dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
| H A D | tablesample.sql | 21 REPEATABLE (0);
27 REPEATABLE (0);
33 REPEATABLE (0);
39 REPEATABLE (0);
45 REPEATABLE (0);
57 REPEATABLE (1 + 2);
63 REPEATABLE (0.4);
70 REPEATABLE (2);
95 REPEATABLE (0);
114 REPEATABLE (2);
[all …]
|
| /dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
| H A D | tablesample.sql | 7 SELECT t.id FROM test_tablesample AS t TABLESAMPLE SYSTEM (50) REPEATABLE (0);
8 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (100.0/11) REPEATABLE (0);
9 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
10 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (50) REPEATABLE (0);
11 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (5.5) REPEATABLE (0);
19 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (10*2) REPEATABLE (2);
28 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
34 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
51 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (2);
89 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (NULL);
[all …]
|
| /dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/ |
| H A D | tablesample.sql | 7 SELECT t.id FROM test_tablesample AS t TABLESAMPLE SYSTEM (50) REPEATABLE (0);
8 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (100.0/11) REPEATABLE (0);
9 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
10 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (50) REPEATABLE (0);
11 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (5.5) REPEATABLE (0);
19 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (10*2) REPEATABLE (2);
28 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
34 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
51 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (2);
89 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (NULL);
[all …]
|
| /dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/ |
| H A D | tablesample.sql | 7 SELECT t.id FROM test_tablesample AS t TABLESAMPLE SYSTEM (50) REPEATABLE (0);
8 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (100.0/11) REPEATABLE (0);
9 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
10 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (50) REPEATABLE (0);
11 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (5.5) REPEATABLE (0);
19 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (10*2) REPEATABLE (2);
28 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
34 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
51 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (2);
89 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (NULL);
[all …]
|
| /dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/ |
| H A D | tablesample.sql | 7 SELECT t.id FROM test_tablesample AS t TABLESAMPLE SYSTEM (50) REPEATABLE (0);
8 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (100.0/11) REPEATABLE (0);
9 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
10 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (50) REPEATABLE (0);
11 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (5.5) REPEATABLE (0);
19 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (10*2) REPEATABLE (2);
28 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
34 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
51 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (2);
89 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (NULL);
[all …]
|
| /dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/ |
| H A D | tablesample.sql | 7 SELECT t.id FROM test_tablesample AS t TABLESAMPLE SYSTEM (50) REPEATABLE (0);
8 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (100.0/11) REPEATABLE (0);
9 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
10 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (50) REPEATABLE (0);
11 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (5.5) REPEATABLE (0);
19 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (10*2) REPEATABLE (2);
28 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
34 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
51 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (2);
89 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (NULL);
[all …]
|
| /dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/ |
| H A D | tablesample.sql | 7 SELECT t.id FROM test_tablesample AS t TABLESAMPLE SYSTEM (50) REPEATABLE (0);
8 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (100.0/11) REPEATABLE (0);
9 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
10 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (50) REPEATABLE (0);
11 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (5.5) REPEATABLE (0);
19 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (10*2) REPEATABLE (2);
28 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
34 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
51 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (2);
89 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (NULL);
[all …]
|
| /dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/ |
| H A D | tablesample.sql | 7 SELECT t.id FROM test_tablesample AS t TABLESAMPLE SYSTEM (50) REPEATABLE (0);
8 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (100.0/11) REPEATABLE (0);
9 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
10 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (50) REPEATABLE (0);
11 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (5.5) REPEATABLE (0);
19 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (10*2) REPEATABLE (2);
28 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
34 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
51 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (2);
89 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (NULL);
[all …]
|
| /dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/ |
| H A D | tablesample.sql | 7 SELECT t.id FROM test_tablesample AS t TABLESAMPLE SYSTEM (50) REPEATABLE (0);
8 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (100.0/11) REPEATABLE (0);
9 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
10 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (50) REPEATABLE (0);
11 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (5.5) REPEATABLE (0);
19 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (10*2) REPEATABLE (2);
28 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
34 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
51 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (2);
89 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (NULL);
[all …]
|
| /dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/ |
| H A D | tablesample.sql | 7 SELECT t.id FROM test_tablesample AS t TABLESAMPLE SYSTEM (50) REPEATABLE (0);
8 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (100.0/11) REPEATABLE (0);
9 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
10 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (50) REPEATABLE (0);
11 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (5.5) REPEATABLE (0);
19 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (10*2) REPEATABLE (2);
28 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
34 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
51 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (2);
89 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (NULL);
[all …]
|
| /dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/ |
| H A D | tablesample.sql | 7 SELECT t.id FROM test_tablesample AS t TABLESAMPLE SYSTEM (50) REPEATABLE (0);
8 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (100.0/11) REPEATABLE (0);
9 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
10 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (50) REPEATABLE (0);
11 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (5.5) REPEATABLE (0);
19 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (10*2) REPEATABLE (2);
28 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
34 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
51 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (2);
89 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (NULL);
[all …]
|
| /dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/ |
| H A D | tablesample.sql | 7 SELECT t.id FROM test_tablesample AS t TABLESAMPLE SYSTEM (50) REPEATABLE (0);
8 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (100.0/11) REPEATABLE (0);
9 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
10 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (50) REPEATABLE (0);
11 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (5.5) REPEATABLE (0);
19 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (10*2) REPEATABLE (2);
28 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
34 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (0);
51 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (2);
89 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (50) REPEATABLE (NULL);
[all …]
|