NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitb626483

committed

Fix random regression failure in test case "collate.icu.utf8"

This is a fix similar to2d7d67c, where slight plan alteration cancause a random failure of this regression test because of an incorecttuple ordering, except that this one involves lookups of pg_type.Similarly to the other case, add ORDER BY clauses to ensure the outputorder.The failure has been seen at least once on buildfarm member skink.Reported-by: Thomas MunroDiscussion:https://postgr.es/m/CA+hUKGLjR9ZBvhXcr9b-NSBHPw9aRgbjyzGE+kqLsT4vwX+nkQ@mail.gmail.comBackpatch-through: 12

1 parent6844adb commitb626483Copy full SHA for b626483

File tree

2 files changed

-4

lines changed

src/test/regress
- expected
  - collate.icu.utf8.out
- sql
  - collate.icu.utf8.sql

2 files changed

-4

lines changed

`‎src/test/regress/expected/collate.icu.utf8.out`

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1644,14 +1644,16 @@ SELECT relname FROM pg_class WHERE 'PG_CLASS'::text = relname COLLATE case_insen`
`1644`	`1644`	`pg_class`
`1645`	`1645`	`(1 row)`
`1646`	`1646`
`1647`		`-SELECT typname FROM pg_type WHERE typname LIKE 'int_' AND typname <> 'INT2'::text COLLATE case_insensitive;`
	`1647`	`+SELECT typname FROM pg_type WHERE typname LIKE 'int_' AND typname <> 'INT2'::text`
	`1648`	`+ COLLATE case_insensitive ORDER BY typname;`
`1648`	`1649`	`typname`
`1649`	`1650`	`---------`
`1650`	`1651`	`int4`
`1651`	`1652`	`int8`
`1652`	`1653`	`(2 rows)`
`1653`	`1654`
`1654`		`-SELECT typname FROM pg_type WHERE typname LIKE 'int_' AND 'INT2'::text <> typname COLLATE case_insensitive;;`
	`1655`	`+SELECT typname FROM pg_type WHERE typname LIKE 'int_' AND 'INT2'::text <> typname`
	`1656`	`+ COLLATE case_insensitive ORDER BY typname;`
`1655`	`1657`	`typname`
`1656`	`1658`	`---------`
`1657`	`1659`	`int4`

`‎src/test/regress/sql/collate.icu.utf8.sql`

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -595,8 +595,10 @@ SELECT 'ὀδυσσεύς' = 'ὈΔΥΣΣΕΎΣ' COLLATE case_insensitive;`
`595`	`595`	`SELECT relnameFROM pg_classWHERE relname='PG_CLASS'::text COLLATE case_insensitive;`
`596`	`596`	`SELECT relnameFROM pg_classWHERE'PG_CLASS'::text= relname COLLATE case_insensitive;`
`597`	`597`
`598`		`-SELECT typnameFROM pg_typeWHERE typnameLIKE'int_'AND typname<>'INT2'::text COLLATE case_insensitive;`
`599`		`-SELECT typnameFROM pg_typeWHERE typnameLIKE'int_'AND'INT2'::text<> typname COLLATE case_insensitive;;`
	`598`	`+SELECT typnameFROM pg_typeWHERE typnameLIKE'int_'AND typname<>'INT2'::text`
	`599`	`+ COLLATE case_insensitiveORDER BY typname;`
	`600`	`+SELECT typnameFROM pg_typeWHERE typnameLIKE'int_'AND'INT2'::text<> typname`
	`601`	`+ COLLATE case_insensitiveORDER BY typname;`
`600`	`602`
`601`	`603`	`-- test case adapted from subselect.sql`
`602`	`604`	`CREATE TEMP TABLE outer_text (f1text COLLATE case_insensitive, f2text);`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitb626483

File tree

2 files changed

2 files changed

`‎src/test/regress/expected/collate.icu.utf8.out`

`‎src/test/regress/sql/collate.icu.utf8.sql`

0 commit comments