| /dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql96-docs/postgresql-9.6.24/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql96-client/postgresql-9.6.24/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql96-contrib/postgresql-9.6.24/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql11-server/postgresql-11.14/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|
| /dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/expected/ |
| H A D | tablesample.out | 49 SELECT count(*) FROM test_tablesample TABLESAMPLE SYSTEM (100);
70 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (99);
87 FROM test_tablesample TABLESAMPLE system (99);
283 SELECT id FROM test_tablesample TABLESAMPLE FOOBAR (1);
287 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (NULL);
288 ERROR: TABLESAMPLE parameter cannot be null
290 ERROR: TABLESAMPLE REPEATABLE parameter cannot be null
291 SELECT id FROM test_tablesample TABLESAMPLE BERNOULLI (-1);
295 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (-1);
297 SELECT id FROM test_tablesample TABLESAMPLE SYSTEM (200);
[all …]
|