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

Commit8791627

Browse files
committed
Fix the create_index regression test for Danish collation.
In Danish collations, there are letter combinations which sorthigher than 'Z'. A test for values > 'WA' was picking up rowswhere the value started with 'AA', causing the test to fail.Backpatch to 9.2, where the failing test was added.Per report from Svenne Krap and analysis by Jeff Janes
1 parent073d7cb commit8791627

File tree

2 files changed

+8
-8
lines changed

2 files changed

+8
-8
lines changed

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

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -2659,18 +2659,18 @@ CREATE INDEX dupindexcols_i ON dupindexcols (f1, id, f1 text_pattern_ops);
26592659
ANALYZE dupindexcols;
26602660
EXPLAIN (COSTS OFF)
26612661
SELECT count(*) FROM dupindexcols
2662-
WHERE f1> 'WA' and id < 1000 and f1 ~<~ 'YX';
2663-
QUERY PLAN
2664-
---------------------------------------------------------------------------------------
2662+
WHERE f1BETWEEN 'WA' AND 'ZZZ' and id < 1000 and f1 ~<~ 'YX';
2663+
QUERY PLAN
2664+
----------------------------------------------------------------------------------------------------------------
26652665
Aggregate
26662666
-> Bitmap Heap Scan on dupindexcols
2667-
Recheck Cond: ((f1 > 'WA'::text) AND (id < 1000) AND (f1 ~<~ 'YX'::text))
2667+
Recheck Cond: ((f1 >= 'WA'::text) AND (f1 <= 'ZZZ'::text) AND (id < 1000) AND (f1 ~<~ 'YX'::text))
26682668
-> Bitmap Index Scan on dupindexcols_i
2669-
Index Cond: ((f1 > 'WA'::text) AND (id < 1000) AND (f1 ~<~ 'YX'::text))
2669+
Index Cond: ((f1 >= 'WA'::text) AND (f1 <= 'ZZZ'::text) AND (id < 1000) AND (f1 ~<~ 'YX'::text))
26702670
(5 rows)
26712671

26722672
SELECT count(*) FROM dupindexcols
2673-
WHERE f1> 'WA' and id < 1000 and f1 ~<~ 'YX';
2673+
WHERE f1BETWEEN 'WA' AND 'ZZZ' and id < 1000 and f1 ~<~ 'YX';
26742674
count
26752675
-------
26762676
97

‎src/test/regress/sql/create_index.sql

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -885,9 +885,9 @@ ANALYZE dupindexcols;
885885

886886
EXPLAIN (COSTS OFF)
887887
SELECTcount(*)FROM dupindexcols
888-
WHERE f1>'WA'and id<1000and f1 ~<~'YX';
888+
WHERE f1BETWEEN'WA'AND'ZZZ'and id<1000and f1 ~<~'YX';
889889
SELECTcount(*)FROM dupindexcols
890-
WHERE f1>'WA'and id<1000and f1 ~<~'YX';
890+
WHERE f1BETWEEN'WA'AND'ZZZ'and id<1000and f1 ~<~'YX';
891891

892892
--
893893
-- Check ordering of =ANY indexqual results (bug in 9.2.0)

0 commit comments

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