Thread
Commits
-
Avoid locale-dependent output in select_views regression test.
- eac0a6c7d35d 10.0 landed
-
Sync our copy of the timezone library with IANA release tzcode2017b.
- 6872d96a3bb8 9.6.3 cited
- e18b2c480da4 10.0 cited
-
BUG #14637: Tests fail with pl_PL.UTF-8 locale
tomasz.kontusz@gmail.com — 2017-05-01T00:06:09Z
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 ---- ====================================================================== -
Re: BUG #14637: Tests fail with pl_PL.UTF-8 locale
Peter Eisentraut <peter.eisentraut@2ndquadrant.com> — 2017-05-15T15:40:07Z
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
-
Re: BUG #14637: Tests fail with pl_PL.UTF-8 locale
Emre Hasegeli <emre@hasegeli.com> — 2017-05-23T08:27:30Z
> 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"?
-
Re: BUG #14637: Tests fail with pl_PL.UTF-8 locale
Tom Lane <tgl@sss.pgh.pa.us> — 2017-05-25T14:15:58Z
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
-
Re: BUG #14637: Tests fail with pl_PL.UTF-8 locale
Emre Hasegeli <emre@hasegeli.com> — 2017-05-25T14:44:39Z
> 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.
-
Re: BUG #14637: Tests fail with pl_PL.UTF-8 locale
Tom Lane <tgl@sss.pgh.pa.us> — 2017-05-25T14:52:40Z
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
-
Re: BUG #14637: Tests fail with pl_PL.UTF-8 locale
Tom Lane <tgl@sss.pgh.pa.us> — 2017-05-28T18:53:39Z
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