Thread: [BUGS] BUG #14637: Tests fail with pl_PL.UTF-8 locale
The following bug has been logged on the website:
Bug reference: 14637
Logged by: Tomasz Kontusz
Email address: tomasz.kontusz@gmail.com
PostgreSQL version: 9.6.2
Operating system: Ubuntu 16.04
Description:
When running `./configure && make check` on Ubuntu 16.04 with pl_PL.UTF-8
locale I'm getting 2 test failures. No failures are reported for `LANG=C
make check`.
This happens both on REL9_6_STABLE (commit 6872d96a) and master (commit
e18b2c48).
This is the content of src/test/regress/regression.diffs from
REL9_6_STABLE:
***
/home/tomek/postgresql/src/test/regress/expected/create_index.out 2017-05-01
01:13:36.005340758 +0200
---
/home/tomek/postgresql/src/test/regress/results/create_index.out 2017-05-01
01:56:46.253841538 +0200
***************
*** 315,321 **** SELECT count(*) FROM radix_text_tbl WHERE t < 'Aztec Ct '; count -------
! 272 (1 row) SELECT count(*) FROM radix_text_tbl WHERE t ~<~ 'Aztec Ct ';
--- 315,321 ---- SELECT count(*) FROM radix_text_tbl WHERE t < 'Aztec Ct '; count -------
! 263 (1 row) SELECT count(*) FROM radix_text_tbl WHERE t ~<~ 'Aztec Ct ';
***************
*** 327,333 **** SELECT count(*) FROM radix_text_tbl WHERE t <= 'Aztec Ct '; count -------
! 273 (1 row) SELECT count(*) FROM radix_text_tbl WHERE t ~<=~ 'Aztec Ct ';
--- 327,333 ---- SELECT count(*) FROM radix_text_tbl WHERE t <= 'Aztec Ct '; count -------
! 264 (1 row) SELECT count(*) FROM radix_text_tbl WHERE t ~<=~ 'Aztec Ct ';
***************
*** 1044,1050 **** SELECT count(*) FROM radix_text_tbl WHERE t < 'Aztec Ct '; count
-------
! 272 (1 row) EXPLAIN (COSTS OFF)
--- 1044,1050 ---- SELECT count(*) FROM radix_text_tbl WHERE t < 'Aztec Ct '; count
-------
! 263 (1 row) EXPLAIN (COSTS OFF)
***************
*** 1074,1080 **** SELECT count(*) FROM radix_text_tbl WHERE t <= 'Aztec Ct '; count
-------
! 273 (1 row) EXPLAIN (COSTS OFF)
--- 1074,1080 ---- SELECT count(*) FROM radix_text_tbl WHERE t <= 'Aztec Ct '; count
-------
! 264 (1 row) EXPLAIN (COSTS OFF)
***************
*** 1607,1613 **** SELECT count(*) FROM radix_text_tbl WHERE t < 'Aztec Ct '; count
-------
! 272 (1 row) EXPLAIN (COSTS OFF)
--- 1607,1613 ---- SELECT count(*) FROM radix_text_tbl WHERE t < 'Aztec Ct '; count
-------
! 263 (1 row) EXPLAIN (COSTS OFF)
***************
*** 1641,1647 **** SELECT count(*) FROM radix_text_tbl WHERE t <= 'Aztec Ct '; count
-------
! 273 (1 row) EXPLAIN (COSTS OFF)
--- 1641,1647 ---- SELECT count(*) FROM radix_text_tbl WHERE t <= 'Aztec Ct '; count
-------
! 264 (1 row) EXPLAIN (COSTS OFF)
======================================================================
***
/home/tomek/postgresql/src/test/regress/expected/select_views_1.out 2017-05-01
01:13:36.041340781 +0200
---
/home/tomek/postgresql/src/test/regress/results/select_views.out 2017-05-01
01:56:50.029874158 +0200
***************
*** 343,472 **** SELECT name, #thepath FROM iexit ORDER BY 1, 2; name | ?column?
------------------------------------+----------
- I- 580 | 2
- I- 580 | 2
- I- 580 | 2
- I- 580 | 2
- I- 580 | 2
- I- 580 | 2
- I- 580 | 2
- I- 580 | 2
- I- 580 | 2
- I- 580 | 2
- I- 580 | 2
- I- 580 | 3
- I- 580 | 3
- I- 580 | 3
- I- 580 | 3
- I- 580 | 3
- I- 580 | 3
- I- 580 | 3
- I- 580 | 3
- I- 580 | 3
- I- 580 | 3
- I- 580 | 3
- I- 580 | 3
- I- 580 | 3
- I- 580 | 3
- I- 580 | 3
- I- 580 | 3
- I- 580 | 3
- I- 580 | 3
- I- 580 | 4
- I- 580 | 4
- I- 580 | 4
- I- 580 | 4
- I- 580 | 5
- I- 580 | 5
- I- 580 | 5
- I- 580 | 5
- I- 580 | 5
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 6
- I- 580 | 7
- I- 580 | 7
- I- 580 | 7
- I- 580 | 7
- I- 580 | 7
- I- 580 | 7
- I- 580 | 7
- I- 580 | 8
- I- 580 | 8
- I- 580 | 8
- I- 580 | 8
- I- 580 | 8
- I- 580 | 8
- I- 580 | 8
- I- 580 | 8
- I- 580 | 8
- I- 580 | 9
- I- 580 | 9
- I- 580 | 9
- I- 580 | 9
- I- 580 | 9
- I- 580 | 12
- I- 580 | 12
- I- 580 | 12
- I- 580 | 12
- I- 580 | 12
- I- 580 | 12
- I- 580 | 12
- I- 580 | 12
- I- 580 | 12
- I- 580 | 12
- I- 580 | 13
- I- 580 | 13
- I- 580 | 13
- I- 580 | 13
- I- 580 | 13
- I- 580 | 13
- I- 580 | 14
- I- 580 | 14
- I- 580 | 14
- I- 580 | 14
- I- 580 | 14
- I- 580 | 14
- I- 580 | 14
- I- 580 | 14
- I- 580 | 18
- I- 580 | 18
- I- 580 | 18
- I- 580 | 18
- I- 580 | 18
- I- 580 | 18
- I- 580 | 21
- I- 580 | 21
- I- 580 | 21
- I- 580 | 21
- I- 580 | 21
- I- 580 | 21
- I- 580 | 21
- I- 580 | 21
- I- 580 | 21
- I- 580 | 21
- I- 580 | 22
- I- 580 | 22 I- 580/I-680 Ramp | 2 I- 580/I-680
Ramp | 2 I- 580/I-680 Ramp | 2
--- 343,348 ----
***************
*** 731,872 **** I- 580 Ramp | 8 I- 580 Ramp | 8 I- 580
Ramp | 8
! I- 680 | 2
! I- 680 | 2
! I- 680 | 2
! I- 680 | 2
! I- 680 | 2
! I- 680 | 2
! I- 680 | 2
! I- 680 | 3
! I- 680 | 3
! I- 680 | 3
! I- 680 | 4
! I- 680 | 4
! I- 680 | 4
! I- 680 | 5
! I- 680 | 5
! I- 680 | 5
! I- 680 | 7
! I- 680 | 7
! I- 680 | 7
! I- 680 | 7
! I- 680 | 8
! I- 680 | 8
! I- 680 | 8
! I- 680 | 8
! I- 680 | 10
! I- 680 | 10
! I- 680 | 10
! I- 680 | 10
! I- 680 | 10
! I- 680 | 10
! I- 680 | 10
! I- 680 | 16
! I- 680 | 16
! I- 680 | 16
! I- 680 | 16
! I- 680 | 16
! I- 680 | 16
! I- 680 | 16
! I- 680 | 16
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 4
! I- 680 Ramp | 4
! I- 680 Ramp | 4
! I- 680 Ramp | 5
! I- 680 Ramp | 5
! I- 680 Ramp | 5
! I- 680 Ramp | 5
! I- 680 Ramp | 5
! I- 680 Ramp | 5
! I- 680 Ramp | 6
! I- 680 Ramp | 6
! I- 680 Ramp | 6
! I- 680 Ramp | 6
! I- 680 Ramp | 7
! I- 680 Ramp | 7
! I- 680 Ramp | 7
! I- 680 Ramp | 7
! I- 680 Ramp | 8
! I- 680 Ramp | 8
! I- 680 Ramp | 8
! I- 680 Ramp | 8
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 3
! I- 80 | 3
! I- 80 | 3
! I- 80 | 4
! I- 80 | 4
! I- 80 | 4
! I- 80 | 4
! I- 80 | 4
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 11
! I- 80 | 11
! I- 80 | 11
! I- 80 | 11 I- 80 Ramp | 2 I- 80
Ramp | 2 I- 80 Ramp | 2
--- 607,837 ---- I- 580 Ramp | 8 I- 580 Ramp | 8 I- 580
Ramp | 8
! I- 580 | 2
! I- 580 | 2
! I- 580 | 2
! I- 580 | 2
! I- 580 | 2
! I- 580 | 2
! I- 580 | 2
! I- 580 | 2
! I- 580 | 2
! I- 580 | 2
! I- 580 | 2
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 4
! I- 580 | 4
! I- 580 | 4
! I- 580 | 4
! I- 580 | 5
! I- 580 | 5
! I- 580 | 5
! I- 580 | 5
! I- 580 | 5
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 7
! I- 580 | 7
! I- 580 | 7
! I- 580 | 7
! I- 580 | 7
! I- 580 | 7
! I- 580 | 7
! I- 580 | 8
! I- 580 | 8
! I- 580 | 8
! I- 580 | 8
! I- 580 | 8
! I- 580 | 8
! I- 580 | 8
! I- 580 | 8
! I- 580 | 8
! I- 580 | 9
! I- 580 | 9
! I- 580 | 9
! I- 580 | 9
! I- 580 | 9
! I- 580 | 12
! I- 580 | 12
! I- 580 | 12
! I- 580 | 12
! I- 580 | 12
! I- 580 | 12
! I- 580 | 12
! I- 580 | 12
! I- 580 | 12
! I- 580 | 12
! I- 580 | 13
! I- 580 | 13
! I- 580 | 13
! I- 580 | 13
! I- 580 | 13
! I- 580 | 13
! I- 580 | 14
! I- 580 | 14
! I- 580 | 14
! I- 580 | 14
! I- 580 | 14
! I- 580 | 14
! I- 580 | 14
! I- 580 | 14
! I- 580 | 18
! I- 580 | 18
! I- 580 | 18
! I- 580 | 18
! I- 580 | 18
! I- 580 | 18
! I- 580 | 21
! I- 580 | 21
! I- 580 | 21
! I- 580 | 21
! I- 580 | 21
! I- 580 | 21
! I- 580 | 21
! I- 580 | 21
! I- 580 | 21
! I- 580 | 21
! I- 580 | 22
! I- 580 | 22
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 4
! I- 680 Ramp | 4
! I- 680 Ramp | 4
! I- 680 Ramp | 5
! I- 680 Ramp | 5
! I- 680 Ramp | 5
! I- 680 Ramp | 5
! I- 680 Ramp | 5
! I- 680 Ramp | 5
! I- 680 Ramp | 6
! I- 680 Ramp | 6
! I- 680 Ramp | 6
! I- 680 Ramp | 6
! I- 680 Ramp | 7
! I- 680 Ramp | 7
! I- 680 Ramp | 7
! I- 680 Ramp | 7
! I- 680 Ramp | 8
! I- 680 Ramp | 8
! I- 680 Ramp | 8
! I- 680 Ramp | 8
! I- 680 | 2
! I- 680 | 2
! I- 680 | 2
! I- 680 | 2
! I- 680 | 2
! I- 680 | 2
! I- 680 | 2
! I- 680 | 3
! I- 680 | 3
! I- 680 | 3
! I- 680 | 4
! I- 680 | 4
! I- 680 | 4
! I- 680 | 5
! I- 680 | 5
! I- 680 | 5
! I- 680 | 7
! I- 680 | 7
! I- 680 | 7
! I- 680 | 7
! I- 680 | 8
! I- 680 | 8
! I- 680 | 8
! I- 680 | 8
! I- 680 | 10
! I- 680 | 10
! I- 680 | 10
! I- 680 | 10
! I- 680 | 10
! I- 680 | 10
! I- 680 | 10
! I- 680 | 16
! I- 680 | 16
! I- 680 | 16
! I- 680 | 16
! I- 680 | 16
! I- 680 | 16
! I- 680 | 16
! I- 680 | 16 I- 80 Ramp | 2 I- 80
Ramp | 2 I- 80 Ramp | 2
***************
*** 910,1026 **** I- 80 Ramp | 7 I- 80 Ramp | 7 I- 80
Ramp | 7
! I- 880 | 2
! I- 880 | 2
! I- 880 | 2
! I- 880 | 2
! I- 880 | 2
! I- 880 | 5
! I- 880 | 5
! I- 880 | 5
! I- 880 | 5
! I- 880 | 5
! I- 880 | 5
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 7
! I- 880 | 7
! I- 880 | 7
! I- 880 | 7
! I- 880 | 7
! I- 880 | 7
! I- 880 | 7
! I- 880 | 9
! I- 880 | 9
! I- 880 | 9
! I- 880 | 9
! I- 880 | 9
! I- 880 | 9
! I- 880 | 9
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 12
! I- 880 | 12
! I- 880 | 12
! I- 880 | 12
! I- 880 | 12
! I- 880 | 12
! I- 880 | 12
! I- 880 | 12
! I- 880 | 12
! I- 880 | 12
! I- 880 | 12
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 14
! I- 880 | 14
! I- 880 | 14
! I- 880 | 14
! I- 880 | 14
! I- 880 | 14
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 19
! I- 880 | 19
! I- 880 | 19
! I- 880 | 19
! I- 880 | 19
! I- 880 | 19
! I- 880 | 19
! I- 880 | 19
! I- 880 | 19
! I- 880 | 19 I- 880 Ramp | 2 I- 880
Ramp | 2 I- 880 Ramp | 2
--- 875,915 ---- I- 80 Ramp | 7 I- 80 Ramp | 7 I- 80
Ramp | 7
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 3
! I- 80 | 3
! I- 80 | 3
! I- 80 | 4
! I- 80 | 4
! I- 80 | 4
! I- 80 | 4
! I- 80 | 4
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 11
! I- 80 | 11
! I- 80 | 11
! I- 80 | 11 I- 880 Ramp | 2 I- 880
Ramp | 2 I- 880 Ramp | 2
***************
*** 1209,1214 ****
--- 1098,1218 ---- I- 880 Ramp | 8 I- 880 Ramp | 8 I-
880 Ramp | 8
+ I- 880 | 2
+ I- 880 | 2
+ I- 880 | 2
+ I- 880 | 2
+ I- 880 | 2
+ I- 880 | 5
+ I- 880 | 5
+ I- 880 | 5
+ I- 880 | 5
+ I- 880 | 5
+ I- 880 | 5
+ I- 880 | 6
+ I- 880 | 6
+ I- 880 | 6
+ I- 880 | 6
+ I- 880 | 6
+ I- 880 | 6
+ I- 880 | 6
+ I- 880 | 6
+ I- 880 | 6
+ I- 880 | 6
+ I- 880 | 6
+ I- 880 | 6
+ I- 880 | 6
+ I- 880 | 6
+ I- 880 | 7
+ I- 880 | 7
+ I- 880 | 7
+ I- 880 | 7
+ I- 880 | 7
+ I- 880 | 7
+ I- 880 | 7
+ I- 880 | 9
+ I- 880 | 9
+ I- 880 | 9
+ I- 880 | 9
+ I- 880 | 9
+ I- 880 | 9
+ I- 880 | 9
+ I- 880 | 10
+ I- 880 | 10
+ I- 880 | 10
+ I- 880 | 10
+ I- 880 | 10
+ I- 880 | 10
+ I- 880 | 10
+ I- 880 | 10
+ I- 880 | 10
+ I- 880 | 10
+ I- 880 | 10
+ I- 880 | 10
+ I- 880 | 12
+ I- 880 | 12
+ I- 880 | 12
+ I- 880 | 12
+ I- 880 | 12
+ I- 880 | 12
+ I- 880 | 12
+ I- 880 | 12
+ I- 880 | 12
+ I- 880 | 12
+ I- 880 | 12
+ I- 880 | 13
+ I- 880 | 13
+ I- 880 | 13
+ I- 880 | 13
+ I- 880 | 13
+ I- 880 | 13
+ I- 880 | 13
+ I- 880 | 13
+ I- 880 | 13
+ I- 880 | 13
+ I- 880 | 13
+ I- 880 | 13
+ I- 880 | 14
+ I- 880 | 14
+ I- 880 | 14
+ I- 880 | 14
+ I- 880 | 14
+ I- 880 | 14
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 17
+ I- 880 | 19
+ I- 880 | 19
+ I- 880 | 19
+ I- 880 | 19
+ I- 880 | 19
+ I- 880 | 19
+ I- 880 | 19
+ I- 880 | 19
+ I- 880 | 19
+ I- 880 | 19
+ I- 980 Ramp | 3
+ I- 980 Ramp | 3
+ I- 980 Ramp | 3
+ I- 980 Ramp | 7 I- 980 | 2 I- 980
| 2 I- 980 | 2
***************
*** 1235,1244 **** I- 980 | 7 I- 980 | 7 I-
980 | 12
- I- 980 Ramp | 3
- I- 980 Ramp | 3
- I- 980 Ramp | 3
- I- 980 Ramp | 7 (896 rows) SELECT * FROM toyemp WHERE name = 'sharon';
--- 1239,1244 ----
======================================================================
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On 4/30/17 20:06, tomasz.kontusz@gmail.com wrote: > When running `./configure && make check` on Ubuntu 16.04 with pl_PL.UTF-8 > locale I'm getting 2 test failures. No failures are reported for `LANG=C > make check`. We try to keep the tests so that they pass under many locales. But some are just so different that it's too cumbersome to maintain. This is one such case. Sorry. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
> We try to keep the tests so that they pass under many locales. But some > are just so different that it's too cumbersome to maintain. This is one > such case. Sorry. The select_views test has also confused me while I was working on the geometric types [1]. It is hard to figure out if the failure is positive or a collation issue. I don't think this test is responsible from testing collations. Can we change this to ORDER BY name COLLATE "C"? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Emre Hasegeli <emre@hasegeli.com> writes:
> The select_views test has also confused me while I was working on the
> geometric types [1]. It is hard to figure out if the failure is
> positive or a collation issue. I don't think this test is responsible
> from testing collations. Can we change this to ORDER BY name COLLATE
> "C"?
Uh, change what exactly?
FWIW, I tried to reproduce the OP's reported failure with pl_PL.UTF-8,
but it seems to pass fine for me. This implies that that locale works
differently on his Ubuntu box than my RHEL box, which makes the idea
of trying to guarantee that it works even more problematic.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
> FWIW, I tried to reproduce the OP's reported failure with pl_PL.UTF-8, > but it seems to pass fine for me. This implies that that locale works > differently on his Ubuntu box than my RHEL box, which makes the idea > of trying to guarantee that it works even more problematic. It works on my computer too: > hasegeli=# select 'I- 580 Ramp' < 'I- 580/I-680 Ramp' collate "en_US"; > ?column? > ---------- > t > (1 row) But not on my Debian box: > debian=# select 'I- 580 Ramp' < 'I- 580/I-680 Ramp' collate "en_US"; > ?column? > ---------- > f > (1 row) It is fine with COLLATE "C": > debian =# select 'I- 580 Ramp' < 'I- 580/I-680 Ramp' collate "C"; > ?column? > ---------- > t > (1 row) I suggest the attached. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Attachment
Emre Hasegeli <emre@hasegeli.com> writes:
> I suggest the attached.
Hm. This would apparently not resolve the OP's problem, because he
had some additional diffs besides that one. But getting rid of
expected/select_views_1.out seems like a good end in itself. +1.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
I wrote:
> Emre Hasegeli <emre@hasegeli.com> writes:
>> I suggest the attached.
> Hm. This would apparently not resolve the OP's problem, because he
> had some additional diffs besides that one. But getting rid of
> expected/select_views_1.out seems like a good end in itself. +1.
Hearing no objections, pushed.
I concur with Peter's opinion that we shouldn't try to do anything
in create_index.sql.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs