~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/r/client_xml.result

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

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