16
16
CREATE TEMPORARY TABLE `T7` (`C1` char(20), INDEX(`C1`)) engine = MEMORY;
17
17
CREATE TEMPORARY TABLE `T8` (`C1` char(20), INDEX(`C1`)) engine = MEMORY;
18
18
CREATE TEMPORARY TABLE `T9` (`C1` char(20), INDEX(`C1`)) engine = MEMORY;
19
LOAD DATA INFILE '../std_data_ln/jisx0201_utf8.dat' INTO TABLE `T1`;
20
LOAD DATA INFILE '../std_data_ln/jisx0208_utf8.dat' INTO TABLE `T2`;
21
ERROR 22001: Data too long for column 'C1' at row 30
22
LOAD DATA INFILE '../std_data_ln/jisx0212_utf8.dat' INTO TABLE `T3`;
23
LOAD DATA INFILE '../std_data_ln/jisx0201_utf8.dat' INTO TABLE `T4`;
24
LOAD DATA INFILE '../std_data_ln/jisx0208_utf8.dat' INTO TABLE `T5`;
25
ERROR 22001: Data too long for column 'C1' at row 30
26
LOAD DATA INFILE '../std_data_ln/jisx0212_utf8.dat' INTO TABLE `T6`;
27
LOAD DATA INFILE '../std_data_ln/jisx0201_utf8.dat' INTO TABLE `T7`;
28
LOAD DATA INFILE '../std_data_ln/jisx0208_utf8.dat' INTO TABLE `T8`;
29
ERROR 22001: Data too long for column 'C1' at row 30
30
LOAD DATA INFILE '../std_data_ln/jisx0212_utf8.dat' INTO TABLE `T9`;
19
LOAD DATA INFILE '../../std_data_ln/jisx0201_utf8.dat' INTO TABLE `T1`;
20
LOAD DATA INFILE '../../std_data_ln/jisx0208_utf8.dat' INTO TABLE `T2`;
21
ERROR 22001: Data too long for column 'C1' at row 30
22
LOAD DATA INFILE '../../std_data_ln/jisx0212_utf8.dat' INTO TABLE `T3`;
23
LOAD DATA INFILE '../../std_data_ln/jisx0201_utf8.dat' INTO TABLE `T4`;
24
LOAD DATA INFILE '../../std_data_ln/jisx0208_utf8.dat' INTO TABLE `T5`;
25
ERROR 22001: Data too long for column 'C1' at row 30
26
LOAD DATA INFILE '../../std_data_ln/jisx0212_utf8.dat' INTO TABLE `T6`;
27
LOAD DATA INFILE '../../std_data_ln/jisx0201_utf8.dat' INTO TABLE `T7`;
28
LOAD DATA INFILE '../../std_data_ln/jisx0208_utf8.dat' INTO TABLE `T8`;
29
ERROR 22001: Data too long for column 'C1' at row 30
30
LOAD DATA INFILE '../../std_data_ln/jisx0212_utf8.dat' INTO TABLE `T9`;
31
31
SELECT * FROM `T1` WHERE `C1` = 'ーアイウエオカキクケコサシスセソ';