diff options
| author | unknown <ram@gw.mysql.r18.ru> | 2003-11-03 16:49:39 +0400 |
|---|---|---|
| committer | unknown <ram@gw.mysql.r18.ru> | 2003-11-03 16:49:39 +0400 |
| commit | 08e626916cdb9cc92991cb1c45b0901eee5a523a (patch) | |
| tree | 6b7653e83052d33bf4abff22828fbc04fcc1f916 /mysql-test/r | |
| parent | 6d9ad5db3a9dd558ae136717acfc884683a33975 (diff) | |
| download | mariadb-git-08e626916cdb9cc92991cb1c45b0901eee5a523a.tar.gz | |
WL #1279: Add table description to xml dump
changes after montys review
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/mysqldump.result | 29 |
1 files changed, 27 insertions, 2 deletions
diff --git a/mysql-test/r/mysqldump.result b/mysql-test/r/mysqldump.result index fa9658c0202..27c2f8d6304 100644 --- a/mysql-test/r/mysqldump.result +++ b/mysql-test/r/mysqldump.result @@ -5,7 +5,7 @@ INSERT INTO t1 VALUES (1), (2); <mysqldump> <database name="test"> <table_structure name="t1"> - <field Field="a" Type="int(11)" Null="YES" /> + <field Field="a" Type="int(11)" Null="YES" Key="" Extra="" /> </table_structure> <table_data name="t1"> <row> @@ -18,13 +18,38 @@ INSERT INTO t1 VALUES (1), (2); </database> </mysqldump> DROP TABLE t1; +CREATE TABLE t1(a int, b text, c varchar(3)); +INSERT INTO t1 VALUES (1, "test", "tes"), (2, "TEST", "TES"); +<?xml version="1.0"?> +<mysqldump> +<database name="test"> + <table_structure name="t1"> + <field Field="a" Type="int(11)" Null="YES" Key="" Extra="" /> + <field Field="b" Type="text" Null="YES" Key="" Extra="" /> + <field Field="c" Type="char(3)" Null="YES" Key="" Extra="" /> + </table_structure> + <table_data name="t1"> + <row> + <field name="a">1</field> + <field name="b">test</field> + <field name="c">tes</field> + </row> + <row> + <field name="a">2</field> + <field name="b">TEST</field> + <field name="c">TES</field> + </row> + </table_data> +</database> +</mysqldump> +DROP TABLE t1; CREATE TABLE `"t"1` (`a"b"` char(2)); INSERT INTO `"t"1` VALUES ("1\""), ("\"2"); <?xml version="1.0"?> <mysqldump> <database name="test"> <table_structure name=""t"1"> - <field Field="a"b"" Type="char(2)" Null="YES" /> + <field Field="a"b"" Type="char(2)" Null="YES" Key="" Extra="" /> </table_structure> <table_data name=""t"1"> <row> |