diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2017-05-03 21:25:01 -0400 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2017-05-04 21:31:12 -0400 |
| commit | 6e86b448f2f700ab0a05afbeba80fbadfcd1d70a (patch) | |
| tree | 31d9edac1a2bfdb968fde9af58129d729aa57d86 /src/test/regress/sql/xmlmap.sql | |
| parent | 85b3bcbcd61cc1b5aac35e53edc67abd1bceee08 (diff) | |
Fix cursor_to_xml in tableforest false mode
It only produced <row> elements but no wrapping <table> element.
By contrast, cursor_to_xmlschema produced a schema that is now correct
but did not previously match the XML data produced by cursor_to_xml.
In passing, also fix a minor misunderstanding about moving cursors in
the tests related to this.
Reported-by: filip@jirsak.org
Based-on-patch-by: Thomas Munro <thomas.munro@enterprisedb.com>
Diffstat (limited to 'src/test/regress/sql/xmlmap.sql')
| -rw-r--r-- | src/test/regress/sql/xmlmap.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/test/regress/sql/xmlmap.sql b/src/test/regress/sql/xmlmap.sql index 8f8d6808139..fde1b9eb597 100644 --- a/src/test/regress/sql/xmlmap.sql +++ b/src/test/regress/sql/xmlmap.sql @@ -30,7 +30,8 @@ SELECT query_to_xml_and_xmlschema('SELECT * FROM testxmlschema.test1', true, tru DECLARE xc CURSOR WITH HOLD FOR SELECT * FROM testxmlschema.test1 ORDER BY 1, 2; SELECT cursor_to_xml('xc'::refcursor, 5, false, true, ''); -MOVE FIRST IN xc; +SELECT cursor_to_xmlschema('xc'::refcursor, false, true, ''); +MOVE BACKWARD ALL IN xc; SELECT cursor_to_xml('xc'::refcursor, 5, true, false, ''); SELECT cursor_to_xmlschema('xc'::refcursor, true, false, ''); |