regression.diffs
application/octet-stream
Filename: regression.diffs
Type: application/octet-stream
Part: 0
*** /media/linux_hhd/pgsql/releases/9.1/src/test/regress/expected/collate.out 2010-08-01 18:58:50.000000000 -0500
--- /media/linux_hhd/pgsql/releases/9.1/src/test/regress/results/collate.out 2010-08-01 19:23:14.000000000 -0500
***************
*** 6,14 ****
a int,
b text COLLATE "en_US"
);
! ERROR: collation "en_US" is not applicable to current database encoding "UTF8"
! LINE 3: b text COLLATE "en_US"
! ^
CREATE TABLE collate_test_fail (
a int,
b text COLLATE "foo"
--- 6,12 ----
a int,
b text COLLATE "en_US"
);
! ERROR: collation "en_US" does not exist
CREATE TABLE collate_test_fail (
a int,
b text COLLATE "foo"
***************
*** 25,32 ****
--- 23,34 ----
a int,
b text COLLATE "sv_SE.utf8"
);
+ ERROR: collation "sv_SE.utf8" does not exist
INSERT INTO collate_test1 VALUES (1, 'abc'), (2, 'äbc'), (3, 'bbc');
INSERT INTO collate_test2 SELECT * FROM collate_test1;
+ ERROR: relation "collate_test2" does not exist
+ LINE 1: INSERT INTO collate_test2 SELECT * FROM collate_test1;
+ ^
SELECT * FROM collate_test1 WHERE b >= 'bbc';
a | b
---+-----
***************
*** 34,42 ****
(1 row)
SELECT * FROM collate_test2 WHERE b >= 'bbc';
! a | b
! ---+-----
! 2 | äbc
! 3 | bbc
! (2 rows)
!
--- 36,41 ----
(1 row)
SELECT * FROM collate_test2 WHERE b >= 'bbc';
! ERROR: relation "collate_test2" does not exist
! LINE 1: SELECT * FROM collate_test2 WHERE b >= 'bbc';
! ^
======================================================================