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

Commit95810ed

Browse files
committed
Make pltcl regression tests safe for Danish locale.
Another peculiarity of Danish locale is that it has an unusual ideaof how to sort upper vs. lower case. One of the pltcl test cases hasan issue with that. Now that COLLATE works in all supported branches,we can just change the test to be locale-independent, and get rid ofthe variant expected file that used to support non-C locales.
1 parentb3399cb commit95810ed

File tree

3 files changed

+4
-309
lines changed

3 files changed

+4
-309
lines changed

‎src/pl/tcl/expected/pltcl_queries.out

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -163,7 +163,7 @@ select 100 @< 4;
163163
f
164164
(1 row)
165165

166-
select * from T_pkey1 order by key1 using @<, key2;
166+
select * from T_pkey1 order by key1 using @<, key2 collate "C";
167167
key1 | key2 | txt
168168
------+----------------------+------------------------------------------
169169
1 | KEY1-3 | should work
@@ -174,7 +174,7 @@ select * from T_pkey1 order by key1 using @<, key2;
174174
2 | key2-9 | test key
175175
(6 rows)
176176

177-
select * from T_pkey2 order by key1 using @<, key2;
177+
select * from T_pkey2 order by key1 using @<, key2 collate "C";
178178
key1 | key2 | txt
179179
------+----------------------+------------------------------------------
180180
1 | KEY1-3 | test key

‎src/pl/tcl/expected/pltcl_queries_1.out

Lines changed: 0 additions & 305 deletions
This file was deleted.

‎src/pl/tcl/sql/pltcl_queries.sql

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -70,8 +70,8 @@ select tcl_sum(key1) from T_pkey1 where key1 = 99;
7070
select1 @<2;
7171
select100 @<4;
7272

73-
select*from T_pkey1order by key1 using @<, key2;
74-
select*from T_pkey2order by key1 using @<, key2;
73+
select*from T_pkey1order by key1 using @<, key2 collate"C";
74+
select*from T_pkey2order by key1 using @<, key2 collate"C";
7575

7676
-- show dump of trigger data
7777
insert into trigger_testvalues(1,'insert');

0 commit comments

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