mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-07-09 21:08:16 +02:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/mysql-test/suite/funcs_2/charset/charset_master.test
Monty 9cba6c5aa3 Updated mtr files to support different compiled in options 
This allows one to run the test suite even if any of the following
options are changed:
- character-set-server
- collation-server
- join-cache-level
- log-basename
- max-allowed-packet
- optimizer-switch
- query-cache-size and query-cache-type
- skip-name-resolve
- table-definition-cache
- table-open-cache
- Some innodb options
etc

Changes:
- Don't print out the value of system variables as one can't depend on
  them to being constants.
- Don't set global variables to 'default' as the default may not
  be the same as the test was started with if there was an additional
  option file. Instead save original value and reset it at end of test.
- Test that depends on the latin1 character set should include
  default_charset.inc or set the character set to latin1
- Test that depends on the original optimizer switch, should include
  default_optimizer_switch.inc
- Test that depends on the value of a specific system variable should
  set it in the test (like optimizer_use_condition_selectivity)
- Split subselect3.test into subselect3.test and subselect3.inc to
  make it easier to set and reset system variables.
- Added .opt files for test that required specfic options that could
  be changed by external configuration files.
- Fixed result files in rockdsb & tokudb that had not been updated for
  a while.
2019-09-01 19:17:35 +03:00

705 lines
18 KiB
Text
Raw Permalink Blame History

