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

Commitde5a08c

Browse files
committed
Tweak duplicate-index-column regression test to avoid locale sensitivity.
The originally-chosen test case gives different results in es_EC localebecause of unusual rule for sorting strings beginning with "LL". Adjustthe comparison value to avoid that, while hopefully not introducing newlocale dependencies elsewhere. Per report from Jaime Casanova.
1 parent50363c8 commitde5a08c

File tree

2 files changed

+6
-6
lines changed

2 files changed

+6
-6
lines changed

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

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -2468,18 +2468,18 @@ CREATE INDEX dupindexcols_i ON dupindexcols (f1, id, f1 text_pattern_ops);
24682468
VACUUM ANALYZE dupindexcols;
24692469
EXPLAIN (COSTS OFF)
24702470
SELECT count(*) FROM dupindexcols
2471-
WHERE f1 > 'LX' and id < 1000 and f1 ~<~ 'YX';
2471+
WHERE f1 > 'MA' and id < 1000 and f1 ~<~ 'YX';
24722472
QUERY PLAN
24732473
---------------------------------------------------------------------------------
24742474
Aggregate
24752475
-> Index Only Scan using dupindexcols_i on dupindexcols
2476-
Index Cond: ((f1 > 'LX'::text) AND (id < 1000) AND (f1 ~<~ 'YX'::text))
2476+
Index Cond: ((f1 > 'MA'::text) AND (id < 1000) AND (f1 ~<~ 'YX'::text))
24772477
(3 rows)
24782478

24792479
SELECT count(*) FROM dupindexcols
2480-
WHERE f1 > 'LX' and id < 1000 and f1 ~<~ 'YX';
2480+
WHERE f1 > 'MA' and id < 1000 and f1 ~<~ 'YX';
24812481
count
24822482
-------
2483-
500
2483+
497
24842484
(1 row)
24852485

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

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -816,6 +816,6 @@ VACUUM ANALYZE dupindexcols;
816816

817817
EXPLAIN (COSTS OFF)
818818
SELECTcount(*)FROM dupindexcols
819-
WHERE f1>'LX'and id<1000and f1 ~<~'YX';
819+
WHERE f1>'MA'and id<1000and f1 ~<~'YX';
820820
SELECTcount(*)FROM dupindexcols
821-
WHERE f1>'LX'and id<1000and f1 ~<~'YX';
821+
WHERE f1>'MA'and id<1000and f1 ~<~'YX';

0 commit comments

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