Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit76e134f

Browse files
committed
Adjust unstable regression test case.
Test queries added by commit69835bc are giving unexpected resultson some smaller buildfarm critters. I think probably the seqscanlogic is kicking in to cause the scans to not start at the beginningof the table. Add ORDER BY to make them be indexscans instead.Per buildfarm member chipmunk.
1 parent44ba292 commit76e134f

File tree

2 files changed

+18
-6
lines changed

2 files changed

+18
-6
lines changed

‎src/test/regress/expected/psql.out

Lines changed: 15 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -3161,7 +3161,7 @@ last error message: syntax error at end of input
31613161
last error code: 42601
31623162
-- check row count for a cursor-fetched query
31633163
\set FETCH_COUNT 10
3164-
select unique2 from tenk1 limit 19;
3164+
select unique2 from tenk1order by unique2limit 19;
31653165
unique2
31663166
---------
31673167
0
@@ -3191,8 +3191,20 @@ error: false
31913191
error code: 00000
31923192
\echo 'number of rows:' :ROW_COUNT
31933193
number of rows: 19
3194-
-- cursor-fetched query with an error
3195-
select 1/unique1 from tenk1;
3194+
-- cursor-fetched query with an error after the first group
3195+
select 1/(15-unique2) from tenk1 order by unique2 limit 19;
3196+
?column?
3197+
----------
3198+
0
3199+
0
3200+
0
3201+
0
3202+
0
3203+
0
3204+
0
3205+
0
3206+
0
3207+
0
31963208
ERROR: division by zero
31973209
\echo 'error:' :ERROR
31983210
error: true

‎src/test/regress/sql/psql.sql

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -656,13 +656,13 @@ SELECT 4 AS \gdesc
656656

657657
-- check row count for a cursor-fetched query
658658
\set FETCH_COUNT10
659-
select unique2from tenk1limit19;
659+
select unique2from tenk1order by unique2limit19;
660660
\echo'error:' :ERROR
661661
\echo'error code:' :SQLSTATE
662662
\echo'number of rows:' :ROW_COUNT
663663

664-
-- cursor-fetched query with an error
665-
select1/unique1from tenk1;
664+
-- cursor-fetched query with an error after the first group
665+
select1/(15-unique2)from tenk1order by unique2limit19;
666666
\echo'error:' :ERROR
667667
\echo'error code:' :SQLSTATE
668668
\echo'number of rows:' :ROW_COUNT

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp