141 lines
5.2 KiB
Plaintext
141 lines
5.2 KiB
Plaintext
#
|
|
#Bug#21958734: INNODB: FAILING ASSERTION: *MBMAXLEN < 5 IN
|
|
# FILE HA_INNODB.CC LINE 1803
|
|
#
|
|
SHOW CHARACTER SET LIKE '%filename%';
|
|
Charset Description Default collation Maxlen
|
|
SHOW COLLATION LIKE '%filename%';
|
|
Collation Charset Id Default Compiled Sortlen Pad_attribute
|
|
SELECT _filename'abcd';
|
|
ERROR 42S22: Unknown column '_filename' in 'field list'
|
|
SELECT CONVERT(_latin1'abcd' USING filename);
|
|
ERROR 42000: Unknown character set: 'filename'
|
|
SELECT CAST(_latin1'abcd' AS CHAR CHARACTER SET filename);
|
|
ERROR 42000: Unknown character set: 'filename'
|
|
SET NAMES 'filename';
|
|
ERROR 42000: Unknown character set: 'filename'
|
|
SET NAMES 'utf8';
|
|
Warnings:
|
|
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
|
|
SET CHARACTER_SET_CLIENT=17;
|
|
ERROR 42000: Unknown character set: '17'
|
|
SET CHARACTER_SET_CLIENT=33;
|
|
Warnings:
|
|
Warning 1287 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead
|
|
DROP DATABASE IF EXISTS db21958734;
|
|
CREATE DATABASE db21958734 CHARACTER SET filename;
|
|
ERROR 42000: Unknown character set: 'filename'
|
|
CREATE DATABASE db21958734 COLLATE filename;
|
|
ERROR HY000: Unknown collation: 'filename'
|
|
CREATE DATABASE db21958734 CHARACTER SET utf8;
|
|
Warnings:
|
|
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
|
|
ALTER DATABASE db21958734 CHARACTER SET filename;
|
|
ERROR 42000: Unknown character set: 'filename'
|
|
ALTER DATABASE db21958734 COLLATE filename;
|
|
ERROR HY000: Unknown collation: 'filename'
|
|
ALTER DATABASE db21958734 CHARACTER SET latin1;
|
|
USE db21958734;
|
|
CREATE TABLE t1(a VARCHAR(10)) CHARACTER SET filename;
|
|
ERROR 42000: Unknown character set: 'filename'
|
|
CREATE TABLE t1(a VARCHAR(10)) COLLATE filename;
|
|
ERROR HY000: Unknown collation: 'filename'
|
|
CREATE TABLE t1(a VARCHAR(10) CHARACTER SET filename);
|
|
ERROR 42000: Unknown character set: 'filename'
|
|
CREATE TABLE t1(a VARCHAR(10) COLLATE filename);
|
|
ERROR HY000: Unknown collation: 'filename'
|
|
CREATE TABLE t1(a VARCHAR(10) CHARACTER SET utf8) CHARACTER SET latin1;
|
|
Warnings:
|
|
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
|
|
ALTER TABLE t1 CHARACTER SET filename;
|
|
ERROR 42000: Unknown character set: 'filename'
|
|
ALTER TABLE t1 COLLATE filename;
|
|
ERROR HY000: Unknown collation: 'filename'
|
|
ALTER TABLE t1 CHARACTER SET gbk;
|
|
ALTER TABLE t1 MODIFY a VARCHAR(10) CHARACTER SET filename;
|
|
ERROR 42000: Unknown character set: 'filename'
|
|
ALTER TABLE t1 MODIFY a VARCHAR(10) COLLATE filename;
|
|
ERROR HY000: Unknown collation: 'filename'
|
|
ALTER TABLE t1 MODIFY a VARCHAR(10) CHARACTER SET cp932;
|
|
DROP DATABASE db21958734;
|
|
#
|
|
# Bug#29110613: UNICODE STRING INCORRECTLY MARKED AS INVALID
|
|
#
|
|
USE test;
|
|
SET NAMES utf8mb4;
|
|
SELECT 'x' AS '🐬';
|
|
ERROR HY000: Cannot convert string '\xF0\x9F\x90\xAC' from utf8mb4 to utf8
|
|
SELECT '🐬';
|
|
?
|
|
🐬
|
|
CREATE TABLE 🐬(a INT);
|
|
Warnings:
|
|
Warning 1300 Cannot convert string '\xF0\x9F\x90\xAC' from utf8mb4 to utf8
|
|
CREATE TABLE t1(🐬 INT);
|
|
Warnings:
|
|
Warning 1300 Cannot convert string '\xF0\x9F\x90\xAC' from utf8mb4 to utf8
|
|
CREATE TABLE t2(a INT COMMENT "🐬");
|
|
Warnings:
|
|
Warning 1300 Cannot convert string '\xF0\x9F\x90\xAC' from utf8mb4 to utf8
|
|
CREATE TABLE t3(a INT);
|
|
CREATE VIEW v1 AS SELECT 'x' AS'🐬';
|
|
ERROR HY000: Cannot convert string '\xF0\x9F\x90\xAC' from utf8mb4 to utf8
|
|
DROP TABLE 🐬;
|
|
Warnings:
|
|
Warning 1300 Cannot convert string '\xF0\x9F\x90\xAC' from utf8mb4 to utf8
|
|
DROP TABLE t1, t2, t3;
|
|
PREPARE stmt FROM "SELECT 'x' AS '🐬'";
|
|
EXECUTE stmt;
|
|
?
|
|
x
|
|
SET NAMES utf8mb3;
|
|
Warnings:
|
|
Warning 1287 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead
|
|
SELECT 'x' AS '🐬';
|
|
🐬
|
|
x
|
|
SELECT '🐬';
|
|
🐬
|
|
🐬
|
|
Warnings:
|
|
Warning 1300 Invalid utf8 character string: 'F09F90'
|
|
CREATE TABLE 🐬(a INT);
|
|
ERROR HY000: Invalid utf8 character string: '\xF0\x9F\x90\xAC'
|
|
CREATE TABLE t1(🐬 INT);
|
|
ERROR HY000: Invalid utf8 character string: '\xF0\x9F\x90\xAC'
|
|
CREATE TABLE t2(a INT COMMENT "🐬");
|
|
ERROR HY000: Invalid utf8 character string: 'F09F90'
|
|
CREATE TABLE t3(a INT);
|
|
CREATE VIEW v1 AS SELECT 'x' AS'🐬';
|
|
ERROR HY000: Invalid utf8 character string: 'F09F90'
|
|
DROP TABLE t3;
|
|
PREPARE stmt FROM "SELECT 'x' AS '🐬'";
|
|
EXECUTE stmt;
|
|
🐬
|
|
x
|
|
SET NAMES default;
|
|
#
|
|
# Bug#29909573 SHOW CREATE TABLE OUTPUT CAN'T BE EXECUTED
|
|
# The following CREATE TABLE would fail without fix.
|
|
#
|
|
CREATE TABLE t1 (f1 CHAR(20) COLLATE binary);
|
|
SHOW CREATE TABLE t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
`f1` binary(20) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1 (f1 ENUM('a') COLLATE binary);
|
|
SHOW CREATE TABLE t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
`f1` enum('a') CHARACTER SET binary COLLATE binary DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1 (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`etype` enum('a','b','c') CHARACTER SET binary COLLATE binary DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
DROP TABLE t1;
|