summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorunknown <ram@gw.mysql.r18.ru>2003-10-31 11:29:57 +0400
committerunknown <ram@gw.mysql.r18.ru>2003-10-31 11:29:57 +0400
commitff182082576e4c23fe5049597b2d5ae9b4158526 (patch)
tree60093c094624f6fc0788adf272fec0c2fcb02193
parent60d385b1d4be16b0ef2624e9a906ac01b2b6f590 (diff)
downloadmariadb-git-ff182082576e4c23fe5049597b2d5ae9b4158526.tar.gz
new mysqldump -X test (bug #1707)
-rw-r--r--mysql-test/r/mysqldump.result25
-rw-r--r--mysql-test/t/mysqldump.test11
2 files changed, 33 insertions, 3 deletions
diff --git a/mysql-test/r/mysqldump.result b/mysql-test/r/mysqldump.result
index 085cf2788f9..4f44ec343d6 100644
--- a/mysql-test/r/mysqldump.result
+++ b/mysql-test/r/mysqldump.result
@@ -4,14 +4,35 @@ INSERT INTO t1 VALUES (1), (2);
<?xml version="1.0"?>
<mysqldump>
<database name="test">
- <table name="t1">
+ <table_structure name="t1">
+ <field Field="a" Type="int(11)" Null="YES" />
+ </table_structure>
+ <table_data name="t1">
<row>
<field name="a">1</field>
</row>
<row>
<field name="a">2</field>
</row>
- </table>
+ </table_data>
</database>
</mysqldump>
DROP TABLE t1;
+CREATE TABLE `t"1` (`a"b"c"` char(2));
+INSERT INTO `t"1` VALUES ("\"1"), ("2\"");
+<?xml version="1.0"?>
+<mysqldump>
+<database name="test">
+ <table_structure name="t&quot;1">
+ <field Field="a&quot;b&quot;c&quot;" Type="char(2)" Null="YES" />
+ </table_structure>
+ <table_data name="t&quot;1">
+ <row>
+ <field name="a&quot;b&quot;c&quot;">&quot;1</field>
+ </row>
+ <row>
+ <field name="a&quot;b&quot;c&quot;">2&quot;</field>
+ </row>
+ </table_data>
+</database>
+</mysqldump>
diff --git a/mysql-test/t/mysqldump.test b/mysql-test/t/mysqldump.test
index c98fd4050f2..7a375b05fec 100644
--- a/mysql-test/t/mysqldump.test
+++ b/mysql-test/t/mysqldump.test
@@ -6,5 +6,14 @@ DROP TABLE IF EXISTS t1;
CREATE TABLE t1(a int);
INSERT INTO t1 VALUES (1), (2);
---exec $MYSQL_DUMP -X test t1
+--exec $MYSQL_DUMP --skip-all -X test t1
DROP TABLE t1;
+
+#
+# Bug #1707
+#
+
+CREATE TABLE `t"1` (`a"b"c"` char(2));
+INSERT INTO `t"1` VALUES ("\"1"), ("2\"");
+--exec $MYSQL_DUMP --skip-all -X test
+DROP TABLE `t"1`;