From 2f8f76bcd5f175021e34bf5e23dcefc4286cb485 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Sun, 14 Jan 2007 13:11:54 +0000 Subject: Add support for xmlval IS DOCUMENT expression. --- src/test/regress/expected/xml.out | 27 +++++++++++++++++++++++++++ src/test/regress/expected/xml_1.out | 10 ++++++++++ src/test/regress/sql/xml.sql | 7 +++++++ 3 files changed, 44 insertions(+) (limited to 'src/test') diff --git a/src/test/regress/expected/xml.out b/src/test/regress/expected/xml.out index 275523727b..c33fd8e414 100644 --- a/src/test/regress/expected/xml.out +++ b/src/test/regress/expected/xml.out @@ -228,6 +228,33 @@ SELECT xmlserialize(content data as character varying) FROM xmltest; two (2 rows) +SELECT xml 'bar' IS DOCUMENT; + ?column? +---------- + t +(1 row) + +SELECT xml 'barfoo' IS DOCUMENT; + ?column? +---------- + f +(1 row) + +SELECT xml '' IS NOT DOCUMENT; + ?column? +---------- + f +(1 row) + +SELECT xml 'abc' IS NOT DOCUMENT; + ?column? +---------- + t +(1 row) + +SELECT '<>' IS NOT DOCUMENT; +ERROR: invalid XML content +DETAIL: Element name not found -- Check mapping SQL identifier to XML name SELECT xmlpi(name ":::_xml_abc135.%-&_"); xmlpi diff --git a/src/test/regress/expected/xml_1.out b/src/test/regress/expected/xml_1.out index 9ff3959160..4534ae98cc 100644 --- a/src/test/regress/expected/xml_1.out +++ b/src/test/regress/expected/xml_1.out @@ -107,6 +107,16 @@ SELECT xmlserialize(content data as character varying) FROM xmltest; ------ (0 rows) +SELECT xml 'bar' IS DOCUMENT; +ERROR: no XML support in this installation +SELECT xml 'barfoo' IS DOCUMENT; +ERROR: no XML support in this installation +SELECT xml '' IS NOT DOCUMENT; +ERROR: no XML support in this installation +SELECT xml 'abc' IS NOT DOCUMENT; +ERROR: no XML support in this installation +SELECT '<>' IS NOT DOCUMENT; +ERROR: no XML support in this installation -- Check mapping SQL identifier to XML name SELECT xmlpi(name ":::_xml_abc135.%-&_"); ERROR: no XML support in this installation diff --git a/src/test/regress/sql/xml.sql b/src/test/regress/sql/xml.sql index a22c825129..4492a62cdb 100644 --- a/src/test/regress/sql/xml.sql +++ b/src/test/regress/sql/xml.sql @@ -86,6 +86,13 @@ SELECT xmlroot ( SELECT xmlserialize(content data as character varying) FROM xmltest; +SELECT xml 'bar' IS DOCUMENT; +SELECT xml 'barfoo' IS DOCUMENT; +SELECT xml '' IS NOT DOCUMENT; +SELECT xml 'abc' IS NOT DOCUMENT; +SELECT '<>' IS NOT DOCUMENT; + + -- Check mapping SQL identifier to XML name SELECT xmlpi(name ":::_xml_abc135.%-&_"); -- cgit v1.2.1