Commit62221ef

committed

Update xml_1.out and xml_2.out

Commit0fbf011 should have updated them but didn't.

1 parent12e423e commit62221efCopy full SHA for 62221ef

File tree

-0

lines changed

-0

lines changed

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -873,6 +873,9 @@ EXPLAIN (COSTS OFF, VERBOSE) SELECT * FROM xmltableview1;`
`873`	`873`	`Table Function Call: XMLTABLE(('/ROWS/ROW'::text) PASSING (xmldata.data) COLUMNS id integer PATH ('@id'::text), _id FOR ORDINALITY, country_name text PATH ('COUNTRY_NAME/text()'::text) NOT NULL, country_id text PATH ('COUNTRY_ID'::text), region_id integer PATH ('REGION_ID'::text), size double precision PATH ('SIZE'::text), unit text PATH ('SIZE/@unit'::text), premier_name text DEFAULT ('not specified'::text) PATH ('PREMIER_NAME'::text))`
`874`	`874`	`(7 rows)`
`875`	`875`
	`876`	`+-- errors`
	`877`	`+SELECT * FROM XMLTABLE (ROW () PASSING null COLUMNS v1 timestamp) AS f (v1, v2);`
	`878`	`+ERROR: XMLTABLE function has 1 columns available but 2 columns specified`
`876`	`879`	`-- XMLNAMESPACES tests`
`877`	`880`	`SELECT * FROM XMLTABLE(XMLNAMESPACES('http://x.y' AS zz),`
`878`	`881`	`'/zz:rows/zz:row'`

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1125,6 +1125,9 @@ EXPLAIN (COSTS OFF, VERBOSE) SELECT * FROM xmltableview1;`
`1125`	`1125`	`Table Function Call: XMLTABLE(('/ROWS/ROW'::text) PASSING (xmldata.data) COLUMNS id integer PATH ('@id'::text), _id FOR ORDINALITY, country_name text PATH ('COUNTRY_NAME/text()'::text) NOT NULL, country_id text PATH ('COUNTRY_ID'::text), region_id integer PATH ('REGION_ID'::text), size double precision PATH ('SIZE'::text), unit text PATH ('SIZE/@unit'::text), premier_name text DEFAULT ('not specified'::text) PATH ('PREMIER_NAME'::text))`
`1126`	`1126`	`(7 rows)`
`1127`	`1127`
	`1128`	`+-- errors`
	`1129`	`+SELECT * FROM XMLTABLE (ROW () PASSING null COLUMNS v1 timestamp) AS f (v1, v2);`
	`1130`	`+ERROR: XMLTABLE function has 1 columns available but 2 columns specified`
`1128`	`1131`	`-- XMLNAMESPACES tests`
`1129`	`1132`	`SELECT * FROM XMLTABLE(XMLNAMESPACES('http://x.y' AS zz),`
`1130`	`1133`	`'/zz:rows/zz:row'`

Comments

(0)