Commitb5737ef

committed

Remove unnecessary and problematic collate.windows.win1252 tests

Some windows instances can't handle setting lc_time to a non BCP 47locale, and the removed tests in any case don't really make lots ofsense here.Juan José Santamaría FlechaDiscussion:https://postgr.es/m/237b255b-e063-a82e-66e1-c63a12bf9664@dunslane.net

1 parent71a7562 commitb5737efCopy full SHA for b5737ef

File tree

-37

lines changed

-37

lines changed

Lines changed: 0 additions & 24 deletions

Original file line number	Diff line number	Diff line change
`@@ -361,30 +361,6 @@ SELECT relname FROM pg_class WHERE relname ~* '^abc';`
`361`	`361`	`---------`
`362`	`362`	`(0 rows)`
`363`	`363`
`364`		`--- to_char`
`365`		`-SET lc_time TO 'de_DE';`
`366`		`-SELECT to_char(date '2010-03-01', 'DD TMMON YYYY');`
`367`		`- to_char`
`368`		`--------------`
`369`		`- 01 MRZ 2010`
`370`		`-(1 row)`
`371`		`-`
`372`		`-SELECT to_char(date '2010-03-01', 'DD TMMON YYYY' COLLATE "de_DE");`
`373`		`- to_char`
`374`		`--------------`
`375`		`- 01 MRZ 2010`
`376`		`-(1 row)`
`377`		`-`
`378`		`--- to_date`
`379`		`-SELECT to_date('01 M�R 2010', 'DD TMMON YYYY');`
`380`		`-ERROR: invalid value "M�R" for "MON"`
`381`		`-DETAIL: The given value did not match any of the allowed values for this field.`
`382`		`-SELECT to_date('01 M�r 2010', 'DD TMMON YYYY');`
`383`		`-ERROR: invalid value "M�r" for "MON"`
`384`		`-DETAIL: The given value did not match any of the allowed values for this field.`
`385`		`-SELECT to_date('1234567890ab 2010', 'TMMONTH YYYY'); -- fail`
`386`		`-ERROR: invalid value "1234567890ab" for "MONTH"`
`387`		`-DETAIL: The given value did not match any of the allowed values for this field.`
`388`	`364`	`-- backwards parsing`
`389`	`365`	`CREATE VIEW collview1 AS SELECT * FROM collate_test1 WHERE b COLLATE "C" >= 'bbc';`
`390`	`366`	`CREATE VIEW collview2 AS SELECT a, b FROM collate_test1 ORDER BY b COLLATE "C";`

Lines changed: 0 additions & 13 deletions

Original file line number	Diff line number	Diff line change
`@@ -150,19 +150,6 @@ FROM collate_test6;`
`150`	`150`	`SELECT relnameFROM pg_classWHERE relname ~*'^abc';`
`151`	`151`
`152`	`152`
`153`		`--- to_char`
`154`		`-`
`155`		`-SET lc_time TO'de_DE';`
`156`		`-SELECT to_char(date'2010-03-01','DD TMMON YYYY');`
`157`		`-SELECT to_char(date'2010-03-01','DD TMMON YYYY' COLLATE"de_DE");`
`158`		`-`
`159`		`--- to_date`
`160`		`-`
`161`		`-SELECT to_date('01 MÄR 2010','DD TMMON YYYY');`
`162`		`-SELECT to_date('01 Mär 2010','DD TMMON YYYY');`
`163`		`-SELECT to_date('1234567890ab 2010','TMMONTH YYYY');-- fail`
`164`		`-`
`165`		`-`
`166`	`153`	`-- backwards parsing`
`167`	`154`
`168`	`155`	`CREATEVIEWcollview1ASSELECT*FROM collate_test1WHERE b COLLATE"C">='bbc';`

Comments

(0)