1--disable_warnings 2drop table if exists con, aux, nul, lpt1, com1, `clock$`; 3--enable_warnings 4 5create table con (a int); 6drop table con; 7 8create table aux (a int); 9drop table aux; 10 11create table nul (a int); 12drop table nul; 13 14create table lpt1 (a int); 15drop table lpt1; 16 17create table com1 (a int); 18drop table com1; 19 20create table `clock$` (a int); 21drop table `clock$`; 22 23select convert(convert(',' using filename) using binary); 24 25--echo # 26--echo # MDEV-7677 my_charset_handler_filename has a wrong "ismbchar" member 27--echo # 28SET NAMES utf8; 29SELECT @a:=CONVERT('aя' USING filename) AS `@a`, BINARY @a, REVERSE(@a), HEX(@a), HEX(REVERSE(@a)); 30 31--echo # 32--echo # Beginning of 10.2 test. 33--echo # 34--echo # MDEV-25462: Assertion `m_status == DA_ERROR || m_status == DA_OK || 35--echo # m_status == DA_OK_BULK' failed in Diagnostics_area::message from 36--echo # get_schema_tables_record 37--echo # 38 39SELECT @@character_set_client, @@character_set_connection, @@character_set_results; 40SET @old_character_set_client= @@character_set_client; 41SET @old_character_set_connection= @@character_set_connection; 42SET @old_character_set_results= @@character_set_results; 43--error ER_WRONG_VALUE_FOR_VAR 44SET NAMES 'filename'; 45SELECT @@character_set_client, @@character_set_connection, @@character_set_results; 46CREATE VIEW v2 AS SELECT 1; 47SHOW TABLE STATUS; 48DROP VIEW v2; 49SET @@character_set_client= @old_character_set_client; 50SET @@character_set_connection= @old_character_set_connection; 51SET @@character_set_results= @old_character_set_results; 52 53--echo # 54--echo # End of 10.2 test 55--echo # 56 57--echo # 58--echo # MDEV-22022 Various mangled SQL statements will crash 10.3 to 10.5 debug builds 59--echo # 60 61--error ER_WRONG_VALUE_FOR_VAR 62SET CHARACTER_SET_CLIENT=17; 63--error ER_PARSE_ERROR 64SELECT doc.`Children`.0 FROM t1; 65SET NAMES latin1; 66 67--echo # End of 10.3 tests 68 69--echo # 70--echo # MDEV-22043 Special character leads to assertion in my_wc_to_printable_generic on 10.5.2 (debug) 71--echo # 72 73--error ER_WRONG_VALUE_FOR_VAR 74SET NAMES filename; 75--error ER_PARSE_ERROR 76EXECUTE IMMEDIATE _latin1 0x01; 77SET NAMES utf8; 78 79--echo # 80--echo # MDEV-23435 Functions do not convert numbers to character_set_results 81--echo # 82 83--disable_ps_protocol 84 85SET NAMES utf8, character_set_results=filename; 86 87CREATE TABLE t1 (a DATETIME(6)); 88INSERT INTO t1 VALUES ('2001-01-01 00:00:00.000000'); 89SELECT a, COALESCE(a) AS c FROM t1; 90DROP TABLE t1; 91 92CREATE TABLE t1 (a TIME(6)); 93INSERT INTO t1 VALUES ('00:00:00.000000'); 94SELECT a, COALESCE(a) AS c FROM t1; 95DROP TABLE t1; 96 97CREATE TABLE t1 (a DATE); 98INSERT INTO t1 VALUES ('2001-01-01'); 99SELECT a, COALESCE(a) AS c FROM t1; 100DROP TABLE t1; 101 102CREATE TABLE t1 (a TINYINT); 103INSERT INTO t1 VALUES (-1); 104SELECT a, COALESCE(a) AS c FROM t1; 105DROP TABLE t1; 106 107CREATE TABLE t1 (a SMALLINT); 108INSERT INTO t1 VALUES (-1); 109SELECT a, COALESCE(a) AS c FROM t1; 110DROP TABLE t1; 111 112CREATE TABLE t1 (a MEDIUMINT); 113INSERT INTO t1 VALUES (-1); 114SELECT a, COALESCE(a) AS c FROM t1; 115DROP TABLE t1; 116 117CREATE TABLE t1 (a BIGINT); 118INSERT INTO t1 VALUES (-1); 119SELECT a, COALESCE(a) AS c FROM t1; 120DROP TABLE t1; 121 122CREATE TABLE t1 (a DECIMAL(10.2)); 123INSERT INTO t1 VALUES (-1); 124SELECT a, COALESCE(a) AS c FROM t1; 125DROP TABLE t1; 126 127CREATE TABLE t1 (a FLOAT); 128INSERT INTO t1 VALUES (-1); 129SELECT a, COALESCE(a) AS c FROM t1; 130DROP TABLE t1; 131 132CREATE TABLE t1 (a DOUBLE); 133INSERT INTO t1 VALUES (-1); 134SELECT a, COALESCE(a) AS c FROM t1; 135DROP TABLE t1; 136 137SET NAMES utf8; 138 139--enable_ps_protocol 140 141--echo # End of 10.5 tests 142