diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2017-09-13 12:27:01 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2017-09-13 12:27:01 -0400 |
| commit | 76e134fefd7de0554536e1b8d45a1878f96cf9c0 (patch) | |
| tree | 1bd79d38045fe7a7f03d658cf42e60cfad58c034 /src | |
| parent | 44ba2920644903d7dfceda810e5facdbcbab58a8 (diff) | |
| download | postgresql-76e134fefd7de0554536e1b8d45a1878f96cf9c0.tar.gz postgresql-76e134fefd7de0554536e1b8d45a1878f96cf9c0.zip | |
Adjust unstable regression test case.
Test queries added by commit 69835bc89 are giving unexpected results
on some smaller buildfarm critters. I think probably the seqscan
logic is kicking in to cause the scans to not start at the beginning
of the table. Add ORDER BY to make them be indexscans instead.
Per buildfarm member chipmunk.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/psql.out | 18 | ||||
| -rw-r--r-- | src/test/regress/sql/psql.sql | 6 |
2 files changed, 18 insertions, 6 deletions
diff --git a/src/test/regress/expected/psql.out b/src/test/regress/expected/psql.out index aa72a5b1eb8..836d8510fd2 100644 --- a/src/test/regress/expected/psql.out +++ b/src/test/regress/expected/psql.out @@ -3161,7 +3161,7 @@ last error message: syntax error at end of input last error code: 42601 -- check row count for a cursor-fetched query \set FETCH_COUNT 10 -select unique2 from tenk1 limit 19; +select unique2 from tenk1 order by unique2 limit 19; unique2 --------- 0 @@ -3191,8 +3191,20 @@ error: false error code: 00000 \echo 'number of rows:' :ROW_COUNT number of rows: 19 --- cursor-fetched query with an error -select 1/unique1 from tenk1; +-- cursor-fetched query with an error after the first group +select 1/(15-unique2) from tenk1 order by unique2 limit 19; + ?column? +---------- + 0 + 0 + 0 + 0 + 0 + 0 + 0 + 0 + 0 + 0 ERROR: division by zero \echo 'error:' :ERROR error: true diff --git a/src/test/regress/sql/psql.sql b/src/test/regress/sql/psql.sql index 29a17e1ae48..ddae1bf1e7e 100644 --- a/src/test/regress/sql/psql.sql +++ b/src/test/regress/sql/psql.sql @@ -656,13 +656,13 @@ SELECT 4 AS \gdesc -- check row count for a cursor-fetched query \set FETCH_COUNT 10 -select unique2 from tenk1 limit 19; +select unique2 from tenk1 order by unique2 limit 19; \echo 'error:' :ERROR \echo 'error code:' :SQLSTATE \echo 'number of rows:' :ROW_COUNT --- cursor-fetched query with an error -select 1/unique1 from tenk1; +-- cursor-fetched query with an error after the first group +select 1/(15-unique2) from tenk1 order by unique2 limit 19; \echo 'error:' :ERROR \echo 'error code:' :SQLSTATE \echo 'number of rows:' :ROW_COUNT |