diff options
Diffstat (limited to 'mysql-test/main/ctype_cp932.result')
-rw-r--r-- | mysql-test/main/ctype_cp932.result | 70 |
1 files changed, 64 insertions, 6 deletions
diff --git a/mysql-test/main/ctype_cp932.result b/mysql-test/main/ctype_cp932.result index eb714e9f8d7..952130cf11c 100644 --- a/mysql-test/main/ctype_cp932.result +++ b/mysql-test/main/ctype_cp932.result @@ -40,7 +40,7 @@ SET @@character_set_results= @old_character_set_results; # MDEV-9711 NO PAD Collatons # SET character_set_connection=cp932; -SET STORAGE_ENGINE=MyISAM; +SET DEFAULT_STORAGE_ENGINE=MyISAM; # # Start of ctype_pad.inc # @@ -178,7 +178,7 @@ DROP TABLE t1; # # End of ctype_pad.inc # -SET STORAGE_ENGINE=HEAP; +SET DEFAULT_STORAGE_ENGINE=HEAP; # # Start of ctype_pad.inc # @@ -316,8 +316,8 @@ DROP TABLE t1; # # End of ctype_pad.inc # -SET STORAGE_ENGINE=Default; -SET STORAGE_ENGINE=MyISAM; +SET DEFAULT_STORAGE_ENGINE=Default; +SET DEFAULT_STORAGE_ENGINE=MyISAM; # # Start of ctype_pad.inc # @@ -455,7 +455,7 @@ DROP TABLE t1; # # End of ctype_pad.inc # -SET STORAGE_ENGINE=HEAP; +SET DEFAULT_STORAGE_ENGINE=HEAP; # # Start of ctype_pad.inc # @@ -593,7 +593,65 @@ DROP TABLE t1; # # End of ctype_pad.inc # -SET STORAGE_ENGINE=Default; +SET DEFAULT_STORAGE_ENGINE=Default; # # End of 10.2 tests # +# +# Start of 10.5 tests +# +# +# MDEV-22625 SIGSEGV in intern_find_sys_var (optimized builds) +# +SET NAMES cp932; +SET @seq=_cp932 0x81AD; +# +# SET STATEMENT (bad|good.bad|bad.good)=1 +# +EXECUTE IMMEDIATE CONCAT('SET STATEMENT ',@seq, '=1 SELECT 1'); +ERROR HY000: Invalid cp932 character string: '\x81\xAD' +EXECUTE IMMEDIATE CONCAT('SET STATEMENT ',@seq, '.a=1 SELECT 1'); +ERROR HY000: Invalid cp932 character string: '\x81\xAD' +EXECUTE IMMEDIATE CONCAT('SET STATEMENT a.',@seq, '=1 SELECT 1'); +ERROR HY000: Invalid cp932 character string: '\x81\xAD' +# +# SET SESSION (bad|good.bad|bad.good)=1 +# +EXECUTE IMMEDIATE CONCAT('SET SESSION ',@seq, '=1 SELECT 1'); +ERROR HY000: Invalid cp932 character string: '\x81\xAD' +EXECUTE IMMEDIATE CONCAT('SET SESSION ',@seq, '.a=1 SELECT 1'); +ERROR HY000: Invalid cp932 character string: '\x81\xAD' +EXECUTE IMMEDIATE CONCAT('SET SESSION a.',@seq, '=1 SELECT 1'); +ERROR HY000: Invalid cp932 character string: '\x81\xAD' +# +# SET (bad|good.bad|bad.good)=1 +# +EXECUTE IMMEDIATE CONCAT('SET ', @seq, '=1'); +ERROR HY000: Invalid cp932 character string: '\x81\xAD' +EXECUTE IMMEDIATE CONCAT('SET ', @seq, '.a=1'); +ERROR HY000: Invalid cp932 character string: '\x81\xAD' +EXECUTE IMMEDIATE CONCAT('SET a.', @seq, '=1'); +ERROR HY000: Invalid cp932 character string: '\x81\xAD' +# +# Oracle SP call: BEGIN (bad|good.bad|bad.good)(params); END +# +SET sql_mode=ORACLE; +EXECUTE IMMEDIATE CONCAT('BEGIN ',@seq, '(1); END;'); +ERROR HY000: Invalid cp932 character string: '\x81\xAD' +EXECUTE IMMEDIATE CONCAT('BEGIN ',@seq, '.a(1); END;'); +ERROR HY000: Invalid cp932 character string: '\x81\xAD' +EXECUTE IMMEDIATE CONCAT('BEGIN a.',@seq, '(1); END;'); +ERROR HY000: Invalid cp932 character string: '\x81\xAD' +# +# Oracle assignment: (bad|good.bad|bad.good):= value +# +EXECUTE IMMEDIATE CONCAT(@seq, ':=1'); +ERROR HY000: Invalid cp932 character string: '\x81\xAD' +EXECUTE IMMEDIATE CONCAT(@seq, '.a:=1'); +ERROR HY000: Invalid cp932 character string: '\x81\xAD' +EXECUTE IMMEDIATE CONCAT('a.', @seq, ':=1'); +ERROR HY000: Invalid cp932 character string: '\x81\xAD' +SET sql_mode=DEFAULT; +# +# End of 10.5 tests +# |