summaryrefslogtreecommitdiff
path: root/mysql-test/main/mysqldump-header.result
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2022-10-26 14:54:53 +0200
committerSergei Golubchik <serg@mariadb.org>2022-10-26 15:30:35 +0200
commit768a10d02aac5955f154c6d5be30fedbae0f3b3c (patch)
treea6d33c6290bc74dcdc3b521dbab8d7e1be90ecc2 /mysql-test/main/mysqldump-header.result
parentad7631bdce1c25afa8de32d2062cb27bfaf539da (diff)
downloadmariadb-git-768a10d02aac5955f154c6d5be30fedbae0f3b3c.tar.gz
MDEV-22200 maridb-dump add --header option
fix quoting
Diffstat (limited to 'mysql-test/main/mysqldump-header.result')
-rw-r--r--mysql-test/main/mysqldump-header.result13
1 files changed, 12 insertions, 1 deletions
diff --git a/mysql-test/main/mysqldump-header.result b/mysql-test/main/mysqldump-header.result
index 6b59b062f35..945791790c0 100644
--- a/mysql-test/main/mysqldump-header.result
+++ b/mysql-test/main/mysqldump-header.result
@@ -45,7 +45,18 @@ course_id name description num_years escape_çÇÁá!#%"';5 Course 1 Course Desc
# Dump header and data rows into outfile with several options above combined
#
'course_id','name','description','num_years','escape_çÇÁá!#%"\'';'5','Course 1','Course Description 1','3',\N;
-'course_id','name','description','num_years','escape_çÇÁá!#%"\'';'5','Course 1','Course Description 1','3',\N;INSERT INTO `courses` VALUES (4, 'Course 2', 'Course Description 2', 4, NULL);
+'course_id','name','description','num_years','escape_çÇÁá!#%"\'';'5','Course 1','Course Description 1','3',\N;
+#
+# --skip-quote-names
+#
+course_id name description num_years escape_çÇÁá!#%"'
+5 Course 1 Course Description 1 3 \N
+#
+# --compatible=ansi
+#
+course_id name description num_years escape_çÇÁá!#%"'
+5 Course 1 Course Description 1 3 \N
+INSERT INTO `courses` VALUES (4, 'Course 2', 'Course Description 2', 4, NULL);
INSERT INTO `courses` VALUES (3, 'Course 3', 'Course Description 3', 3, NULL);
INSERT INTO `courses` VALUES (2, 'Course 4', 'Course Description 4', 5, NULL);
INSERT INTO `courses` VALUES (1, 'Course 5', 'Course Description 5', 3, NULL);