|
For the following MTR test case and the associated .result file, the test runs successfully on DEB based distros while it fails on RPM based distros. This needs further investigation:
mcol-4931.test:
#
|
# MCOL-4931 Make cpimport charset aware
|
#
|
|
if (!$MYSQL_TEST_ROOT){
|
skip Should be run by root to execute cpimport;
|
}
|
|
--source ../include/have_columnstore.inc
|
|
let $DATADIR=`SELECT @@datadir`;
|
|
--disable_warnings
|
DROP DATABASE IF EXISTS mcol_4931;
|
--enable_warnings
|
|
CREATE DATABASE mcol_4931;
|
USE mcol_4931;
|
|
CREATE TABLE t1 (
|
a VARCHAR(15) collate 'utf8mb4_croatian_ci',
|
b CHAR(15) collate 'utf8mb4_croatian_ci',
|
c VARCHAR(2),
|
d CHAR(2)
|
)ENGINE=columnstore default charset=utf8mb4;
|
|
CREATE TABLE t2 (
|
a VARCHAR(15) collate 'latin2_hungarian_ci',
|
b CHAR(15) collate 'latin2_hungarian_ci',
|
c VARCHAR(2),
|
d CHAR(2)
|
)ENGINE=columnstore default charset=latin2;
|
|
--exec rm -f $DATADIR/mcol4931_1.txt
|
--exec rm -f $DATADIR/mcol4931_2.txt
|
--exec echo "\"König-\\\\\\\\n\\\\\\\\n-Straße\",\"König-\\\\\\\\n\\\\\\\\n-Straße\",\"König-\\\\\\\\n\\\\\\\\n-Straße\",\"König-\\\\\\\\n\\\\\\\\n-Straße\"" > $DATADIR/mcol4931_1.txt
|
--exec echo "\"abcdefghijklmnopq\",\"abcdefghijklmnopq\",\"abcdefghijklmnopq\",\"abcdefghijklmnopq\"" > $DATADIR/mcol4931_2.txt
|
--replace_result $DATADIR DATADIR
|
--eval LOAD DATA INFILE "$DATADIR/mcol4931_1.txt" IGNORE INTO TABLE t1 charset utf8mb4 FIELDS TERMINATED BY "," ENCLOSED BY '"';
|
--replace_result $DATADIR DATADIR
|
--eval LOAD DATA INFILE "$DATADIR/mcol4931_2.txt" IGNORE INTO TABLE t2 charset latin2 FIELDS TERMINATED BY "," ENCLOSED BY '"';
|
|
--disable_result_log
|
--exec $MCS_CPIMPORT -s',' -E'"' mcol_4931 t1 '$DATADIR/mcol4931_1.txt';
|
--exec $MCS_CPIMPORT -s',' -E'"' mcol_4931 t2 '$DATADIR/mcol4931_2.txt';
|
--enable_result_log
|
|
SELECT * FROM t1;
|
SELECT CHAR_LENGTH(a), LENGTHB(a), CHAR_LENGTH(b), LENGTHB(b), CHAR_LENGTH(c), LENGTHB(c), CHAR_LENGTH(d), LENGTHB(d) FROM t1;
|
|
SELECT * FROM t2;
|
SELECT CHAR_LENGTH(a), LENGTHB(a), CHAR_LENGTH(b), LENGTHB(b), CHAR_LENGTH(c), LENGTHB(c), CHAR_LENGTH(d), LENGTHB(d) FROM t2;
|
|
# Clean UP
|
--exec rm -f $DATADIR/mcol4931_1.txt
|
--exec rm -f $DATADIR/mcol4931_2.txt
|
DROP DATABASE mcol_4931;
|
mcol-4931.result:
DROP DATABASE IF EXISTS mcol_4931;
|
CREATE DATABASE mcol_4931;
|
USE mcol_4931;
|
CREATE TABLE t1 (
|
a VARCHAR(15) collate 'utf8mb4_croatian_ci',
|
b CHAR(15) collate 'utf8mb4_croatian_ci',
|
c VARCHAR(2),
|
d CHAR(2)
|
)ENGINE=columnstore default charset=utf8mb4;
|
CREATE TABLE t2 (
|
a VARCHAR(15) collate 'latin2_hungarian_ci',
|
b CHAR(15) collate 'latin2_hungarian_ci',
|
c VARCHAR(2),
|
d CHAR(2)
|
)ENGINE=columnstore default charset=latin2;
|
LOAD DATA INFILE "DATADIR/mcol4931_1.txt" IGNORE INTO TABLE t1 charset utf8mb4 FIELDS TERMINATED BY "," ENCLOSED BY '"';;
|
Warnings:
|
Warning 1265 Data truncated for column 'a' at row 1
|
Warning 1265 Data truncated for column 'b' at row 1
|
Warning 1265 Data truncated for column 'c' at row 1
|
Warning 1265 Data truncated for column 'd' at row 1
|
LOAD DATA INFILE "DATADIR/mcol4931_2.txt" IGNORE INTO TABLE t2 charset latin2 FIELDS TERMINATED BY "," ENCLOSED BY '"';;
|
Warnings:
|
Warning 1265 Data truncated for column 'a' at row 1
|
Warning 1265 Data truncated for column 'b' at row 1
|
Warning 1265 Data truncated for column 'c' at row 1
|
Warning 1265 Data truncated for column 'd' at row 1
|
SELECT * FROM t1;
|
a b c d
|
König-\n\n-Stra König-\n\n-Stra Kö Kö
|
König-\n\n-Stra König-\n\n-Stra Kö Kö
|
SELECT CHAR_LENGTH(a), LENGTHB(a), CHAR_LENGTH(b), LENGTHB(b), CHAR_LENGTH(c), LENGTHB(c), CHAR_LENGTH(d), LENGTHB(d) FROM t1;
|
CHAR_LENGTH(a) LENGTHB(a) CHAR_LENGTH(b) LENGTHB(b) CHAR_LENGTH(c) LENGTHB(c) CHAR_LENGTH(d) LENGTHB(d)
|
15 16 15 16 2 3 2 3
|
15 16 15 16 2 3 2 3
|
SELECT * FROM t2;
|
a b c d
|
abcdefghijklmno abcdefghijklmno ab ab
|
abcdefghijklmno abcdefghijklmno ab ab
|
SELECT CHAR_LENGTH(a), LENGTHB(a), CHAR_LENGTH(b), LENGTHB(b), CHAR_LENGTH(c), LENGTHB(c), CHAR_LENGTH(d), LENGTHB(d) FROM t2;
|
CHAR_LENGTH(a) LENGTHB(a) CHAR_LENGTH(b) LENGTHB(b) CHAR_LENGTH(c) LENGTHB(c) CHAR_LENGTH(d) LENGTHB(d)
|
15 15 15 15 2 2 2 2
|
15 15 15 15 2 2 2 2
|
DROP DATABASE mcol_4931;
|
|