Commit0ebd20e

committed

Update xml_1.out and xml_2.out

Commit0fbf011 should have updated them but didn't.

1 parentade1770 commit0ebd20eCopy full SHA for 0ebd20e

File tree

-0

lines changed

-0

lines changed

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1016,6 +1016,9 @@ EXPLAIN (COSTS OFF, VERBOSE) SELECT * FROM xmltableview1;`
`1016`	`1016`	`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))`
`1017`	`1017`	`(7 rows)`
`1018`	`1018`
	`1019`	`+-- errors`
	`1020`	`+SELECT * FROM XMLTABLE (ROW () PASSING null COLUMNS v1 timestamp) AS f (v1, v2);`
	`1021`	`+ERROR: XMLTABLE function has 1 columns available but 2 columns specified`
`1019`	`1022`	`-- XMLNAMESPACES tests`
`1020`	`1023`	`SELECT * FROM XMLTABLE(XMLNAMESPACES('http://x.y' AS zz),`
`1021`	`1024`	`'/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)