diff options
author | Alexander Barkov <bar@mariadb.org> | 2016-04-07 17:09:53 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.org> | 2016-04-07 17:09:53 +0400 |
commit | d383a1681d01e99b8b321cbe49514705492d2b65 (patch) | |
tree | 1a53066a1931887a85638a3e5ba23944c9737a59 /mysql-test/r/ctype_gbk_export_import.result | |
parent | 52018344fe8b2ea81f734edc8dc900ef4dc1e079 (diff) | |
download | mariadb-git-d383a1681d01e99b8b321cbe49514705492d2b65.tar.gz |
Adding a test for "mysqldump -Tdir dbname tabname" followed by
"LOAD DATA INFILE" with various command line and CHARACTER SET
clause options.
Diffstat (limited to 'mysql-test/r/ctype_gbk_export_import.result')
-rw-r--r-- | mysql-test/r/ctype_gbk_export_import.result | 195 |
1 files changed, 195 insertions, 0 deletions
diff --git a/mysql-test/r/ctype_gbk_export_import.result b/mysql-test/r/ctype_gbk_export_import.result index 5e148c7294b..12f50eff21a 100644 --- a/mysql-test/r/ctype_gbk_export_import.result +++ b/mysql-test/r/ctype_gbk_export_import.result @@ -8,6 +8,9 @@ t1 CREATE TABLE `t1` ( `a` text, `b` blob ) ENGINE=MyISAM DEFAULT CHARSET=gbk +# +# Dump using SELECT INTO OUTFILE +# Locale: zh_CN.gbk OUTFILE: --default-character-set=auto @@ -575,5 +578,197 @@ INFILE: --default-character-set=utf8 CHARACTER SET utf8 file E9A0AB-3F5C5C a EE5C b 3F5C BAD-BLOB +# +# Dump using mysqldump -Tdir +# + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=binary +INFILE: --default-character-set=auto +file EE5C-EE5C5C +a EE5C +b EE5C0A BAD-BLOB + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=binary +INFILE: --default-character-set=auto CHARACTER SET gbk +file EE5C-EE5C5C +a EE5C +b EE5C0A BAD-BLOB + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=binary +INFILE: --default-character-set=auto CHARACTER SET utf8 +file EE5C-EE5C5C +a 3F5C BAD-TEXT +b EE5C0A BAD-BLOB + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=binary +INFILE: --default-character-set=gbk +file EE5C-EE5C5C +a EE5C +b EE5C0A BAD-BLOB + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=binary +INFILE: --default-character-set=gbk CHARACTER SET gbk +file EE5C-EE5C5C +a EE5C +b EE5C0A BAD-BLOB + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=binary +INFILE: --default-character-set=gbk CHARACTER SET utf8 +file EE5C-EE5C5C +a 3F5C BAD-TEXT +b EE5C0A BAD-BLOB + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=binary +INFILE: --default-character-set=utf8 +file EE5C-EE5C5C +a EE5C +b EE5C0A BAD-BLOB + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=binary +INFILE: --default-character-set=utf8 CHARACTER SET gbk +file EE5C-EE5C5C +a EE5C +b EE5C0A BAD-BLOB + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=binary +INFILE: --default-character-set=utf8 CHARACTER SET utf8 +file EE5C-EE5C5C +a 3F5C BAD-TEXT +b EE5C0A BAD-BLOB + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=gbk +INFILE: --default-character-set=auto +file EE5C-EE5C +a EE5C +b EE5C + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=gbk +INFILE: --default-character-set=auto CHARACTER SET gbk +file EE5C-EE5C +a EE5C +b EE5C + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=gbk +INFILE: --default-character-set=auto CHARACTER SET utf8 +file EE5C-EE5C +a 3F5C BAD-TEXT +b EE5C + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=gbk +INFILE: --default-character-set=gbk +file EE5C-EE5C +a EE5C +b EE5C + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=gbk +INFILE: --default-character-set=gbk CHARACTER SET gbk +file EE5C-EE5C +a EE5C +b EE5C + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=gbk +INFILE: --default-character-set=gbk CHARACTER SET utf8 +file EE5C-EE5C +a 3F5C BAD-TEXT +b EE5C + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=gbk +INFILE: --default-character-set=utf8 +file EE5C-EE5C +a EE5C +b EE5C + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=gbk +INFILE: --default-character-set=utf8 CHARACTER SET gbk +file EE5C-EE5C +a EE5C +b EE5C + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=gbk +INFILE: --default-character-set=utf8 CHARACTER SET utf8 +file EE5C-EE5C +a 3F5C BAD-TEXT +b EE5C + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=utf8 +INFILE: --default-character-set=auto +file E9A0AB-3F5C5C +a E9A03F BAD-TEXT +b 3F5C BAD-BLOB + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=utf8 +INFILE: --default-character-set=auto CHARACTER SET gbk +file E9A0AB-3F5C5C +a E9A03F BAD-TEXT +b 3F5C BAD-BLOB + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=utf8 +INFILE: --default-character-set=auto CHARACTER SET utf8 +file E9A0AB-3F5C5C +a EE5C +b 3F5C BAD-BLOB + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=utf8 +INFILE: --default-character-set=gbk +file E9A0AB-3F5C5C +a E9A03F BAD-TEXT +b 3F5C BAD-BLOB + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=utf8 +INFILE: --default-character-set=gbk CHARACTER SET gbk +file E9A0AB-3F5C5C +a E9A03F BAD-TEXT +b 3F5C BAD-BLOB + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=utf8 +INFILE: --default-character-set=gbk CHARACTER SET utf8 +file E9A0AB-3F5C5C +a EE5C +b 3F5C BAD-BLOB + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=utf8 +INFILE: --default-character-set=utf8 +file E9A0AB-3F5C5C +a E9A03F BAD-TEXT +b 3F5C BAD-BLOB + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=utf8 +INFILE: --default-character-set=utf8 CHARACTER SET gbk +file E9A0AB-3F5C5C +a E9A03F BAD-TEXT +b 3F5C BAD-BLOB + +Locale: zh_CN.gbk +OUTFILE: --default-character-set=utf8 +INFILE: --default-character-set=utf8 CHARACTER SET utf8 +file E9A0AB-3F5C5C +a EE5C +b 3F5C BAD-BLOB DROP DATABASE gbk; USE test; |