441 lines
18 KiB
Plaintext
441 lines
18 KiB
Plaintext
============================================================
|
|
# Test with latin1 and latin1_bin on CHAR(20) for PRIMARY KEY(c1)
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 CHAR(20))CHARSET latin1 COLLATE latin1_bin;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1);
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with latin1 and latin1_bin on VARCHAR(60) for PRIMARY KEY(c1)
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 VARCHAR(60))CHARSET latin1 COLLATE latin1_bin;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1);
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with latin1 and latin1_bin on TEXT for PRIMARY KEY(c1(10))
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 TEXT)CHARSET latin1 COLLATE latin1_bin;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1(10));
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with latin1 and latin1_bin on BLOB for PRIMARY KEY(c1(10))
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 BLOB)CHARSET latin1 COLLATE latin1_bin;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1(10));
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with gbk and gbk_chinese_ci on CHAR(20) for PRIMARY KEY(c1)
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 CHAR(20))CHARSET gbk COLLATE gbk_chinese_ci;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1);
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with gbk and gbk_chinese_ci on VARCHAR(60) for PRIMARY KEY(c1)
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 VARCHAR(60))CHARSET gbk COLLATE gbk_chinese_ci;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1);
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with gbk and gbk_chinese_ci on TEXT for PRIMARY KEY(c1(10))
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 TEXT)CHARSET gbk COLLATE gbk_chinese_ci;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1(10));
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with gbk and gbk_chinese_ci on BLOB for PRIMARY KEY(c1(10))
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 BLOB)CHARSET gbk COLLATE gbk_chinese_ci;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1(10));
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with gbk and gbk_bin on CHAR(20) for PRIMARY KEY(c1)
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 CHAR(20))CHARSET gbk COLLATE gbk_bin;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1);
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with gbk and gbk_bin on VARCHAR(60) for PRIMARY KEY(c1)
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 VARCHAR(60))CHARSET gbk COLLATE gbk_bin;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1);
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with gbk and gbk_bin on TEXT for PRIMARY KEY(c1(10))
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 TEXT)CHARSET gbk COLLATE gbk_bin;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1(10));
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with gbk and gbk_bin on BLOB for PRIMARY KEY(c1(10))
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 BLOB)CHARSET gbk COLLATE gbk_bin;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1(10));
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb3 and utf8mb3_general_ci on CHAR(20) for PRIMARY KEY(c1)
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 CHAR(20))CHARSET utf8mb3 COLLATE utf8mb3_general_ci;
|
|
Warnings:
|
|
Warning 1287 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead
|
|
Warning 3778 'utf8_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1);
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb3 and utf8mb3_general_ci on VARCHAR(60) for PRIMARY KEY(c1)
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 VARCHAR(60))CHARSET utf8mb3 COLLATE utf8mb3_general_ci;
|
|
Warnings:
|
|
Warning 1287 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead
|
|
Warning 3778 'utf8_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1);
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb3 and utf8mb3_general_ci on TEXT for PRIMARY KEY(c1(10))
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 TEXT)CHARSET utf8mb3 COLLATE utf8mb3_general_ci;
|
|
Warnings:
|
|
Warning 1287 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead
|
|
Warning 3778 'utf8_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1(10));
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb3 and utf8mb3_general_ci on BLOB for PRIMARY KEY(c1(10))
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 BLOB)CHARSET utf8mb3 COLLATE utf8mb3_general_ci;
|
|
Warnings:
|
|
Warning 1287 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead
|
|
Warning 3778 'utf8_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1(10));
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb3 and utf8mb3_bin on CHAR(20) for PRIMARY KEY(c1)
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 CHAR(20))CHARSET utf8mb3 COLLATE utf8mb3_bin;
|
|
Warnings:
|
|
Warning 1287 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead
|
|
Warning 3778 'utf8_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1);
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb3 and utf8mb3_bin on VARCHAR(60) for PRIMARY KEY(c1)
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 VARCHAR(60))CHARSET utf8mb3 COLLATE utf8mb3_bin;
|
|
Warnings:
|
|
Warning 1287 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead
|
|
Warning 3778 'utf8_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1);
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb3 and utf8mb3_bin on TEXT for PRIMARY KEY(c1(10))
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 TEXT)CHARSET utf8mb3 COLLATE utf8mb3_bin;
|
|
Warnings:
|
|
Warning 1287 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead
|
|
Warning 3778 'utf8_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1(10));
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb3 and utf8mb3_bin on BLOB for PRIMARY KEY(c1(10))
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 BLOB)CHARSET utf8mb3 COLLATE utf8mb3_bin;
|
|
Warnings:
|
|
Warning 1287 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead
|
|
Warning 3778 'utf8_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1(10));
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb4 and utf8mb4_0900_ai_ci on CHAR(20) for PRIMARY KEY(c1)
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 CHAR(20))CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1);
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb4 and utf8mb4_0900_ai_ci on VARCHAR(60) for PRIMARY KEY(c1)
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 VARCHAR(60))CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1);
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb4 and utf8mb4_0900_ai_ci on TEXT for PRIMARY KEY(c1(10))
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 TEXT)CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1(10));
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb4 and utf8mb4_0900_ai_ci on BLOB for PRIMARY KEY(c1(10))
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 BLOB)CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1(10));
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb4 and utf8mb4_general_ci on CHAR(20) for PRIMARY KEY(c1)
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 CHAR(20))CHARSET utf8mb4 COLLATE utf8mb4_general_ci;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1);
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb4 and utf8mb4_general_ci on VARCHAR(60) for PRIMARY KEY(c1)
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 VARCHAR(60))CHARSET utf8mb4 COLLATE utf8mb4_general_ci;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1);
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb4 and utf8mb4_general_ci on TEXT for PRIMARY KEY(c1(10))
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 TEXT)CHARSET utf8mb4 COLLATE utf8mb4_general_ci;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1(10));
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb4 and utf8mb4_general_ci on BLOB for PRIMARY KEY(c1(10))
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 BLOB)CHARSET utf8mb4 COLLATE utf8mb4_general_ci;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1(10));
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb4 and utf8mb4_bin on CHAR(20) for PRIMARY KEY(c1)
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 CHAR(20))CHARSET utf8mb4 COLLATE utf8mb4_bin;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1);
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb4 and utf8mb4_bin on VARCHAR(60) for PRIMARY KEY(c1)
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 VARCHAR(60))CHARSET utf8mb4 COLLATE utf8mb4_bin;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1);
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb4 and utf8mb4_bin on TEXT for PRIMARY KEY(c1(10))
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 TEXT)CHARSET utf8mb4 COLLATE utf8mb4_bin;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1(10));
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
============================================================
|
|
# Test with utf8mb4 and utf8mb4_bin on BLOB for PRIMARY KEY(c1(10))
|
|
============================================================
|
|
CREATE TABLE t1(id INT, c1 BLOB)CHARSET utf8mb4 COLLATE utf8mb4_bin;
|
|
INSERT INTO t1 VALUES(1, '1111'), (2, NULL);
|
|
ALTER TABLE t1 ADD PRIMARY KEY(c1(10));
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'c1' at row 2
|
|
ALTER TABLE t1 ADD INDEX(id);
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|