diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2022-05-18 23:19:53 +0200 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2022-05-18 23:19:53 +0200 |
| commit | 62221ef187b0098c8f331f804b7c63859e5ee6ff (patch) | |
| tree | 055d8bbd93ffb765f08c809aee189e8f419077eb /src | |
| parent | 12e423e21d8ef47d95a099c12f625f6d191eaf92 (diff) | |
| download | postgresql-62221ef187b0098c8f331f804b7c63859e5ee6ff.tar.gz postgresql-62221ef187b0098c8f331f804b7c63859e5ee6ff.zip | |
Update xml_1.out and xml_2.out
Commit 0fbf01120023 should have updated them but didn't.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/xml_1.out | 3 | ||||
| -rw-r--r-- | src/test/regress/expected/xml_2.out | 3 |
2 files changed, 6 insertions, 0 deletions
diff --git a/src/test/regress/expected/xml_1.out b/src/test/regress/expected/xml_1.out index 9aadc89a89c..3477606af76 100644 --- a/src/test/regress/expected/xml_1.out +++ b/src/test/regress/expected/xml_1.out @@ -873,6 +873,9 @@ EXPLAIN (COSTS OFF, VERBOSE) SELECT * FROM xmltableview1; 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)) (7 rows) +-- errors +SELECT * FROM XMLTABLE (ROW () PASSING null COLUMNS v1 timestamp) AS f (v1, v2); +ERROR: XMLTABLE function has 1 columns available but 2 columns specified -- XMLNAMESPACES tests SELECT * FROM XMLTABLE(XMLNAMESPACES('http://x.y' AS zz), '/zz:rows/zz:row' diff --git a/src/test/regress/expected/xml_2.out b/src/test/regress/expected/xml_2.out index 04842602817..493c6186e16 100644 --- a/src/test/regress/expected/xml_2.out +++ b/src/test/regress/expected/xml_2.out @@ -1125,6 +1125,9 @@ EXPLAIN (COSTS OFF, VERBOSE) SELECT * FROM xmltableview1; 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)) (7 rows) +-- errors +SELECT * FROM XMLTABLE (ROW () PASSING null COLUMNS v1 timestamp) AS f (v1, v2); +ERROR: XMLTABLE function has 1 columns available but 2 columns specified -- XMLNAMESPACES tests SELECT * FROM XMLTABLE(XMLNAMESPACES('http://x.y' AS zz), '/zz:rows/zz:row' |