#
#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;