Commiteecbb33

committed

Add ORDER BY to a query on information_schema.views, to avoid possible

platform-specific result ordering. Per buildfarm results.

1 parentbfe553f commiteecbb33Copy full SHA for eecbb33

File tree

-3

lines changed

-3

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -386,7 +386,8 @@ CREATE VIEW xmlview6 AS SELECT xmlpi(name foo, 'bar');`
`386`	`386`	`CREATE VIEW xmlview7 AS SELECT xmlroot(xml '<foo/>', version no value, standalone yes);`
`387`	`387`	`CREATE VIEW xmlview8 AS SELECT xmlserialize(content 'good' as char(10));`
`388`	`388`	`CREATE VIEW xmlview9 AS SELECT xmlserialize(content 'good' as text);`
`389`		`-SELECT table_name, view_definition FROM information_schema.views WHERE table_name LIKE 'xmlview%';`
	`389`	`+SELECT table_name, view_definition FROM information_schema.views`
	`390`	`+ WHERE table_name LIKE 'xmlview%' ORDER BY 1;`
`390`	`391`	`table_name \| view_definition`
`391`	`392`	`------------+--------------------------------------------------------------------------------------------------------------------------------`
`392`	`393`	`xmlview1 \| SELECT xmlcomment('test'::text) AS xmlcomment;`

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -189,7 +189,8 @@ CREATE VIEW xmlview8 AS SELECT xmlserialize(content 'good' as char(10));`
`189`	`189`	`ERROR: no XML support in this installation`
`190`	`190`	`CREATE VIEW xmlview9 AS SELECT xmlserialize(content 'good' as text);`
`191`	`191`	`ERROR: no XML support in this installation`
`192`		`-SELECT table_name, view_definition FROM information_schema.views WHERE table_name LIKE 'xmlview%';`
	`192`	`+SELECT table_name, view_definition FROM information_schema.views`
	`193`	`+ WHERE table_name LIKE 'xmlview%' ORDER BY 1;`
`193`	`194`	`table_name \| view_definition`
`194`	`195`	`------------+-------------------------------------------------------------------------------`
`195`	`196`	`xmlview1 \| SELECT xmlcomment('test'::text) AS xmlcomment;`

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -142,4 +142,5 @@ CREATE VIEW xmlview7 AS SELECT xmlroot(xml '<foo/>', version no value, standalon`
`142`	`142`	`CREATEVIEWxmlview8ASSELECT xmlserialize(content'good'aschar(10));`
`143`	`143`	`CREATEVIEWxmlview9ASSELECT xmlserialize(content'good'astext);`
`144`	`144`
`145`		`-SELECT table_name, view_definitionFROMinformation_schema.viewsWHERE table_nameLIKE'xmlview%';`
	`145`	`+SELECT table_name, view_definitionFROMinformation_schema.views`
	`146`	`+WHERE table_nameLIKE'xmlview%'ORDER BY1;`

Comments

(0)