131 lines
3.7 KiB
Text
131 lines
3.7 KiB
Text
## This file contains BINARY DATA.
|
|
## EDIT WITH CARE USING AN APPROPRIATE TOOL.
|
|
|
|
--echo #
|
|
--echo # Bug#33148961 FAILURE TO UPGRADE FROM 5.7, INVALID utf8mb3 CHARACTER STRING
|
|
--echo #
|
|
--echo # Test for invalid comment strings when creating table, field, index,
|
|
--echo # partition, subpartition, tablespace, procedure, function, event.
|
|
--echo #
|
|
|
|
# Set the client charset equal to the system charset. This is done to avoid the
|
|
# conversion of string literals by the parser when the charset differs.
|
|
SET NAMES utf8mb3;
|
|
|
|
# To allow testing of invalid binary data in the comment strings
|
|
--character_set binary
|
|
|
|
--echo
|
|
--echo # Test CREATE statements with invalid comments.
|
|
|
|
--echo
|
|
--error ER_COMMENT_CONTAINS_INVALID_STRING
|
|
CREATE TABLE t1 (a int) COMMENT 'tab🐬';
|
|
|
|
--echo
|
|
--error ER_COMMENT_CONTAINS_INVALID_STRING
|
|
CREATE TABLE t2 (a int COMMENT 'col🐬');
|
|
|
|
--echo
|
|
--error ER_COMMENT_CONTAINS_INVALID_STRING
|
|
CREATE TABLE t3 (a int, INDEX idx1(a) COMMENT 'idx🐬');
|
|
|
|
--echo
|
|
--error ER_COMMENT_CONTAINS_INVALID_STRING
|
|
CREATE TABLE t4 (a int) PARTITION BY RANGE (a) (PARTITION p1 VALUES LESS THAN (0) COMMENT 'part🐬');
|
|
|
|
--echo
|
|
--error ER_COMMENT_CONTAINS_INVALID_STRING
|
|
CREATE TABLE t5 (a int) PARTITION BY RANGE (a) SUBPARTITION BY HASH(a) SUBPARTITIONS 1 (PARTITION p1 VALUES LESS THAN (0)(SUBPARTITION sp1 COMMENT 'subpart🐬'));
|
|
|
|
--echo
|
|
--error ER_DEFINITION_CONTAINS_INVALID_STRING
|
|
CREATE VIEW v1 AS SELECT 'view🐬';
|
|
|
|
--echo
|
|
--error ER_COMMENT_CONTAINS_INVALID_STRING
|
|
CREATE PROCEDURE sp1() COMMENT 'proc🐬' BEGIN END;
|
|
|
|
--echo
|
|
--error ER_COMMENT_CONTAINS_INVALID_STRING
|
|
CREATE FUNCTION sf1() RETURNS INT DETERMINISTIC COMMENT 'func🐬' RETURN 0;
|
|
|
|
--echo
|
|
--error ER_COMMENT_CONTAINS_INVALID_STRING
|
|
CREATE EVENT evt1 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR COMMENT 'evt🐬' DO SELECT 0;
|
|
|
|
--echo
|
|
--echo # Test ALTER statements with invalid comments.
|
|
|
|
--echo
|
|
CREATE TABLE t1 (a int);
|
|
|
|
--echo
|
|
--error ER_COMMENT_CONTAINS_INVALID_STRING
|
|
ALTER TABLE t1 COMMENT 'tab🐬';
|
|
|
|
--echo
|
|
--error ER_COMMENT_CONTAINS_INVALID_STRING
|
|
ALTER TABLE t1 MODIFY a int COMMENT 'col🐬';
|
|
|
|
--echo
|
|
--error ER_COMMENT_CONTAINS_INVALID_STRING
|
|
ALTER TABLE t1 ADD b int COMMENT 'col🐬';
|
|
|
|
--echo
|
|
--error ER_COMMENT_CONTAINS_INVALID_STRING
|
|
ALTER TABLE t1 ADD INDEX idx1(a) COMMENT 'idx🐬';
|
|
|
|
--echo
|
|
--error ER_COMMENT_CONTAINS_INVALID_STRING
|
|
ALTER TABLE t1 PARTITION BY RANGE (a) (PARTITION p1 VALUES LESS THAN (0) COMMENT 'part🐬');
|
|
|
|
--echo
|
|
--error ER_COMMENT_CONTAINS_INVALID_STRING
|
|
ALTER TABLE t1 PARTITION BY RANGE (a) SUBPARTITION BY HASH(a) SUBPARTITIONS 1 (PARTITION p1 VALUES LESS THAN (0)(SUBPARTITION sp1 COMMENT 'subpart🐬'));
|
|
|
|
--echo
|
|
DROP TABLE t1;
|
|
|
|
--echo
|
|
CREATE VIEW v1 AS SELECT 0;
|
|
--error ER_DEFINITION_CONTAINS_INVALID_STRING
|
|
ALTER VIEW v1 AS SELECT 'view🐬';
|
|
DROP VIEW v1;
|
|
|
|
--echo
|
|
CREATE PROCEDURE sp1() BEGIN END;
|
|
--error ER_COMMENT_CONTAINS_INVALID_STRING
|
|
ALTER PROCEDURE sp1 COMMENT 'proc🐬';
|
|
DROP PROCEDURE sp1;
|
|
|
|
--echo
|
|
CREATE FUNCTION sf1() RETURNS INT DETERMINISTIC RETURN 0;
|
|
--error ER_COMMENT_CONTAINS_INVALID_STRING
|
|
ALTER FUNCTION sf1 COMMENT 'func🐬';
|
|
DROP FUNCTION sf1;
|
|
|
|
--echo
|
|
CREATE EVENT evt1 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO SELECT 0;
|
|
--error ER_COMMENT_CONTAINS_INVALID_STRING
|
|
ALTER EVENT evt1 COMMENT 'evt🐬';
|
|
DROP EVENT evt1;
|
|
|
|
--echo
|
|
--echo # Test invalid comment on TABLESPACE
|
|
|
|
--echo
|
|
--error ER_COMMENT_CONTAINS_INVALID_STRING
|
|
CREATE TABLESPACE ts1 ADD DATAFILE 'df1.ibd' COMMENT 'ts🐬';
|
|
|
|
--echo
|
|
--echo # Test invalid characters in stored routine body definition
|
|
--error ER_DEFINITION_CONTAINS_INVALID_STRING
|
|
CREATE PROCEDURE p1() BEGIN /* 'SP body comment: 🐬' */ END;
|
|
--error ER_DEFINITION_CONTAINS_INVALID_STRING
|
|
CREATE FUNCTION f1() RETURNS INT DETERMINISTIC RETURN /* 'SF body comment: 🐬' */ 0;
|
|
|
|
--echo
|
|
--echo # Cleanup
|
|
--character_set utf8mb4
|
|
SET NAMES DEFAULT;
|