#################################################################################
# Author: Serge Kozlov #
# Date: 2005-09-21 #
# Purpose: used by ../t/*_charset.test #
# Require: set $engine_type= [MyISAM,InnoDB,etc] before calling #
# #
# Last modification: Matthias Leich #
# Date: 2008-07-02 #
# Purpose: Fix Bug#37160 funcs_2: The tests do not check if optional character #
# sets exist. #
# Add checking of prerequisites + minor cleanup #
#################################################################################
set @save_character_set_database= @@character_set_database;
#
#
#
# Check that all character sets needed are available
# Note(mleich):
# It is intentional that the common solution with
# "--source include/have_<character set>.inc"
# is not applied.
# - We currently do not have such a prerequisite test for every character set
# /collation needed.
# - There is also no real value in mentioning the first missing character set
# /collation within the "skip message" because it is most probably only
# one of many.
#
# Hint: 5 character_set_names per source line if possible
if (`SELECT COUNT(*) <> 36 FROM information_schema.character_sets
WHERE CHARACTER_SET_NAME IN (
'armscii8', 'ascii' , 'big5' , 'binary' , 'cp1250',
'cp1251' , 'cp1256' , 'cp1257' , 'cp850' , 'cp852' ,
'cp866' , 'cp932' , 'dec8' , 'eucjpms', 'euckr' ,
'gb2312' , 'gbk' , 'geostd8', 'greek' , 'hebrew',
'hp8' , 'keybcs2', 'koi8r' , 'koi8u' , 'latin1',
'latin2' , 'latin5' , 'latin7' , 'macce' , 'macroman',
'sjis' , 'swe7' , 'tis620' , 'ucs2' , 'ujis',
'utf8'
)`)
{
--skip Not all character sets required for this test are present
}
# Check that all collations needed are available
# Hint: 4 collation_names per source line if possible
if (`SELECT COUNT(*) <> 123 FROM information_schema.collations
WHERE collation_name IN (
'armscii8_bin', 'armscii8_general_ci', 'ascii_bin', 'ascii_general_ci',
'big5_bin', 'big5_chinese_ci', 'cp1250_bin', 'cp1250_croatian_ci',
'cp1250_czech_cs', 'cp1250_general_ci', 'cp1251_bin', 'cp1251_bulgarian_ci',
'cp1251_general_ci', 'cp1251_general_cs', 'cp1251_ukrainian_ci', 'cp1256_bin',
'cp1256_general_ci', 'cp1257_bin', 'cp1257_general_ci', 'cp1257_lithuanian_ci',
'cp850_bin', 'cp850_general_ci', 'cp852_bin', 'cp852_general_ci',
'cp866_bin', 'cp866_general_ci', 'cp932_bin', 'cp932_japanese_ci',
'dec8_bin', 'dec8_swedish_ci', 'eucjpms_bin', 'eucjpms_japanese_ci',
'euckr_bin', 'euckr_korean_ci', 'gb2312_bin', 'gb2312_chinese_ci',
'gbk_bin', 'gbk_chinese_ci', 'geostd8_bin', 'geostd8_general_ci',
'greek_bin', 'greek_general_ci', 'hebrew_bin', 'hebrew_general_ci',
'hp8_bin', 'hp8_english_ci', 'keybcs2_bin', 'keybcs2_general_ci',
'koi8r_bin', 'koi8r_general_ci', 'koi8u_bin', 'koi8u_general_ci',
'latin1_bin', 'latin1_danish_ci', 'latin1_general_ci', 'latin1_general_cs',
'latin1_german1_ci', 'latin1_german2_ci', 'latin1_spanish_ci', 'latin1_swedish_ci',
'latin2_bin', 'latin2_croatian_ci', 'latin2_czech_cs', 'latin2_general_ci',
'latin2_hungarian_ci', 'latin5_bin', 'latin5_turkish_ci', 'latin7_bin',
'latin7_estonian_cs', 'latin7_general_ci', 'latin7_general_cs', 'macce_bin',
'macce_general_ci', 'macroman_bin', 'macroman_general_ci', 'sjis_bin',
'sjis_japanese_ci', 'swe7_bin', 'swe7_swedish_ci', 'tis620_bin',
'tis620_thai_ci', 'ucs2_bin', 'ucs2_czech_ci', 'ucs2_danish_ci',
'ucs2_estonian_ci', 'ucs2_general_ci', 'ucs2_hungarian_ci', 'ucs2_icelandic_ci',
'ucs2_latvian_ci', 'ucs2_lithuanian_ci', 'ucs2_persian_ci', 'ucs2_polish_ci',
'ucs2_roman_ci', 'ucs2_romanian_ci', 'ucs2_slovak_ci', 'ucs2_slovenian_ci',
'ucs2_spanish2_ci', 'ucs2_spanish_ci', 'ucs2_swedish_ci', 'ucs2_turkish_ci',
'ucs2_unicode_ci', 'ujis_bin', 'ujis_japanese_ci', 'utf8_bin',
'utf8_czech_ci', 'utf8_danish_ci', 'utf8_estonian_ci', 'utf8_general_ci',
'utf8_hungarian_ci', 'utf8_icelandic_ci', 'utf8_latvian_ci', 'utf8_lithuanian_ci',
'utf8_persian_ci', 'utf8_polish_ci', 'utf8_roman_ci', 'utf8_romanian_ci',
'utf8_slovak_ci', 'utf8_slovenian_ci', 'utf8_spanish2_ci', 'utf8_spanish_ci',
'utf8_swedish_ci', 'utf8_turkish_ci', 'utf8_unicode_ci'
)`)
{
--skip Not all collations required for this test are present
}
################################
let $check_std_csets= 1;
let $check_ucs2_csets= 1;
let $check_utf8_csets= 1;
# Bug#32784: Timeout in test "innodb_charset": InnoDB much slower
# than other handlers
# NOTE: We turn autocommit off to improve the performance of the innodb variant
# of this test. Per Innobase's recommendation.
--disable_query_log
SET autocommit=0;
--enable_query_log
#
# Check all charsets/collation combinations
#
################################
let $check_std_csets= 1;
let $check_ucs2_csets= 1;
let $check_utf8_csets= 1;
#
# Check all charsets/collation combinations
#
if ($check_std_csets)
{
# armscii8
let $cset= armscii8;
let $coll= armscii8_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= armscii8;
let $coll= armscii8_general_ci;
--source suite/funcs_2/include/check_charset.inc
# ascii
let $cset= ascii;
let $coll= ascii_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= ascii;
let $coll= ascii_general_ci;
--source suite/funcs_2/include/check_charset.inc
# big5
let $cset= big5;
let $coll= big5_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= big5;
let $coll= big5_chinese_ci;
--source suite/funcs_2/include/check_charset.inc
# binary
let $cset= binary;
let $coll= ;
let $bin_cset= 1;
--source suite/funcs_2/include/check_charset.inc
# cp1250
let $cset= cp1250;
let $coll= cp1250_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= cp1250;
let $coll= cp1250_croatian_ci;
--source suite/funcs_2/include/check_charset.inc
let $cset= cp1250;
let $coll= cp1250_czech_cs;
--source suite/funcs_2/include/check_charset.inc
let $cset= cp1250;
let $coll= cp1250_general_ci;
--source suite/funcs_2/include/check_charset.inc
# cp1251
let $cset= cp1251;
let $coll= cp1251_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= cp1251;
let $coll= cp1251_bulgarian_ci;
--source suite/funcs_2/include/check_charset.inc
let $cset= cp1251;
let $coll= cp1251_general_ci;
--source suite/funcs_2/include/check_charset.inc
let $cset= cp1251;
let $coll= cp1251_general_cs;
--source suite/funcs_2/include/check_charset.inc
let $cset= cp1251;
let $coll= cp1251_ukrainian_ci;
--source suite/funcs_2/include/check_charset.inc
# cp1256
let $cset= cp1256;
let $coll= cp1256_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= cp1256;
let $coll= cp1256_general_ci;
--source suite/funcs_2/include/check_charset.inc
# cp1257
let $cset= cp1257;
let $coll= cp1257_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= cp1257;
let $coll= cp1257_general_ci;
--source suite/funcs_2/include/check_charset.inc
let $cset= cp1257;
let $coll= cp1257_lithuanian_ci;
--source suite/funcs_2/include/check_charset.inc
# cp850
let $cset= cp850;
let $coll= cp850_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= cp850;
let $coll= cp850_general_ci;
--source suite/funcs_2/include/check_charset.inc
# cp852
let $cset= cp852;
let $coll= cp852_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= cp852;
let $coll= cp852_general_ci;
--source suite/funcs_2/include/check_charset.inc
# cp866
let $cset= cp866;
let $coll= cp866_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= cp866;
let $coll= cp866_general_ci;
--source suite/funcs_2/include/check_charset.inc
# cp932
let $cset= cp932;
let $coll= cp932_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= cp932;
let $coll= cp932_japanese_ci;
--source suite/funcs_2/include/check_charset.inc
# dec8
let $cset= dec8;
let $coll= dec8_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= dec8;
let $coll= dec8_swedish_ci;
--source suite/funcs_2/include/check_charset.inc
# eucjpms
let $cset= eucjpms;
let $coll= eucjpms_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= eucjpms;
let $coll= eucjpms_japanese_ci;
--source suite/funcs_2/include/check_charset.inc
# euckr
let $cset= euckr;
let $coll= euckr_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= euckr;
let $coll= euckr_korean_ci;
--source suite/funcs_2/include/check_charset.inc
# gb2312
let $cset= gb2312;
let $coll= gb2312_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= gb2312;
let $coll= gb2312_chinese_ci;
--source suite/funcs_2/include/check_charset.inc
# gbk
let $cset= gbk;
let $coll= gbk_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= gbk;
let $coll= gbk_chinese_ci;
--source suite/funcs_2/include/check_charset.inc
# geostd8
let $cset= geostd8;
let $coll= geostd8_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= geostd8;
let $coll= geostd8_general_ci;
--source suite/funcs_2/include/check_charset.inc
# greek
let $cset= greek;
let $coll= greek_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= greek;
let $coll= greek_general_ci;
--source suite/funcs_2/include/check_charset.inc
# hebrew
let $cset= hebrew;
let $coll= hebrew_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= hebrew;
let $coll= hebrew_general_ci;
--source suite/funcs_2/include/check_charset.inc
# hp8
let $cset= hp8;
let $coll= hp8_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= hp8;
let $coll= hp8_english_ci;
--source suite/funcs_2/include/check_charset.inc
# keybcs2
let $cset= keybcs2;
let $coll= keybcs2_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= keybcs2;
let $coll= keybcs2_general_ci;
--source suite/funcs_2/include/check_charset.inc
# koi8r
let $cset= koi8r;
let $coll= koi8r_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= koi8r;
let $coll= koi8r_general_ci;
--source suite/funcs_2/include/check_charset.inc
# koi8u
let $cset= koi8u;
let $coll= koi8u_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= koi8u;
let $coll= koi8u_general_ci;
--source suite/funcs_2/include/check_charset.inc
# latin1
let $cset= latin1;
let $coll= latin1_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= latin1;
let $coll= latin1_danish_ci;
--source suite/funcs_2/include/check_charset.inc
let $cset= latin1;
let $coll= latin1_general_ci;
--source suite/funcs_2/include/check_charset.inc
let $cset= latin1;
let $coll= latin1_general_cs;
--source suite/funcs_2/include/check_charset.inc
let $cset= latin1;
let $coll= latin1_german1_ci;
--source suite/funcs_2/include/check_charset.inc
let $cset= latin1;
let $coll= latin1_german2_ci;
--source suite/funcs_2/include/check_charset.inc
let $cset= latin1;
let $coll= latin1_spanish_ci;
--source suite/funcs_2/include/check_charset.inc
let $cset= latin1;
let $coll= latin1_swedish_ci;
--source suite/funcs_2/include/check_charset.inc
# latin2
let $cset= latin2;
let $coll= latin2_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= latin2;
let $coll= latin2_croatian_ci;
--source suite/funcs_2/include/check_charset.inc
let $cset= latin2;
let $coll= latin2_czech_cs;
--source suite/funcs_2/include/check_charset.inc
let $cset= latin2;
let $coll= latin2_general_ci;
--source suite/funcs_2/include/check_charset.inc
let $cset= latin2;
let $coll= latin2_hungarian_ci;
--source suite/funcs_2/include/check_charset.inc
# latin5
let $cset= latin5;
let $coll= latin5_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= latin5;
let $coll= latin5_turkish_ci;
--source suite/funcs_2/include/check_charset.inc
# latin7
let $cset= latin7;
let $coll= latin7_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= latin7;
let $coll= latin7_estonian_cs;
--source suite/funcs_2/include/check_charset.inc
let $cset= latin7;
let $coll= latin7_general_ci;
--source suite/funcs_2/include/check_charset.inc
let $cset= latin7;
let $coll= latin7_general_cs;
--source suite/funcs_2/include/check_charset.inc
# macce
let $cset= macce;
let $coll= macce_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= macce;
let $coll= macce_general_ci;
--source suite/funcs_2/include/check_charset.inc
# macroman
let $cset= macroman;
let $coll= macroman_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= macroman;
let $coll= macroman_general_ci;
--source suite/funcs_2/include/check_charset.inc
# sjis
let $cset= sjis;
let $coll= sjis_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= sjis;
let $coll= sjis_japanese_ci;
--source suite/funcs_2/include/check_charset.inc
# swe7
let $cset= swe7;
let $coll= swe7_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= swe7;
let $coll= swe7_swedish_ci;
--source suite/funcs_2/include/check_charset.inc
# tis620
let $cset= tis620;
let $coll= tis620_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= tis620;
let $coll= tis620_thai_ci;
--source suite/funcs_2/include/check_charset.inc
# ujis
let $cset= ujis;
let $coll= ujis_bin;
--source suite/funcs_2/include/check_charset.inc
let $cset= ujis;
let $coll= ujis_japanese_ci;
--source suite/funcs_2/include/check_charset.inc
}
if ($check_ucs2_csets)
{
# ucs2
let $cset= ucs2;
let $coll= ucs2_bin;
--source suite/funcs_2/include/check_charset_ucs2.inc
let $cset= ucs2;
let $coll= ucs2_czech_ci;
--source suite/funcs_2/include/check_charset_ucs2.inc
let $cset= ucs2;
let $coll= ucs2_danish_ci;
--source suite/funcs_2/include/check_charset_ucs2.inc
let $cset= ucs2;
let $coll= ucs2_estonian_ci;
--source suite/funcs_2/include/check_charset_ucs2.inc
let $cset= ucs2;
let $coll= ucs2_general_ci;
--source suite/funcs_2/include/check_charset_ucs2.inc
let $cset= ucs2;
let $coll= ucs2_hungarian_ci;
--source suite/funcs_2/include/check_charset_ucs2.inc
let $cset= ucs2;
let $coll= ucs2_icelandic_ci;
--source suite/funcs_2/include/check_charset_ucs2.inc
let $cset= ucs2;
let $coll= ucs2_latvian_ci;
--source suite/funcs_2/include/check_charset_ucs2.inc
let $cset= ucs2;
let $coll= ucs2_lithuanian_ci;
--source suite/funcs_2/include/check_charset_ucs2.inc
let $cset= ucs2;
let $coll= ucs2_persian_ci;
--source suite/funcs_2/include/check_charset_ucs2.inc
let $cset= ucs2;
let $coll= ucs2_polish_ci;
--source suite/funcs_2/include/check_charset_ucs2.inc
let $cset= ucs2;
let $coll= ucs2_roman_ci;
--source suite/funcs_2/include/check_charset_ucs2.inc
let $cset= ucs2;
let $coll= ucs2_romanian_ci;
--source suite/funcs_2/include/check_charset_ucs2.inc
let $cset= ucs2;
let $coll= ucs2_slovak_ci;
--source suite/funcs_2/include/check_charset_ucs2.inc
let $cset= ucs2;
let $coll= ucs2_slovenian_ci;
--source suite/funcs_2/include/check_charset_ucs2.inc
let $cset= ucs2;
let $coll= ucs2_spanish2_ci;
--source suite/funcs_2/include/check_charset_ucs2.inc
let $cset= ucs2;
let $coll= ucs2_spanish_ci;
--source suite/funcs_2/include/check_charset_ucs2.inc
let $cset= ucs2;
let $coll= ucs2_swedish_ci;
--source suite/funcs_2/include/check_charset_ucs2.inc
let $cset= ucs2;
let $coll= ucs2_turkish_ci;
--source suite/funcs_2/include/check_charset_ucs2.inc
let $cset= ucs2;
let $coll= ucs2_unicode_ci;
--source suite/funcs_2/include/check_charset_ucs2.inc
}
if ($check_utf8_csets)
{
# utf8
let $cset= utf8;
let $coll= utf8_bin;
--source suite/funcs_2/include/check_charset_utf8.inc
let $cset= utf8;
let $coll= utf8_czech_ci;
--source suite/funcs_2/include/check_charset_utf8.inc
let $cset= utf8;
let $coll= utf8_danish_ci;
--source suite/funcs_2/include/check_charset_utf8.inc
let $cset= utf8;
let $coll= utf8_estonian_ci;
--source suite/funcs_2/include/check_charset_utf8.inc
let $cset= utf8;
let $coll= utf8_general_ci;
--source suite/funcs_2/include/check_charset_utf8.inc
let $cset= utf8;
let $coll= utf8_hungarian_ci;
--source suite/funcs_2/include/check_charset_utf8.inc
let $cset= utf8;
let $coll= utf8_icelandic_ci;
--source suite/funcs_2/include/check_charset_utf8.inc
let $cset= utf8;
let $coll= utf8_latvian_ci;
--source suite/funcs_2/include/check_charset_utf8.inc
let $cset= utf8;
let $coll= utf8_lithuanian_ci;
--source suite/funcs_2/include/check_charset_utf8.inc
let $cset= utf8;
let $coll= utf8_persian_ci;
--source suite/funcs_2/include/check_charset_utf8.inc
let $cset= utf8;
let $coll= utf8_polish_ci;
--source suite/funcs_2/include/check_charset_utf8.inc
let $cset= utf8;
let $coll= utf8_roman_ci;
--source suite/funcs_2/include/check_charset_utf8.inc
let $cset= utf8;
let $coll= utf8_romanian_ci;
--source suite/funcs_2/include/check_charset_utf8.inc
let $cset= utf8;
let $coll= utf8_slovak_ci;
--source suite/funcs_2/include/check_charset_utf8.inc
let $cset= utf8;
let $coll= utf8_slovenian_ci;
--source suite/funcs_2/include/check_charset_utf8.inc
let $cset= utf8;
let $coll= utf8_spanish2_ci;
--source suite/funcs_2/include/check_charset_utf8.inc
let $cset= utf8;
let $coll= utf8_spanish_ci;
--source suite/funcs_2/include/check_charset_utf8.inc
let $cset= utf8;
let $coll= utf8_swedish_ci;
--source suite/funcs_2/include/check_charset_utf8.inc
let $cset= utf8;
let $coll= utf8_turkish_ci;
--source suite/funcs_2/include/check_charset_utf8.inc
let $cset= utf8;
let $coll= utf8_unicode_ci;
--source suite/funcs_2/include/check_charset_utf8.inc
}
--echo # Cleanup
--disable_query_log
DROP database test;
let $tmp=`select @save_character_set_database`;
eval CREATE database test character set $tmp;
--enable_query_log
Reference in a new issue View git blame Copy permalink