diff options
Diffstat (limited to 'mysql-test/main/client_xml.result')
| -rw-r--r-- | mysql-test/main/client_xml.result | 92 |
1 files changed, 92 insertions, 0 deletions
diff --git a/mysql-test/main/client_xml.result b/mysql-test/main/client_xml.result new file mode 100644 index 00000000000..6f91c18318c --- /dev/null +++ b/mysql-test/main/client_xml.result @@ -0,0 +1,92 @@ +set @old_concurrent_insert= @@global.concurrent_insert; +set @@global.concurrent_insert= 0; +drop table if exists t1; +create table t1 ( +`a&b` int, +`a<b` int NOT NULL, +`a>b` text +); +insert into t1 values (1, 2, 'a&b a<b a>b'); +<?xml version="1.0"?> + +<resultset statement="select * from t1 +" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> + <row> + <field name="a&b">1</field> + <field name="a<b">2</field> + <field name="a>b">a&b a<b a>b</field> + </row> +</resultset> +<?xml version="1.0"?> +<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> +<database name="test"> + <table_structure name="t1"> + <field Field="a&b" Type="int(11)" Null="YES" Key="" Default="NULL" Extra="" Comment="" /> + <field Field="a<b" Type="int(11)" Null="NO" Key="" Extra="" Comment="" /> + <field Field="a>b" Type="text" Null="YES" Key="" Default="NULL" Extra="" Comment="" /> + </table_structure> + <table_data name="t1"> + <row> + <field name="a&b">1</field> + <field name="a<b">2</field> + <field name="a>b">a&b a<b a>b</field> + </row> + </table_data> +</database> +</mysqldump> +<?xml version="1.0"?> + +<resultset statement="select count(*) from t1 +" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> + <row> + <field name="count(*)">1</field> + </row> +</resultset> +<?xml version="1.0"?> + +<resultset statement="select 1 < 2 from dual +" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> + <row> + <field name="1 < 2">1</field> + </row> +</resultset> +<?xml version="1.0"?> + +<resultset statement="select 1 > 2 from dual +" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> + <row> + <field name="1 > 2">0</field> + </row> +</resultset> +<?xml version="1.0"?> + +<resultset statement="select 1 & 3 from dual +" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> + <row> + <field name="1 & 3">1</field> + </row> +</resultset> +<?xml version="1.0"?> + +<resultset statement="select null from dual +" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> + <row> + <field name="NULL" xsi:nil="true" /> + </row> +</resultset> +<?xml version="1.0"?> + +<resultset statement="select 1 limit 0 +" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"></resultset> +-------------- +select 1 limit 0 +-------------- + +<?xml version="1.0"?> + +<resultset statement="select 1 limit 0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"></resultset> +Empty set + +Bye +drop table t1; +set @@global.concurrent_insert= @old_concurrent_insert; |