1set @old_concurrent_insert= @@global.concurrent_insert;
2set @@global.concurrent_insert= 0;
3drop table if exists t1;
4create table t1 (
5`a&b` int,
6`a<b` int NOT NULL,
7`a>b` text
8);
9insert into t1 values (1, 2, 'a&b a<b a>b');
10<?xml version="1.0"?>
11
12<resultset statement="select * from t1
13" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
14  <row>
15	<field name="a&amp;b">1</field>
16	<field name="a&lt;b">2</field>
17	<field name="a&gt;b">a&amp;b a&lt;b a&gt;b</field>
18  </row>
19</resultset>
20<?xml version="1.0"?>
21<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
22<database name="test">
23	<table_structure name="t1">
24		<field Field="a&amp;b" Type="int(11)" Null="YES" Key="" Default="NULL" Extra="" Comment="" />
25		<field Field="a&lt;b" Type="int(11)" Null="NO" Key="" Extra="" Comment="" />
26		<field Field="a&gt;b" Type="text" Null="YES" Key="" Default="NULL" Extra="" Comment="" />
27	</table_structure>
28	<table_data name="t1">
29	<row>
30		<field name="a&amp;b">1</field>
31		<field name="a&lt;b">2</field>
32		<field name="a&gt;b">a&amp;b a&lt;b a&gt;b</field>
33	</row>
34	</table_data>
35</database>
36</mysqldump>
37<?xml version="1.0"?>
38
39<resultset statement="select count(*) from t1
40" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
41  <row>
42	<field name="count(*)">1</field>
43  </row>
44</resultset>
45<?xml version="1.0"?>
46
47<resultset statement="select 1 &lt; 2 from dual
48" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
49  <row>
50	<field name="1 &lt; 2">1</field>
51  </row>
52</resultset>
53<?xml version="1.0"?>
54
55<resultset statement="select 1 &gt; 2 from dual
56" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
57  <row>
58	<field name="1 &gt; 2">0</field>
59  </row>
60</resultset>
61<?xml version="1.0"?>
62
63<resultset statement="select 1 &amp; 3 from dual
64" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
65  <row>
66	<field name="1 &amp; 3">1</field>
67  </row>
68</resultset>
69<?xml version="1.0"?>
70
71<resultset statement="select null from dual
72" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
73  <row>
74	<field name="NULL" xsi:nil="true" />
75  </row>
76</resultset>
77<?xml version="1.0"?>
78
79<resultset statement="select 1 limit 0
80" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"></resultset>
81--------------
82select 1 limit 0
83--------------
84
85<?xml version="1.0"?>
86
87<resultset statement="select 1 limit 0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"></resultset>
88Empty set
89
90Bye
91drop table t1;
92set @@global.concurrent_insert= @old_concurrent_insert;
93