← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/std_data/loadxml.dat

  • 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:
mysql-test/std_data/loadxml.dat
 
1
<?xml version="1.0"?>
 
2
<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
 
3
<database name="test">
 
4
        <table_structure name="t1">
 
5
                <field Field="a" Type="int(11)" Null="YES" Key="" Extra="" />
 
6
                <field Field="b" Type="varchar(128)" Null="YES" Key="" Extra="" />
 
7
                <options Name="t1" Engine="MyISAM" Version="10" Row_format="Dynamic" Rows="3" Avg_row_length="20" Data_length="60" Max_data_length="281474976710655" Index_length="1024" Data_free="0" Create_time="2007-02-09 09:08:36" Update_time="2007-02-09 09:08:54" Collation="latin1_swedish_ci" Create_options="" Comment="" />
 
8
        </table_structure>
 
9
        <table_data name="t1">
 
10
        <row>
 
11
                <field name="a">1</field>
 
12
                <field name="b">b1</field>
 
13
        </row>
 
14
        <row>
 
15
                <field name="a">2</field>
 
16
                <field name="b">b2</field>
 
17
        </row>
 
18
        <row>
 
19
                <field name="a">3</field>
 
20
                <field name="b">b3</field>
 
21
        </row>
 
22
        <row>
 
23
                <field name="a">11</field>
 
24
                <field name="b">b11</field>
 
25
        </row>
 
26
        
 
27
        <!-- Check field values as tags -->
 
28
        <row>
 
29
                <a>111</a>
 
30
                <b>b111</b>
 
31
        </row>
 
32
 
 
33
        <row>
 
34
                <a>112</a>
 
35
                <b>b112 &amp; &lt; &gt; &quot; &apos; &unknown; -- check entities</b>
 
36
        </row>
 
37
 
 
38
 
 
39
        <!-- Check field values in attributes -->
 
40
        <row a=212 b="b212"></row>
 
41
 
 
42
        <!-- Bug#29752 Linefeeds break LOAD XML INFILE -->
 
43
        <!-- Check varios combinations of TAB and NL   -->
 
44
 
 
45
        <row
 
46
        a=213 b="b213">
 
47
        </row>
 
48
 
 
49
        <row
 
50
        a=214
 
51
        b="b214">
 
52
        </row>
 
53
 
 
54
        <row a=215      b="b215"></row>
 
55
 
 
56
        <row a=216 b="&bb
 
57
b;"></row>
 
58
 
 
59
        <!-- End of bug#29752 -->
 
60
 
 
61
        </table_data>
 
62
</database>
 
63
</mysqldump>
 
64