diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2009-01-19 12:02:29 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2009-01-19 12:02:29 +0000 |
| commit | 2b01cbe34042ed9fdea38a0c2fad5ab81df032c9 (patch) | |
| tree | b2da5e79a4bb2fc1a136b2d1e354d95c7b6ade89 /src | |
| parent | 0d8c613180e41bcd23aebe7bc3537593b90c0ece (diff) | |
| download | postgresql-2b01cbe34042ed9fdea38a0c2fad5ab81df032c9.tar.gz postgresql-2b01cbe34042ed9fdea38a0c2fad5ab81df032c9.zip | |
Alter the regression test cases that rely on the sort order of "ch" between
"cg" and "ci". This eliminates a test failure on the following glibc
locales: br_FR, cs_CZ, cy_GB, es_EC, es_US, hsb_DE, ig_NG, ik_CA, sk_SK.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/rules.out | 12 | ||||
| -rw-r--r-- | src/test/regress/sql/rules.sql | 4 |
2 files changed, 8 insertions, 8 deletions
diff --git a/src/test/regress/expected/rules.out b/src/test/regress/expected/rules.out index 977b17cd51b..2daa79d732d 100644 --- a/src/test/regress/expected/rules.out +++ b/src/test/regress/expected/rules.out @@ -403,9 +403,9 @@ select * from rtest_admin; -- -- Rule qualification test -- -insert into rtest_emp values ('wiech', '5000.00'); +insert into rtest_emp values ('wiecc', '5000.00'); insert into rtest_emp values ('gates', '80000.00'); -update rtest_emp set ename = 'wiecx' where ename = 'wiech'; +update rtest_emp set ename = 'wiecx' where ename = 'wiecc'; update rtest_emp set ename = 'wieck', salary = '6000.00' where ename = 'wiecx'; update rtest_emp set salary = '7000.00' where ename = 'wieck'; delete from rtest_emp where ename = 'gates'; @@ -414,7 +414,7 @@ select ename, who = current_user as "matches user", action, newsal, oldsal from ----------------------+--------------+------------+------------+------------ gates | t | fired | $0.00 | $80,000.00 gates | t | hired | $80,000.00 | $0.00 - wiech | t | hired | $5,000.00 | $0.00 + wiecc | t | hired | $5,000.00 | $0.00 wieck | t | honored | $6,000.00 | $5,000.00 wieck | t | honored | $7,000.00 | $6,000.00 (5 rows) @@ -431,7 +431,7 @@ select ename, who = current_user as "matches user", action, newsal, oldsal from maier | t | hired | $5,000.00 | $0.00 mayr | t | hired | $6,000.00 | $0.00 meyer | t | hired | $4,000.00 | $0.00 - wiech | t | hired | $5,000.00 | $0.00 + wiecc | t | hired | $5,000.00 | $0.00 wieck | t | honored | $6,000.00 | $5,000.00 wieck | t | honored | $7,000.00 | $6,000.00 (8 rows) @@ -449,7 +449,7 @@ select ename, who = current_user as "matches user", action, newsal, oldsal from mayr | t | honored | $7,000.00 | $6,000.00 meyer | t | hired | $4,000.00 | $0.00 meyer | t | honored | $5,000.00 | $4,000.00 - wiech | t | hired | $5,000.00 | $0.00 + wiecc | t | hired | $5,000.00 | $0.00 wieck | t | honored | $6,000.00 | $5,000.00 wieck | t | honored | $7,000.00 | $6,000.00 (11 rows) @@ -469,7 +469,7 @@ select ename, who = current_user as "matches user", action, newsal, oldsal from meyer | t | fired | $0.00 | $5,000.00 meyer | t | hired | $4,000.00 | $0.00 meyer | t | honored | $5,000.00 | $4,000.00 - wiech | t | hired | $5,000.00 | $0.00 + wiecc | t | hired | $5,000.00 | $0.00 wieck | t | honored | $6,000.00 | $5,000.00 wieck | t | honored | $7,000.00 | $6,000.00 (14 rows) diff --git a/src/test/regress/sql/rules.sql b/src/test/regress/sql/rules.sql index e898336d92a..a522d52d199 100644 --- a/src/test/regress/sql/rules.sql +++ b/src/test/regress/sql/rules.sql @@ -273,9 +273,9 @@ select * from rtest_admin; -- -- Rule qualification test -- -insert into rtest_emp values ('wiech', '5000.00'); +insert into rtest_emp values ('wiecc', '5000.00'); insert into rtest_emp values ('gates', '80000.00'); -update rtest_emp set ename = 'wiecx' where ename = 'wiech'; +update rtest_emp set ename = 'wiecx' where ename = 'wiecc'; update rtest_emp set ename = 'wieck', salary = '6000.00' where ename = 'wiecx'; update rtest_emp set salary = '7000.00' where ename = 'wieck'; delete from rtest_emp where ename = 'gates'; |