#At file:///data0/backupjul2/mysql-6.0-backup/
2650 Hema Sridharan 2008-07-08
WL#4227(Test of identifiers for character sets). The test included are test of partitions and different datatypes.
added:
mysql-test/suite/backup_charsets/
mysql-test/suite/backup_charsets/combinations
mysql-test/suite/backup_charsets/include/
mysql-test/suite/backup_charsets/include/charset.inc
mysql-test/suite/backup_charsets/include/not_have_falcon.inc
mysql-test/suite/backup_charsets/r/
mysql-test/suite/backup_charsets/r/backup_datatypes.result
mysql-test/suite/backup_charsets/r/backup_partitions.result
mysql-test/suite/backup_charsets/t/
mysql-test/suite/backup_charsets/t/backup_datatypes.test
mysql-test/suite/backup_charsets/t/backup_partitions.test
=== added directory 'mysql-test/suite/backup_charsets'
=== added file 'mysql-test/suite/backup_charsets/combinations'
--- a/mysql-test/suite/backup_charsets/combinations 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/backup_charsets/combinations 2008-07-07 22:22:55 +0000
@@ -0,0 +1,1500 @@
+[myisam big5 big5_chinese_ci]
+--default-storage-engine=myisam
+--default-character-set=big5
+--default-collation=big5_chinese_ci
+[innodb big5 big5_chinese_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=big5
+--default-collation=big5_chinese_ci
+[falcon big5 big5_chinese_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=big5
+--default-collation=big5_chinese_ci
+[myisam big5 big5_bin]
+--default-storage-engine=myisam
+--default-character-set=big5
+--default-collation=big5_bin
+[innodb big5 big5_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=big5
+--default-collation=big5_bin
+[falcon big5 big5_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=big5
+--default-collation=big5_bin
+[myisam dec8 dec8_swedish_ci]
+--default-storage-engine=myisam
+--default-character-set=dec8
+--default-collation=dec8_swedish_ci
+[innodb dec8 dec8_swedish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=dec8
+--default-collation=dec8_swedish_ci
+[falcon dec8 dec8_swedish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=dec8
+--default-collation=dec8_swedish_ci
+[myisam dec8 dec8_bin]
+--default-storage-engine=myisam
+--default-character-set=dec8
+--default-collation=dec8_bin
+[innodb dec8 dec8_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=dec8
+--default-collation=dec8_bin
+[falcon dec8 dec8_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=dec8
+--default-collation=dec8_bin
+[myisam cp850 cp850_general_ci]
+--default-storage-engine=myisam
+--default-character-set=cp850
+--default-collation=cp850_general_ci
+[innodb cp850 cp850_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp850
+--default-collation=cp850_general_ci
+[falcon cp850 cp850_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp850
+--default-collation=cp850_general_ci
+[myisam cp850 cp850_bin]
+--default-storage-engine=myisam
+--default-character-set=cp850
+--default-collation=cp850_bin
+[innodb cp850 cp850_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp850
+--default-collation=cp850_bin
+[falcon cp850 cp850_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp850
+--default-collation=cp850_bin
+[myisam hp8 hp8_english_ci]
+--default-storage-engine=myisam
+--default-character-set=hp8
+--default-collation=hp8_english_ci
+[innodb hp8 hp8_english_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=hp8
+--default-collation=hp8_english_ci
+[falcon hp8 hp8_english_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=hp8
+--default-collation=hp8_english_ci
+[myisam hp8 hp8_bin]
+--default-storage-engine=myisam
+--default-character-set=hp8
+--default-collation=hp8_bin
+[innodb hp8 hp8_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=hp8
+--default-collation=hp8_bin
+[falcon hp8 hp8_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=hp8
+--default-collation=hp8_bin
+[myisam koi8r koi8r_general_ci]
+--default-storage-engine=myisam
+--default-character-set=koi8r
+--default-collation=koi8r_general_ci
+[innodb koi8r koi8r_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=koi8r
+--default-collation=koi8r_general_ci
+[falcon koi8r koi8r_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=koi8r
+--default-collation=koi8r_general_ci
+[myisam koi8r koi8r_bin]
+--default-storage-engine=myisam
+--default-character-set=koi8r
+--default-collation=koi8r_bin
+[innodb koi8r koi8r_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=koi8r
+--default-collation=koi8r_bin
+[falcon koi8r koi8r_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=koi8r
+--default-collation=koi8r_bin
+[myisam latin1 latin1_german1_ci]
+--default-storage-engine=myisam
+--default-character-set=latin1
+--default-collation=latin1_german1_ci
+[innodb latin1 latin1_german1_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin1
+--default-collation=latin1_german1_ci
+[falcon latin1 latin1_german1_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin1
+--default-collation=latin1_german1_ci
+[myisam latin1 latin1_swedish_ci]
+--default-storage-engine=myisam
+--default-character-set=latin1
+--default-collation=latin1_swedish_ci
+[innodb latin1 latin1_swedish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin1
+--default-collation=latin1_swedish_ci
+[falcon latin1 latin1_swedish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin1
+--default-collation=latin1_swedish_ci
+[myisam latin1 latin1_danish_ci]
+--default-storage-engine=myisam
+--default-character-set=latin1
+--default-collation=latin1_danish_ci
+[innodb latin1 latin1_danish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin1
+--default-collation=latin1_danish_ci
+[falcon latin1 latin1_danish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin1
+--default-collation=latin1_danish_ci
+[myisam latin1 latin1_german2_ci]
+--default-storage-engine=myisam
+--default-character-set=latin1
+--default-collation=latin1_german2_ci
+[innodb latin1 latin1_german2_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin1
+--default-collation=latin1_german2_ci
+[falcon latin1 latin1_german2_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin1
+--default-collation=latin1_german2_ci
+[myisam latin1 latin1_bin]
+--default-storage-engine=myisam
+--default-character-set=latin1
+--default-collation=latin1_bin
+[innodb latin1 latin1_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin1
+--default-collation=latin1_bin
+[falcon latin1 latin1_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin1
+--default-collation=latin1_bin
+[myisam latin1 latin1_general_ci]
+--default-storage-engine=myisam
+--default-character-set=latin1
+--default-collation=latin1_general_ci
+[innodb latin1 latin1_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin1
+--default-collation=latin1_general_ci
+[falcon latin1 latin1_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin1
+--default-collation=latin1_general_ci
+[myisam latin1 latin1_general_cs]
+--default-storage-engine=myisam
+--default-character-set=latin1
+--default-collation=latin1_general_cs
+[innodb latin1 latin1_general_cs]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin1
+--default-collation=latin1_general_cs
+[falcon latin1 latin1_general_cs]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin1
+--default-collation=latin1_general_cs
+[myisam latin1 latin1_spanish_ci]
+--default-storage-engine=myisam
+--default-character-set=latin1
+--default-collation=latin1_spanish_ci
+[innodb latin1 latin1_spanish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin1
+--default-collation=latin1_spanish_ci
+[falcon latin1 latin1_spanish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin1
+--default-collation=latin1_spanish_ci
+[myisam latin2 latin2_czech_cs]
+--default-storage-engine=myisam
+--default-character-set=latin2
+--default-collation=latin2_czech_cs
+[innodb latin2 latin2_czech_cs]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin2
+--default-collation=latin2_czech_cs
+[falcon latin2 latin2_czech_cs]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin2
+--default-collation=latin2_czech_cs
+[myisam latin2 latin2_general_ci]
+--default-storage-engine=myisam
+--default-character-set=latin2
+--default-collation=latin2_general_ci
+[innodb latin2 latin2_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin2
+--default-collation=latin2_general_ci
+[falcon latin2 latin2_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin2
+--default-collation=latin2_general_ci
+[myisam latin2 latin2_hungarian_ci]
+--default-storage-engine=myisam
+--default-character-set=latin2
+--default-collation=latin2_hungarian_ci
+[innodb latin2 latin2_hungarian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin2
+--default-collation=latin2_hungarian_ci
+[falcon latin2 latin2_hungarian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin2
+--default-collation=latin2_hungarian_ci
+[myisam latin2 latin2_croatian_ci]
+--default-storage-engine=myisam
+--default-character-set=latin2
+--default-collation=latin2_croatian_ci
+[innodb latin2 latin2_croatian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin2
+--default-collation=latin2_croatian_ci
+[falcon latin2 latin2_croatian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin2
+--default-collation=latin2_croatian_ci
+[myisam latin2 latin2_bin]
+--default-storage-engine=myisam
+--default-character-set=latin2
+--default-collation=latin2_bin
+[innodb latin2 latin2_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin2
+--default-collation=latin2_bin
+[falcon latin2 latin2_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin2
+--default-collation=latin2_bin
+[myisam ascii ascii_general_ci]
+--default-storage-engine=myisam
+--default-character-set=ascii
+--default-collation=ascii_general_ci
+[innodb ascii ascii_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=ascii
+--default-collation=ascii_general_ci
+[falcon ascii ascii_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=ascii
+--default-collation=ascii_general_ci
+[myisam ascii ascii_bin]
+--default-storage-engine=myisam
+--default-character-set=ascii
+--default-collation=ascii_bin
+[innodb ascii ascii_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=ascii
+--default-collation=ascii_bin
+[falcon ascii ascii_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=ascii
+--default-collation=ascii_bin
+[myisam ujis ujis_japanese_ci]
+--default-storage-engine=myisam
+--default-character-set=ujis
+--default-collation=ujis_japanese_ci
+[innodb ujis ujis_japanese_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=ujis
+--default-collation=ujis_japanese_ci
+[falcon ujis ujis_japanese_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=ujis
+--default-collation=ujis_japanese_ci
+[myisam ujis ujis_bin]
+--default-storage-engine=myisam
+--default-character-set=ujis
+--default-collation=ujis_bin
+[innodb ujis ujis_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=ujis
+--default-collation=ujis_bin
+[falcon ujis ujis_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=ujis
+--default-collation=ujis_bin
+[myisam sjis sjis_japanese_ci]
+--default-storage-engine=myisam
+--default-character-set=sjis
+--default-collation=sjis_japanese_ci
+[innodb sjis sjis_japanese_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=sjis
+--default-collation=sjis_japanese_ci
+[falcon sjis sjis_japanese_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=sjis
+--default-collation=sjis_japanese_ci
+[myisam sjis sjis_bin]
+--default-storage-engine=myisam
+--default-character-set=sjis
+--default-collation=sjis_bin
+[innodb sjis sjis_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=sjis
+--default-collation=sjis_bin
+[falcon sjis sjis_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=sjis
+--default-collation=sjis_bin
+[myisam hebrew hebrew_general_ci]
+--default-storage-engine=myisam
+--default-character-set=hebrew
+--default-collation=hebrew_general_ci
+[innodb hebrew hebrew_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=hebrew
+--default-collation=hebrew_general_ci
+[falcon hebrew hebrew_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=hebrew
+--default-collation=hebrew_general_ci
+[myisam hebrew hebrew_bin]
+--default-storage-engine=myisam
+--default-character-set=hebrew
+--default-collation=hebrew_bin
+[innodb hebrew hebrew_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=hebrew
+--default-collation=hebrew_bin
+[falcon hebrew hebrew_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=hebrew
+--default-collation=hebrew_bin
+[myisam tis620 tis620_thai_ci]
+--default-storage-engine=myisam
+--default-character-set=tis620
+--default-collation=tis620_thai_ci
+[innodb tis620 tis620_thai_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=tis620
+--default-collation=tis620_thai_ci
+[falcon tis620 tis620_thai_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=tis620
+--default-collation=tis620_thai_ci
+[myisam tis620 tis620_bin]
+--default-storage-engine=myisam
+--default-character-set=tis620
+--default-collation=tis620_bin
+[innodb tis620 tis620_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=tis620
+--default-collation=tis620_bin
+[falcon tis620 tis620_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=tis620
+--default-collation=tis620_bin
+[myisam euckr euckr_korean_ci]
+--default-storage-engine=myisam
+--default-character-set=euckr
+--default-collation=euckr_korean_ci
+[innodb euckr euckr_korean_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=euckr
+--default-collation=euckr_korean_ci
+[falcon euckr euckr_korean_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=euckr
+--default-collation=euckr_korean_ci
+[myisam euckr euckr_bin]
+--default-storage-engine=myisam
+--default-character-set=euckr
+--default-collation=euckr_bin
+[innodb euckr euckr_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=euckr
+--default-collation=euckr_bin
+[falcon euckr euckr_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=euckr
+--default-collation=euckr_bin
+[myisam koi8u koi8u_general_ci]
+--default-storage-engine=myisam
+--default-character-set=koi8u
+--default-collation=koi8u_general_ci
+[innodb koi8u koi8u_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=koi8u
+--default-collation=koi8u_general_ci
+[falcon koi8u koi8u_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=koi8u
+--default-collation=koi8u_general_ci
+[myisam koi8u koi8u_bin]
+--default-storage-engine=myisam
+--default-character-set=koi8u
+--default-collation=koi8u_bin
+[innodb koi8u koi8u_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=koi8u
+--default-collation=koi8u_bin
+[falcon koi8u koi8u_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=koi8u
+--default-collation=koi8u_bin
+[myisam gb2312 gb2312_chinese_ci]
+--default-storage-engine=myisam
+--default-character-set=gb2312
+--default-collation=gb2312_chinese_ci
+[innodb gb2312 gb2312_chinese_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=gb2312
+--default-collation=gb2312_chinese_ci
+[falcon gb2312 gb2312_chinese_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=gb2312
+--default-collation=gb2312_chinese_ci
+[myisam gb2312 gb2312_bin]
+--default-storage-engine=myisam
+--default-character-set=gb2312
+--default-collation=gb2312_bin
+[innodb gb2312 gb2312_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=gb2312
+--default-collation=gb2312_bin
+[falcon gb2312 gb2312_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=gb2312
+--default-collation=gb2312_bin
+[myisam greek greek_general_ci]
+--default-storage-engine=myisam
+--default-character-set=greek
+--default-collation=greek_general_ci
+[innodb greek greek_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=greek
+--default-collation=greek_general_ci
+[falcon greek greek_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=greek
+--default-collation=greek_general_ci
+[myisam greek greek_bin]
+--default-storage-engine=myisam
+--default-character-set=greek
+--default-collation=greek_bin
+[innodb greek greek_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=greek
+--default-collation=greek_bin
+[falcon greek greek_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=greek
+--default-collation=greek_bin
+[myisam cp1250 cp1250_general_ci]
+--default-storage-engine=myisam
+--default-character-set=cp1250
+--default-collation=cp1250_general_ci
+[innodb cp1250 cp1250_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1250
+--default-collation=cp1250_general_ci
+[falcon cp1250 cp1250_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1250
+--default-collation=cp1250_general_ci
+[myisam cp1250 cp1250_czech_cs]
+--default-storage-engine=myisam
+--default-character-set=cp1250
+--default-collation=cp1250_czech_cs
+[innodb cp1250 cp1250_czech_cs]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1250
+--default-collation=cp1250_czech_cs
+[falcon cp1250 cp1250_czech_cs]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1250
+--default-collation=cp1250_czech_cs
+[myisam cp1250 cp1250_croatian_ci]
+--default-storage-engine=myisam
+--default-character-set=cp1250
+--default-collation=cp1250_croatian_ci
+[innodb cp1250 cp1250_croatian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1250
+--default-collation=cp1250_croatian_ci
+[falcon cp1250 cp1250_croatian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1250
+--default-collation=cp1250_croatian_ci
+[myisam cp1250 cp1250_bin]
+--default-storage-engine=myisam
+--default-character-set=cp1250
+--default-collation=cp1250_bin
+[innodb cp1250 cp1250_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1250
+--default-collation=cp1250_bin
+[falcon cp1250 cp1250_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1250
+--default-collation=cp1250_bin
+[myisam cp1250 cp1250_polish_ci]
+--default-storage-engine=myisam
+--default-character-set=cp1250
+--default-collation=cp1250_polish_ci
+[innodb cp1250 cp1250_polish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1250
+--default-collation=cp1250_polish_ci
+[falcon cp1250 cp1250_polish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1250
+--default-collation=cp1250_polish_ci
+[myisam gbk gbk_chinese_ci]
+--default-storage-engine=myisam
+--default-character-set=gbk
+--default-collation=gbk_chinese_ci
+[innodb gbk gbk_chinese_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=gbk
+--default-collation=gbk_chinese_ci
+[falcon gbk gbk_chinese_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=gbk
+--default-collation=gbk_chinese_ci
+[myisam gbk gbk_bin]
+--default-storage-engine=myisam
+--default-character-set=gbk
+--default-collation=gbk_bin
+[innodb gbk gbk_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=gbk
+--default-collation=gbk_bin
+[falcon gbk gbk_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=gbk
+--default-collation=gbk_bin
+[myisam latin5 latin5_turkish_ci]
+--default-storage-engine=myisam
+--default-character-set=latin5
+--default-collation=latin5_turkish_ci
+[innodb latin5 latin5_turkish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin5
+--default-collation=latin5_turkish_ci
+[falcon latin5 latin5_turkish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin5
+--default-collation=latin5_turkish_ci
+[myisam latin5 latin5_bin]
+--default-storage-engine=myisam
+--default-character-set=latin5
+--default-collation=latin5_bin
+[innodb latin5 latin5_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin5
+--default-collation=latin5_bin
+[falcon latin5 latin5_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin5
+--default-collation=latin5_bin
+[myisam armscii8 armscii8_general_ci]
+--default-storage-engine=myisam
+--default-character-set=armscii8
+--default-collation=armscii8_general_ci
+[innodb armscii8 armscii8_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=armscii8
+--default-collation=armscii8_general_ci
+[falcon armscii8 armscii8_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=armscii8
+--default-collation=armscii8_general_ci
+[myisam armscii8 armscii8_bin]
+--default-storage-engine=myisam
+--default-character-set=armscii8
+--default-collation=armscii8_bin
+[innodb armscii8 armscii8_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=armscii8
+--default-collation=armscii8_bin
+[falcon armscii8 armscii8_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=armscii8
+--default-collation=armscii8_bin
+[myisam utf8mb3 utf8mb3_general_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_general_ci
+[innodb utf8mb3 utf8mb3_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_general_ci
+[falcon utf8mb3 utf8mb3_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_general_ci
+[myisam utf8mb3 utf8mb3_bin]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_bin
+[innodb utf8mb3 utf8mb3_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_bin
+[falcon utf8mb3 utf8mb3_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_bin
+[myisam utf8mb3 utf8mb3_unicode_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_unicode_ci
+[innodb utf8mb3 utf8mb3_unicode_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_unicode_ci
+[falcon utf8mb3 utf8mb3_unicode_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_unicode_ci
+[myisam utf8mb3 utf8mb3_icelandic_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_icelandic_ci
+[innodb utf8mb3 utf8mb3_icelandic_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_icelandic_ci
+[falcon utf8mb3 utf8mb3_icelandic_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_icelandic_ci
+[myisam utf8mb3 utf8mb3_latvian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_latvian_ci
+[innodb utf8mb3 utf8mb3_latvian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_latvian_ci
+[falcon utf8mb3 utf8mb3_latvian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_latvian_ci
+[myisam utf8mb3 utf8mb3_romanian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_romanian_ci
+[innodb utf8mb3 utf8mb3_romanian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_romanian_ci
+[falcon utf8mb3 utf8mb3_romanian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_romanian_ci
+[myisam utf8mb3 utf8mb3_slovenian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_slovenian_ci
+[innodb utf8mb3 utf8mb3_slovenian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_slovenian_ci
+[falcon utf8mb3 utf8mb3_slovenian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_slovenian_ci
+[myisam utf8mb3 utf8mb3_polish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_polish_ci
+[innodb utf8mb3 utf8mb3_polish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_polish_ci
+[falcon utf8mb3 utf8mb3_polish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_polish_ci
+[myisam utf8mb3 utf8mb3_estonian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_estonian_ci
+[innodb utf8mb3 utf8mb3_estonian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_estonian_ci
+[falcon utf8mb3 utf8mb3_estonian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_estonian_ci
+[myisam utf8mb3 utf8mb3_spanish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_spanish_ci
+[innodb utf8mb3 utf8mb3_spanish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_spanish_ci
+[falcon utf8mb3 utf8mb3_spanish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_spanish_ci
+[myisam utf8mb3 utf8mb3_swedish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_swedish_ci
+[innodb utf8mb3 utf8mb3_swedish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_swedish_ci
+[falcon utf8mb3 utf8mb3_swedish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_swedish_ci
+[myisam utf8mb3 utf8mb3_turkish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_turkish_ci
+[innodb utf8mb3 utf8mb3_turkish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_turkish_ci
+[falcon utf8mb3 utf8mb3_turkish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_turkish_ci
+[myisam utf8mb3 utf8mb3_czech_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_czech_ci
+[innodb utf8mb3 utf8mb3_czech_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_czech_ci
+[falcon utf8mb3 utf8mb3_czech_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_czech_ci
+[myisam utf8mb3 utf8mb3_danish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_danish_ci
+[innodb utf8mb3 utf8mb3_danish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_danish_ci
+[falcon utf8mb3 utf8mb3_danish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_danish_ci
+[myisam utf8mb3 utf8mb3_lithuanian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_lithuanian_ci
+[innodb utf8mb3 utf8mb3_lithuanian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_lithuanian_ci
+[falcon utf8mb3 utf8mb3_lithuanian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_lithuanian_ci
+[myisam utf8mb3 utf8mb3_slovak_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_slovak_ci
+[innodb utf8mb3 utf8mb3_slovak_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_slovak_ci
+[falcon utf8mb3 utf8mb3_slovak_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_slovak_ci
+[myisam utf8mb3 utf8mb3_spanish2_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_spanish2_ci
+[innodb utf8mb3 utf8mb3_spanish2_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_spanish2_ci
+[falcon utf8mb3 utf8mb3_spanish2_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_spanish2_ci
+[myisam utf8mb3 utf8mb3_roman_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_roman_ci
+[innodb utf8mb3 utf8mb3_roman_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_roman_ci
+[falcon utf8mb3 utf8mb3_roman_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_roman_ci
+[myisam utf8mb3 utf8mb3_persian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_persian_ci
+[innodb utf8mb3 utf8mb3_persian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_persian_ci
+[falcon utf8mb3 utf8mb3_persian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_persian_ci
+[myisam utf8mb3 utf8mb3_esperanto_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_esperanto_ci
+[innodb utf8mb3 utf8mb3_esperanto_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_esperanto_ci
+[falcon utf8mb3 utf8mb3_esperanto_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_esperanto_ci
+[myisam utf8mb3 utf8mb3_hungarian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_hungarian_ci
+[innodb utf8mb3 utf8mb3_hungarian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_hungarian_ci
+[falcon utf8mb3 utf8mb3_hungarian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3
+--default-collation=utf8mb3_hungarian_ci
+[myisam cp866 cp866_general_ci]
+--default-storage-engine=myisam
+--default-character-set=cp866
+--default-collation=cp866_general_ci
+[innodb cp866 cp866_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp866
+--default-collation=cp866_general_ci
+[falcon cp866 cp866_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp866
+--default-collation=cp866_general_ci
+[myisam cp866 cp866_bin]
+--default-storage-engine=myisam
+--default-character-set=cp866
+--default-collation=cp866_bin
+[innodb cp866 cp866_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp866
+--default-collation=cp866_bin
+[falcon cp866 cp866_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp866
+--default-collation=cp866_bin
+[myisam keybcs2 keybcs2_general_ci]
+--default-storage-engine=myisam
+--default-character-set=keybcs2
+--default-collation=keybcs2_general_ci
+[innodb keybcs2 keybcs2_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=keybcs2
+--default-collation=keybcs2_general_ci
+[falcon keybcs2 keybcs2_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=keybcs2
+--default-collation=keybcs2_general_ci
+[myisam keybcs2 keybcs2_bin]
+--default-storage-engine=myisam
+--default-character-set=keybcs2
+--default-collation=keybcs2_bin
+[innodb keybcs2 keybcs2_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=keybcs2
+--default-collation=keybcs2_bin
+[falcon keybcs2 keybcs2_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=keybcs2
+--default-collation=keybcs2_bin
+[myisam macce macce_general_ci]
+--default-storage-engine=myisam
+--default-character-set=macce
+--default-collation=macce_general_ci
+[innodb macce macce_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=macce
+--default-collation=macce_general_ci
+[falcon macce macce_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=macce
+--default-collation=macce_general_ci
+[myisam macce macce_bin]
+--default-storage-engine=myisam
+--default-character-set=macce
+--default-collation=macce_bin
+[innodb macce macce_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=macce
+--default-collation=macce_bin
+[falcon macce macce_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=macce
+--default-collation=macce_bin
+[myisam macroman macroman_general_ci]
+--default-storage-engine=myisam
+--default-character-set=macroman
+--default-collation=macroman_general_ci
+[innodb macroman macroman_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=macroman
+--default-collation=macroman_general_ci
+[falcon macroman macroman_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=macroman
+--default-collation=macroman_general_ci
+[myisam macroman macroman_bin]
+--default-storage-engine=myisam
+--default-character-set=macroman
+--default-collation=macroman_bin
+[innodb macroman macroman_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=macroman
+--default-collation=macroman_bin
+[falcon macroman macroman_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=macroman
+--default-collation=macroman_bin
+[myisam cp852 cp852_general_ci]
+--default-storage-engine=myisam
+--default-character-set=cp852
+--default-collation=cp852_general_ci
+[innodb cp852 cp852_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp852
+--default-collation=cp852_general_ci
+[falcon cp852 cp852_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp852
+--default-collation=cp852_general_ci
+[myisam cp852 cp852_bin]
+--default-storage-engine=myisam
+--default-character-set=cp852
+--default-collation=cp852_bin
+[innodb cp852 cp852_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp852
+--default-collation=cp852_bin
+[falcon cp852 cp852_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp852
+--default-collation=cp852_bin
+[myisam latin7 latin7_estonian_cs]
+--default-storage-engine=myisam
+--default-character-set=latin7
+--default-collation=latin7_estonian_cs
+[innodb latin7 latin7_estonian_cs]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin7
+--default-collation=latin7_estonian_cs
+[falcon latin7 latin7_estonian_cs]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin7
+--default-collation=latin7_estonian_cs
+[myisam latin7 latin7_general_ci]
+--default-storage-engine=myisam
+--default-character-set=latin7
+--default-collation=latin7_general_ci
+[innodb latin7 latin7_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin7
+--default-collation=latin7_general_ci
+[falcon latin7 latin7_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin7
+--default-collation=latin7_general_ci
+[myisam latin7 latin7_general_cs]
+--default-storage-engine=myisam
+--default-character-set=latin7
+--default-collation=latin7_general_cs
+[innodb latin7 latin7_general_cs]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin7
+--default-collation=latin7_general_cs
+[falcon latin7 latin7_general_cs]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin7
+--default-collation=latin7_general_cs
+[myisam latin7 latin7_bin]
+--default-storage-engine=myisam
+--default-character-set=latin7
+--default-collation=latin7_bin
+[innodb latin7 latin7_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin7
+--default-collation=latin7_bin
+[falcon latin7 latin7_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin7
+--default-collation=latin7_bin
+[myisam utf8 utf8_general_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_general_ci
+[innodb utf8 utf8_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_general_ci
+[falcon utf8 utf8_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_general_ci
+[myisam utf8 utf8_bin]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_bin
+[innodb utf8 utf8_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_bin
+[falcon utf8 utf8_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_bin
+[myisam utf8 utf8_unicode_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_unicode_ci
+[innodb utf8 utf8_unicode_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_unicode_ci
+[falcon utf8 utf8_unicode_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_unicode_ci
+[myisam utf8 utf8_icelandic_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_icelandic_ci
+[innodb utf8 utf8_icelandic_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_icelandic_ci
+[falcon utf8 utf8_icelandic_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_icelandic_ci
+[myisam utf8 utf8_latvian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_latvian_ci
+[innodb utf8 utf8_latvian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_latvian_ci
+[falcon utf8 utf8_latvian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_latvian_ci
+[myisam utf8 utf8_romanian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_romanian_ci
+[innodb utf8 utf8_romanian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_romanian_ci
+[falcon utf8 utf8_romanian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_romanian_ci
+[myisam utf8 utf8_slovenian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_slovenian_ci
+[innodb utf8 utf8_slovenian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_slovenian_ci
+[falcon utf8 utf8_slovenian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_slovenian_ci
+[myisam utf8 utf8_polish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_polish_ci
+[innodb utf8 utf8_polish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_polish_ci
+[falcon utf8 utf8_polish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_polish_ci
+[myisam utf8 utf8_estonian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_estonian_ci
+[innodb utf8 utf8_estonian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_estonian_ci
+[falcon utf8 utf8_estonian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_estonian_ci
+[myisam utf8 utf8_spanish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_spanish_ci
+[innodb utf8 utf8_spanish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_spanish_ci
+[falcon utf8 utf8_spanish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_spanish_ci
+[myisam utf8 utf8_swedish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_swedish_ci
+[innodb utf8 utf8_swedish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_swedish_ci
+[falcon utf8 utf8_swedish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_swedish_ci
+[myisam utf8 utf8_turkish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_turkish_ci
+[innodb utf8 utf8_turkish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_turkish_ci
+[falcon utf8 utf8_turkish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_turkish_ci
+[myisam utf8 utf8_czech_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_czech_ci
+[innodb utf8 utf8_czech_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_czech_ci
+[falcon utf8 utf8_czech_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_czech_ci
+[myisam utf8 utf8_danish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_danish_ci
+[innodb utf8 utf8_danish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_danish_ci
+[falcon utf8 utf8_danish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_danish_ci
+[myisam utf8 utf8_lithuanian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_lithuanian_ci
+[innodb utf8 utf8_lithuanian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_lithuanian_ci
+[falcon utf8 utf8_lithuanian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_lithuanian_ci
+[myisam utf8 utf8_slovak_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_slovak_ci
+[innodb utf8 utf8_slovak_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_slovak_ci
+[falcon utf8 utf8_slovak_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_slovak_ci
+[myisam utf8 utf8_spanish2_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_spanish2_ci
+[innodb utf8 utf8_spanish2_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_spanish2_ci
+[falcon utf8 utf8_spanish2_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_spanish2_ci
+[myisam utf8 utf8_roman_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_roman_ci
+[innodb utf8 utf8_roman_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_roman_ci
+[falcon utf8 utf8_roman_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_roman_ci
+[myisam utf8 utf8_persian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_persian_ci
+[innodb utf8 utf8_persian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_persian_ci
+[falcon utf8 utf8_persian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_persian_ci
+[myisam utf8 utf8_esperanto_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_esperanto_ci
+[innodb utf8 utf8_esperanto_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_esperanto_ci
+[falcon utf8 utf8_esperanto_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_esperanto_ci
+[myisam utf8 utf8_hungarian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_hungarian_ci
+[innodb utf8 utf8_hungarian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_hungarian_ci
+[falcon utf8 utf8_hungarian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_hungarian_ci
+[myisam utf8 utf8_sinhala_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8
+--default-collation=utf8_sinhala_ci
+[innodb utf8 utf8_sinhala_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8
+--default-collation=utf8_sinhala_ci
+[falcon utf8 utf8_sinhala_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8
+--default-collation=utf8_sinhala_ci
+[myisam cp1251 cp1251_bulgarian_ci]
+--default-storage-engine=myisam
+--default-character-set=cp1251
+--default-collation=cp1251_bulgarian_ci
+[innodb cp1251 cp1251_bulgarian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1251
+--default-collation=cp1251_bulgarian_ci
+[falcon cp1251 cp1251_bulgarian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1251
+--default-collation=cp1251_bulgarian_ci
+[myisam cp1251 cp1251_ukrainian_ci]
+--default-storage-engine=myisam
+--default-character-set=cp1251
+--default-collation=cp1251_ukrainian_ci
+[innodb cp1251 cp1251_ukrainian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1251
+--default-collation=cp1251_ukrainian_ci
+[falcon cp1251 cp1251_ukrainian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1251
+--default-collation=cp1251_ukrainian_ci
+[myisam cp1251 cp1251_bin]
+--default-storage-engine=myisam
+--default-character-set=cp1251
+--default-collation=cp1251_bin
+[innodb cp1251 cp1251_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1251
+--default-collation=cp1251_bin
+[falcon cp1251 cp1251_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1251
+--default-collation=cp1251_bin
+[myisam cp1251 cp1251_general_ci]
+--default-storage-engine=myisam
+--default-character-set=cp1251
+--default-collation=cp1251_general_ci
+[innodb cp1251 cp1251_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1251
+--default-collation=cp1251_general_ci
+[falcon cp1251 cp1251_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1251
+--default-collation=cp1251_general_ci
+[myisam cp1251 cp1251_general_cs]
+--default-storage-engine=myisam
+--default-character-set=cp1251
+--default-collation=cp1251_general_cs
+[innodb cp1251 cp1251_general_cs]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1251
+--default-collation=cp1251_general_cs
+[falcon cp1251 cp1251_general_cs]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1251
+--default-collation=cp1251_general_cs
+[myisam cp1256 cp1256_general_ci]
+--default-storage-engine=myisam
+--default-character-set=cp1256
+--default-collation=cp1256_general_ci
+[innodb cp1256 cp1256_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1256
+--default-collation=cp1256_general_ci
+[falcon cp1256 cp1256_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1256
+--default-collation=cp1256_general_ci
+[myisam cp1256 cp1256_bin]
+--default-storage-engine=myisam
+--default-character-set=cp1256
+--default-collation=cp1256_bin
+[innodb cp1256 cp1256_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1256
+--default-collation=cp1256_bin
+[falcon cp1256 cp1256_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1256
+--default-collation=cp1256_bin
+[myisam cp1257 cp1257_lithuanian_ci]
+--default-storage-engine=myisam
+--default-character-set=cp1257
+--default-collation=cp1257_lithuanian_ci
+[innodb cp1257 cp1257_lithuanian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1257
+--default-collation=cp1257_lithuanian_ci
+[falcon cp1257 cp1257_lithuanian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1257
+--default-collation=cp1257_lithuanian_ci
+[myisam cp1257 cp1257_bin]
+--default-storage-engine=myisam
+--default-character-set=cp1257
+--default-collation=cp1257_bin
+[innodb cp1257 cp1257_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1257
+--default-collation=cp1257_bin
+[falcon cp1257 cp1257_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1257
+--default-collation=cp1257_bin
+[myisam cp1257 cp1257_general_ci]
+--default-storage-engine=myisam
+--default-character-set=cp1257
+--default-collation=cp1257_general_ci
+[innodb cp1257 cp1257_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1257
+--default-collation=cp1257_general_ci
+[falcon cp1257 cp1257_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1257
+--default-collation=cp1257_general_ci
+[myisam geostd8 geostd8_general_ci]
+--default-storage-engine=myisam
+--default-character-set=geostd8
+--default-collation=geostd8_general_ci
+[innodb geostd8 geostd8_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=geostd8
+--default-collation=geostd8_general_ci
+[falcon geostd8 geostd8_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=geostd8
+--default-collation=geostd8_general_ci
+[myisam geostd8 geostd8_bin]
+--default-storage-engine=myisam
+--default-character-set=geostd8
+--default-collation=geostd8_bin
+[innodb geostd8 geostd8_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=geostd8
+--default-collation=geostd8_bin
+[falcon geostd8 geostd8_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=geostd8
+--default-collation=geostd8_bin
+[myisam cp932 cp932_japanese_ci]
+--default-storage-engine=myisam
+--default-character-set=cp932
+--default-collation=cp932_japanese_ci
+[innodb cp932 cp932_japanese_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp932
+--default-collation=cp932_japanese_ci
+[falcon cp932 cp932_japanese_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp932
+--default-collation=cp932_japanese_ci
+[myisam cp932 cp932_bin]
+--default-storage-engine=myisam
+--default-character-set=cp932
+--default-collation=cp932_bin
+[innodb cp932 cp932_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp932
+--default-collation=cp932_bin
+[falcon cp932 cp932_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp932
+--default-collation=cp932_bin
+[myisam eucjpms eucjpms_japanese_ci]
+--default-storage-engine=myisam
+--default-character-set=eucjpms
+--default-collation=eucjpms_japanese_ci
+[innodb eucjpms eucjpms_japanese_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=eucjpms
+--default-collation=eucjpms_japanese_ci
+[falcon eucjpms eucjpms_japanese_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=eucjpms
+--default-collation=eucjpms_japanese_ci
+[myisam eucjpms eucjpms_bin]
+--default-storage-engine=myisam
+--default-character-set=eucjpms
+--default-collation=eucjpms_bin
+[innodb eucjpms eucjpms_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=eucjpms
+--default-collation=eucjpms_bin
+[falcon eucjpms eucjpms_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=eucjpms
+--default-collation=eucjpms_bin
=== added directory 'mysql-test/suite/backup_charsets/include'
=== added file 'mysql-test/suite/backup_charsets/include/charset.inc'
--- a/mysql-test/suite/backup_charsets/include/charset.inc 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/backup_charsets/include/charset.inc 2008-07-07 22:22:55 +0000
@@ -0,0 +1,15 @@
+###############################################################################
+# Author: Hema
+# Date: 2008-04-01
+# Purpose:To define the charset and collate variable.
+###############################################################################
+
+
+--replace_column 2 #
+SHOW VARIABLES LIKE 'character_set_database';
+let $cset=query_get_value(SHOW VARIABLES LIKE 'character_set_database', Value,1);
+
+--replace_column 2 #
+SHOW VARIABLES LIKE 'collation_database';
+let $coll=query_get_value(SHOW VARIABLES LIKE 'collation_database', Value, 1);
+
=== added file 'mysql-test/suite/backup_charsets/include/not_have_falcon.inc'
--- a/mysql-test/suite/backup_charsets/include/not_have_falcon.inc 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/backup_charsets/include/not_have_falcon.inc 2008-07-07 22:22:55 +0000
@@ -0,0 +1,6 @@
+--replace_result $ENGINE ENGINE
+if(`SELECT '$ENGINE'='falcon'`)
+{
+ skip "This test does'nt support falcon engine BUG#33566" ;
+}
+
=== added directory 'mysql-test/suite/backup_charsets/r'
=== added file 'mysql-test/suite/backup_charsets/r/backup_datatypes.result'
--- a/mysql-test/suite/backup_charsets/r/backup_datatypes.result 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/backup_charsets/r/backup_datatypes.result 2008-07-07 22:22:55 +0000
@@ -0,0 +1,158 @@
+SHOW VARIABLES LIKE 'storage_engine';
+Variable_name Value
+storage_engine #
+SHOW VARIABLES LIKE 'character_set_database';
+Variable_name Value
+character_set_database #
+SHOW VARIABLES LIKE 'collation_database';
+Variable_name Value
+collation_database #
+
+starting the test for backup
+
+DROP DATABASE IF EXISTS bup_datatype;
+SET NAMES cset;
+CREATE DATABASE bup_datatype;
+USE bup_datatype;
+Creating table with all storage engines and csets/coll
+CREATE TABLE d1(
+rint INT,
+tint TINYINT,
+sint SMALLINT,
+bint BIGINT,
+mint MEDIUMINT,
+name CHAR(100),
+city VARCHAR(100),
+fl FLOAT(7,4),
+pers DECIMAL(8,2),
+sal DOUBLE,
+colours SET('red','blue','yellow'),
+continent ENUM('Asia', 'Europe','Africa','Antartica'),
+ts TIMESTAMP DEFAULT 0,
+dob DATE,
+y YEAR
+);
+creating table with blob and text columns
+CREATE TABLE d2(
+region TEXT,
+summary LONGTEXT,
+data BLOB,
+details MEDIUMBLOB,
+queries TINYTEXT,
+query2 TINYBLOB,
+extract LONGBLOB,
+paras MEDIUMTEXT
+);
+INSERT INTO d1 VALUES
+(785,127,7288,278829899,3777,'testing1','sweden','678.299',200.23,829899.909,
+'red','Asia','2008-06-01 16:23:30','1984-09-08','1984');
+INSERT INTO d2 VALUES
+('xxxxxxxx','Testofonline backup','aaaaaaaaaa','bbbbbbbbbbb','hhhhhhhhhhh',
+'kkkkkkkkkkkkk','mmmmmmmmmmmm','onlinebackup1');
+UPDATE d2 SET extract=repeat('z',100);
+SELECT * FROM d1;;
+rint 785
+tint 127
+sint 7288
+bint 278829899
+mint 3777
+name testing1
+city sweden
+fl 678.2990
+pers 200.23
+sal 829899.909
+colours red
+continent Asia
+ts 2008-06-01 16:23:30
+dob 1984-09-08
+y 1984
+SELECT * FROM d2;
+region summary data details queries query2 extract paras
+xxxxxxxx Testofonline backup aaaaaaaaaa bbbbbbbbbbb hhhhhhhhhhh kkkkkkkkkkkkk zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz onlinebackup1
+DESCRIBE d1;
+Field Type Null Key Default Extra
+rint int(11) YES NULL
+tint tinyint(4) YES NULL
+sint smallint(6) YES NULL
+bint bigint(20) YES NULL
+mint mediumint(9) YES NULL
+name char(100) YES NULL
+city varchar(100) YES NULL
+fl float(7,4) YES NULL
+pers decimal(8,2) YES NULL
+sal double YES NULL
+colours set('red','blue','yellow') YES NULL
+continent enum('Asia','Europe','Africa','Antartica') YES NULL
+ts timestamp NO 0000-00-00 00:00:00
+dob date YES NULL
+y year(4) YES NULL
+DESCRIBE d2;
+Field Type Null Key Default Extra
+region text YES NULL
+summary longtext YES NULL
+data blob YES NULL
+details mediumblob YES NULL
+queries tinytext YES NULL
+query2 tinyblob YES NULL
+extract longblob YES NULL
+paras mediumtext YES NULL
+**backup data**
+
+BACKUP DATABASE bup_datatype TO 'bup_datatype.bak';
+backup_id
+#
+DROP DATABASE bup_datatype;
+**Restore**
+RESTORE FROM 'bup_datatype.bak';
+backup_id
+#
+DESCRIBE d1;
+Field Type Null Key Default Extra
+rint int(11) YES NULL
+tint tinyint(4) YES NULL
+sint smallint(6) YES NULL
+bint bigint(20) YES NULL
+mint mediumint(9) YES NULL
+name char(100) YES NULL
+city varchar(100) YES NULL
+fl float(7,4) YES NULL
+pers decimal(8,2) YES NULL
+sal double YES NULL
+colours set('red','blue','yellow') YES NULL
+continent enum('Asia','Europe','Africa','Antartica') YES NULL
+ts timestamp NO 0000-00-00 00:00:00
+dob date YES NULL
+y year(4) YES NULL
+DESCRIBE d2;
+Field Type Null Key Default Extra
+region text YES NULL
+summary longtext YES NULL
+data blob YES NULL
+details mediumblob YES NULL
+queries tinytext YES NULL
+query2 tinyblob YES NULL
+extract longblob YES NULL
+paras mediumtext YES NULL
+SELECT * FROM d1;;
+rint 785
+tint 127
+sint 7288
+bint 278829899
+mint 3777
+name testing1
+city sweden
+fl 678.2990
+pers 200.23
+sal 829899.909
+colours red
+continent Asia
+ts 2008-06-01 16:23:30
+dob 1984-09-08
+y 1984
+SELECT * FROM d2;
+region summary data details queries query2 extract paras
+xxxxxxxx Testofonline backup aaaaaaaaaa bbbbbbbbbbb hhhhhhhhhhh kkkkkkkkkkkkk zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz onlinebackup1
+
+*** DROP bup_datatype DATABASE ****
+
+DROP DATABASE bup_datatype;
=== added file 'mysql-test/suite/backup_charsets/r/backup_partitions.result'
--- a/mysql-test/suite/backup_charsets/r/backup_partitions.result 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/backup_charsets/r/backup_partitions.result 2008-07-07 22:22:55 +0000
@@ -0,0 +1,492 @@
+SHOW VARIABLES LIKE 'storage_engine';
+Variable_name Value
+storage_engine #
+SHOW VARIABLES LIKE 'character_set_database';
+Variable_name Value
+character_set_database #
+SHOW VARIABLES LIKE 'collation_database';
+Variable_name Value
+collation_database #
+
+starting the test for backup
+
+DROP DATABASE IF EXISTS partitions;
+Bug #34391 Character sets: crash if char(), utf32, innodb
+Bug #33566 Backup: crash with partitions and Falcon
+Bug #37551 Junk detected in data contents sometimes when utf8mb3
+character set is used.
+Bug #37554 Use of character set and collate as 'filename' shows
+unusual behaviour.
+Bug #35499 View when created with swe7 character set fails.
+SET NAMES cset;
+CREATE DATABASE partitions;
+USE partitions;
+*****Creating table with range partition*********
+CREATE TABLE `range`(
+ID INT NOT NULL,
+NAME CHAR(20),
+AGE TINYINT,
+DOB DATE,
+SAL FLOAT,
+PRIMARY KEY(DOB)) PARTITION BY RANGE(Year(DOB))(
+PARTITION P0 values less than (1970),
+PARTITION P1 values less than (1980),
+PARTITION P2 values less than (1990),
+PARTITION P3 values less than (2000),
+PARTITION P4 values less than maxvalue);
+loading data
+INSERT INTO `range`VALUES
+(10,'aa','20','1988-12-19',2345.89),(11,'bb',31,'1977-10-19',6009.89),
+(12,'cc',78,'1945-09-12',3897),(13,'dd',12,'1994-09-18',7892.78),
+(14,'ee',45,'1960-12-23',7845.90),(15,'ff',25,'1984-02-07',3500.89);
+select data
+SELECT * FROM `range` ORDER BY DOB;
+ID NAME AGE DOB SAL
+12 cc 78 1945-09-12 3897
+14 ee 45 1960-12-23 7845.9
+11 bb 31 1977-10-19 6009.89
+15 ff 25 1984-02-07 3500.89
+10 aa 20 1988-12-19 2345.89
+13 dd 12 1994-09-18 7892.78
+SELECT COUNT(*) FROM `range`;
+COUNT(*)
+6
+
+******Creating table partition with List**************
+CREATE TABLE `left`(`numeric` INT, `char` CHAR(20))
+PARTITION BY LIST (`numeric`)
+(
+PARTITION p0 VALUES IN (1,3,5),
+PARTITION p1 VALUES IN (2,4,6)
+);
+insert data
+INSERT INTO `left` VALUES(1,'a'),(6,'c'),(5,'j'),(2,'l');
+selecting data
+SELECT * FROM `left` ORDER BY `numeric`;
+numeric char
+1 a
+2 l
+5 j
+6 c
+SELECT COUNT(*) FROM `left`;
+COUNT(*)
+4
+
+*******Creating table partition with Hash***********
+CREATE TABLE `modifies`(
+col1 INT,
+col2 CHAR(20),
+col3 DATE)
+PARTITION BY HASH (YEAR(col3))
+PARTITIONS 4;
+Insert data
+INSERT INTO `modifies` VALUES
+(1,'a','1942-10-09'),(2,'b','1950-08-07'),
+(3,'c','1952-10-10'),(4,'d','1954-10-04');
+selecting data
+SELECT * FROM `modifies` ORDER BY col3;
+col1 col2 col3
+1 a 1942-10-09
+2 b 1950-08-07
+3 c 1952-10-10
+4 d 1954-10-04
+SELECT COUNT(*) FROM `modifies`;
+COUNT(*)
+4
+********Creating table partition with keys*******
+CREATE TABLE `key`(id INT)
+PARTITION BY KEY(id)
+PARTITIONS 2;
+insert data
+INSERT INTO `key` VALUES(1),(2),(3),(4);
+selecting the data
+SELECT * FROM `key`;
+id
+1
+3
+2
+4
+SELECT COUNT(*) FROM `key`;
+COUNT(*)
+4
+***Creating views from partitoned Tables****
+CREATE VIEW `values` AS SELECT * FROM `range`;
+Obtaining information about Partitions
+SHOW FULL TABLES;
+Tables_in_partitions Table_type
+key BASE TABLE
+left BASE TABLE
+modifies BASE TABLE
+range BASE TABLE
+values VIEW
+EXPLAIN PARTITIONS SELECT * FROM `key`;;
+id #
+select_type SIMPLE
+table key
+partitions p0,p1
+type ALL
+possible_keys NULL
+key NULL
+key_len NULL
+ref NULL
+rows #
+Extra
+EXPLAIN PARTITIONS SELECT * FROM `modifies`;;
+id #
+select_type SIMPLE
+table modifies
+partitions p0,p1,p2,p3
+type ALL
+possible_keys NULL
+key NULL
+key_len NULL
+ref NULL
+rows #
+Extra
+EXPLAIN PARTITIONS SELECT * FROM `left`;;
+id #
+select_type SIMPLE
+table left
+partitions p0,p1
+type ALL
+possible_keys NULL
+key NULL
+key_len NULL
+ref NULL
+rows #
+Extra
+EXPLAIN PARTITIONS SELECT * FROM `range`;;
+id #
+select_type SIMPLE
+table range
+partitions P0,P1,P2,P3,P4
+type ALL
+possible_keys NULL
+key NULL
+key_len NULL
+ref NULL
+rows #
+Extra
+backup data
+BACKUP DATABASE partitions TO 'partitions.bak';
+backup_id
+#
+dropping database.
+DROP DATABASE partitions;
+Restore
+RESTORE FROM 'partitions.bak';
+backup_id
+#
+
+** RESULTS AFTER RESTORE **
+
+Obtaining Information about Partitions
+SHOW FULL TABLES;;
+Tables_in_partitions key
+Table_type BASE TABLE
+Tables_in_partitions left
+Table_type BASE TABLE
+Tables_in_partitions modifies
+Table_type BASE TABLE
+Tables_in_partitions range
+Table_type BASE TABLE
+Tables_in_partitions values
+Table_type VIEW
+EXPLAIN PARTITIONS SELECT * FROM `key`;;
+id #
+select_type SIMPLE
+table key
+partitions p0,p1
+type ALL
+possible_keys NULL
+key NULL
+key_len NULL
+ref NULL
+rows #
+Extra
+EXPLAIN PARTITIONS SELECT * FROM `modifies`;;
+id #
+select_type SIMPLE
+table modifies
+partitions p0,p1,p2,p3
+type ALL
+possible_keys NULL
+key NULL
+key_len NULL
+ref NULL
+rows #
+Extra
+EXPLAIN PARTITIONS SELECT * FROM `left`;;
+id #
+select_type SIMPLE
+table left
+partitions p0,p1
+type ALL
+possible_keys NULL
+key NULL
+key_len NULL
+ref NULL
+rows #
+Extra
+EXPLAIN PARTITIONS SELECT * FROM `range`;;
+id #
+select_type SIMPLE
+table range
+partitions P0,P1,P2,P3,P4
+type ALL
+possible_keys NULL
+key NULL
+key_len NULL
+ref NULL
+rows #
+Extra
+ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
+ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));
+INSERT INTO `left` VALUES(10,'h'),(3,'b'),(10,'s'),(5,'l');
+SELECT * FROM `left`;
+numeric char
+1 a
+5 j
+3 b
+5 l
+6 c
+2 l
+10 h
+10 s
+SELECT COUNT(*) FROM `left`;
+COUNT(*)
+8
+INSERT INTO `values` VALUES(17,'kk','90','2020-12-19',2000);
+SELECT COUNT(*) FROM `values`;
+COUNT(*)
+7
+SELECT COUNT(*) FROM `range`;
+COUNT(*)
+7
+
+**Creating table with subpartitions**
+CREATE TABLE `change` (`int` INT)
+PARTITION BY range (`int`)
+SUBPARTITION BY key (`int`)
+(PARTITION p0 VALUES LESS THAN (2));
+INSERT INTO `change` VALUES(0),(1);
+SHOW FULL TABLES;
+Tables_in_partitions Table_type
+change BASE TABLE
+key BASE TABLE
+left BASE TABLE
+modifies BASE TABLE
+range BASE TABLE
+values VIEW
+EXPLAIN PARTITIONS SELECT * FROM `left`;;
+id #
+select_type SIMPLE
+table left
+partitions p0,p1,p2
+type ALL
+possible_keys NULL
+key NULL
+key_len NULL
+ref NULL
+rows #
+Extra
+EXPLAIN PARTITIONS SELECT * FROM `range`;;
+id #
+select_type SIMPLE
+table range
+partitions p0,p1
+type ALL
+possible_keys NULL
+key NULL
+key_len NULL
+ref NULL
+rows #
+Extra
+EXPLAIN PARTITIONS SELECT * FROM `change`;;
+id #
+select_type SIMPLE
+table change
+partitions p0_p0sp0
+type ALL
+possible_keys NULL
+key NULL
+key_len NULL
+ref NULL
+rows #
+Extra
+BACKUP DATABASE partitions TO 'partitions.bak';
+backup_id
+#
+DROP DATABASE partitions;
+RESTORE FROM 'partitions.bak';
+backup_id
+#
+showing objects and create statements
+EXPLAIN PARTITIONS SELECT * FROM `key`;;
+id #
+select_type SIMPLE
+table key
+partitions p0,p1
+type ALL
+possible_keys NULL
+key NULL
+key_len NULL
+ref NULL
+rows #
+Extra
+EXPLAIN PARTITIONS SELECT * FROM `modifies`;;
+id #
+select_type SIMPLE
+table modifies
+partitions p0,p1,p2,p3
+type ALL
+possible_keys NULL
+key NULL
+key_len NULL
+ref NULL
+rows #
+Extra
+EXPLAIN PARTITIONS SELECT * FROM `left`;;
+id #
+select_type SIMPLE
+table left
+partitions p0,p1,p2
+type ALL
+possible_keys NULL
+key NULL
+key_len NULL
+ref NULL
+rows #
+Extra
+EXPLAIN PARTITIONS SELECT * FROM `range`;;
+id #
+select_type SIMPLE
+table range
+partitions p0,p1
+type ALL
+possible_keys NULL
+key NULL
+key_len NULL
+ref NULL
+rows #
+Extra
+SELECT * FROM `left` ORDER BY `numeric`;
+numeric char
+1 a
+2 l
+3 b
+5 j
+5 l
+6 c
+10 h
+10 s
+SELECT * FROM `key`;
+id
+1
+3
+2
+4
+SELECT * FROM `modifies` ORDER BY col3;
+col1 col2 col3
+1 a 1942-10-09
+2 b 1950-08-07
+3 c 1952-10-10
+4 d 1954-10-04
+SELECT * FROM `range` ORDER BY DOB;
+ID NAME AGE DOB SAL
+12 cc 78 1945-09-12 3897
+14 ee 45 1960-12-23 7845.9
+11 bb 31 1977-10-19 6009.89
+15 ff 25 1984-02-07 3500.89
+10 aa 20 1988-12-19 2345.89
+13 dd 12 1994-09-18 7892.78
+17 kk 90 2020-12-19 2000
+SELECT * FROM `change`;
+int
+0
+1
+**creating view from view***
+CREATE VIEW v2 AS SELECT * FROM `values`;
+INSERT INTO v2 VALUES(18,'pp',51,'1990-10-19',6009.89);
+SELECT COUNT(*) FROM `values`;
+COUNT(*)
+8
+SELECT COUNT(*) FROM `range`;
+COUNT(*)
+8
+Make some changes and then perform Restore.
+ALTER TABLE `change` ADD PARTITION (PARTITION p1 VALUES LESS THAN (4));
+INSERT INTO `change` VALUES(2),(3),(1);
+EXPLAIN PARTITIONS SELECT * FROM `change`;;
+id #
+select_type SIMPLE
+table change
+partitions p0_p0sp0,p1_p1sp0
+type ALL
+possible_keys NULL
+key NULL
+key_len NULL
+ref NULL
+rows #
+Extra
+SHOW FULL TABLES;
+Tables_in_partitions Table_type
+change BASE TABLE
+key BASE TABLE
+left BASE TABLE
+modifies BASE TABLE
+range BASE TABLE
+v2 VIEW
+values VIEW
+BACKUP DATABASE partitions to 'partitions.bak';
+backup_id
+#
+DROP DATABASE partitions;
+RESTORE FROM 'partitions.bak';
+backup_id
+#
+SHOW FULL TABLES;
+Tables_in_partitions Table_type
+change BASE TABLE
+key BASE TABLE
+left BASE TABLE
+modifies BASE TABLE
+range BASE TABLE
+v2 VIEW
+values VIEW
+SELECT * FROM `change`;
+int
+0
+1
+1
+2
+3
+EXPLAIN PARTITIONS SELECT * FROM `change`;;
+id #
+select_type SIMPLE
+table change
+partitions p0_p0sp0,p1_p1sp0
+type ALL
+possible_keys NULL
+key NULL
+key_len NULL
+ref NULL
+rows #
+Extra
+SELECT * FROM `values` ORDER BY DOB;
+ID NAME AGE DOB SAL
+12 cc 78 1945-09-12 3897
+14 ee 45 1960-12-23 7845.9
+11 bb 31 1977-10-19 6009.89
+15 ff 25 1984-02-07 3500.89
+10 aa 20 1988-12-19 2345.89
+18 pp 51 1990-10-19 6009.89
+13 dd 12 1994-09-18 7892.78
+17 kk 90 2020-12-19 2000
+SELECT COUNT(*) FROM `range`;
+COUNT(*)
+8
+
+*** DROP partitions DATABASE ****
+
+DROP DATABASE partitions;
=== added directory 'mysql-test/suite/backup_charsets/t'
=== added file 'mysql-test/suite/backup_charsets/t/backup_datatypes.test'
--- a/mysql-test/suite/backup_charsets/t/backup_datatypes.test 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/backup_charsets/t/backup_datatypes.test 2008-07-07 22:22:55 +0000
@@ -0,0 +1,122 @@
+########################################################################
+# Author: Hema
+# Date: 2008-03-11
+# Purpose: To test the backup/restore of all datatypes for different storage
+# engines.
+#########################################################################
+--source include/not_embedded.inc
+--source include/have_debug.inc
+--source suite/backup/include/backup_engine.inc
+--source suite/backup_charsets/include/charset.inc
+
+connect (backup,localhost,root,,);
+connect (breakpoints,localhost,root,,);
+
+##############################################################
+--echo
+--echo starting the test for backup
+--echo
+##############################################################
+
+--error 0,1
+--remove_file $MYSQLTEST_VARDIR/master-data/bup_datatype.bak
+
+
+#Create Database and tables with different datatypes for this test.
+
+--disable_warnings
+DROP DATABASE IF EXISTS bup_datatype;
+--enable_warnings
+
+--replace_result $cset cset
+eval SET NAMES $cset;
+CREATE DATABASE bup_datatype;
+USE bup_datatype;
+
+#Bug#37854 Test fails/aborts for collate latin2_czech_cs used with SET
+#and ENUM datatypes
+--replace_result $coll coll
+if(`SELECT '$coll'='latin2_czech_cs'`)
+{
+ skip "This test does'nt support latin2_czech_cs collation BUG#37854" ;
+}
+
+#Create table and load with data.
+
+--echo Creating table with all storage engines and csets/coll
+
+CREATE TABLE d1(
+rint INT,
+tint TINYINT,
+sint SMALLINT,
+bint BIGINT,
+mint MEDIUMINT,
+name CHAR(100),
+city VARCHAR(100),
+fl FLOAT(7,4),
+pers DECIMAL(8,2),
+sal DOUBLE,
+colours SET('red','blue','yellow'),
+continent ENUM('Asia', 'Europe','Africa','Antartica'),
+ts TIMESTAMP DEFAULT 0,
+dob DATE,
+y YEAR
+);
+
+--echo creating table with blob and text columns
+CREATE TABLE d2(
+region TEXT,
+summary LONGTEXT,
+data BLOB,
+details MEDIUMBLOB,
+queries TINYTEXT,
+query2 TINYBLOB,
+extract LONGBLOB,
+paras MEDIUMTEXT
+);
+
+INSERT INTO d1 VALUES
+(785,127,7288,278829899,3777,'testing1','sweden','678.299',200.23,829899.909,
+'red','Asia','2008-06-01 16:23:30','1984-09-08','1984');
+
+INSERT INTO d2 VALUES
+('xxxxxxxx','Testofonline backup','aaaaaaaaaa','bbbbbbbbbbb','hhhhhhhhhhh',
+'kkkkkkkkkkkkk','mmmmmmmmmmmm','onlinebackup1');
+
+# Bug #37212 Restore crashes if table has longblob of size 1MB
+UPDATE d2 SET extract=repeat('z',100);
+--query_vertical SELECT * FROM d1;
+SELECT * FROM d2;
+
+DESCRIBE d1;
+DESCRIBE d2;
+
+--echo **backup data**
+--echo
+--replace_column 1 #
+BACKUP DATABASE bup_datatype TO 'bup_datatype.bak';
+
+--echo** dropping database**
+DROP DATABASE bup_datatype;
+
+--echo **Restore**
+--replace_column 1 #
+RESTORE FROM 'bup_datatype.bak';
+
+#show data table columns
+DESCRIBE d1;
+DESCRIBE d2;
+
+--query_vertical SELECT * FROM d1;
+SELECT * FROM d2;
+
+# Test cleanup section
+
+--echo
+--echo *** DROP bup_datatype DATABASE ****
+--echo
+
+DROP DATABASE bup_datatype;
+--remove_file $MYSQLTEST_VARDIR/master-data/bup_datatype.bak
+
+
=== added file 'mysql-test/suite/backup_charsets/t/backup_partitions.test'
--- a/mysql-test/suite/backup_charsets/t/backup_partitions.test 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/backup_charsets/t/backup_partitions.test 2008-07-07 22:22:55 +0000
@@ -0,0 +1,269 @@
+###########################################################################
+# Author: Hema
+# Date: 2008-03-11
+# Purpose: To test the backup and Restore of different partitions using
+# Reserved words as identifiers for all Character sets
+###############################################################################
+--source include/not_embedded.inc
+--source include/have_debug.inc
+--source suite/backup/include/backup_engine.inc
+--source suite/backup_charsets/include/not_have_falcon.inc
+--source suite/backup_charsets/include/charset.inc
+
+connect (backup,localhost,root,,);
+connect (breakpoints,localhost,root,,);
+
+##############################################################
+--echo
+--echo starting the test for backup
+--echo
+##############################################################
+
+--error 0,1
+--remove_file $MYSQLTEST_VARDIR/master-data/partitions.bak
+
+#Create Database and and tables with different types of partitions.
+
+--disable_warnings
+DROP DATABASE IF EXISTS partitions;
+--enable_warnings
+
+--echo Bug #34391 Character sets: crash if char(), utf32, innodb
+--echo Bug #33566 Backup: crash with partitions and Falcon
+--echo Bug #37551 Junk detected in data contents sometimes when utf8mb3
+--echo character set is used.
+--echo Bug #37554 Use of character set and collate as 'filename' shows
+--echo unusual behaviour.
+--echo Bug #35499 View when created with swe7 character set fails.
+
+--replace_result $cset cset
+eval SET NAMES $cset;
+
+CREATE DATABASE partitions;
+USE partitions;
+
+#Create table and load with data.
+
+--echo *****Creating table with range partition*********
+
+CREATE TABLE `range`(
+ ID INT NOT NULL,
+NAME CHAR(20),
+AGE TINYINT,
+DOB DATE,
+SAL FLOAT,
+PRIMARY KEY(DOB)) PARTITION BY RANGE(Year(DOB))(
+ PARTITION P0 values less than (1970),
+ PARTITION P1 values less than (1980),
+ PARTITION P2 values less than (1990),
+ PARTITION P3 values less than (2000),
+ PARTITION P4 values less than maxvalue);
+
+--echo loading data
+
+INSERT INTO `range`VALUES
+(10,'aa','20','1988-12-19',2345.89),(11,'bb',31,'1977-10-19',6009.89),
+(12,'cc',78,'1945-09-12',3897),(13,'dd',12,'1994-09-18',7892.78),
+(14,'ee',45,'1960-12-23',7845.90),(15,'ff',25,'1984-02-07',3500.89);
+
+--echo select data
+
+SELECT * FROM `range` ORDER BY DOB;
+SELECT COUNT(*) FROM `range`;
+
+--echo
+--echo ******Creating table partition with List**************
+
+CREATE TABLE `left`(`numeric` INT, `char` CHAR(20))
+PARTITION BY LIST (`numeric`)
+(
+ PARTITION p0 VALUES IN (1,3,5),
+ PARTITION p1 VALUES IN (2,4,6)
+);
+--echo insert data
+
+INSERT INTO `left` VALUES(1,'a'),(6,'c'),(5,'j'),(2,'l');
+
+--echo selecting data
+
+SELECT * FROM `left` ORDER BY `numeric`;
+SELECT COUNT(*) FROM `left`;
+
+--echo
+--echo *******Creating table partition with Hash***********
+
+CREATE TABLE `modifies`(
+col1 INT,
+col2 CHAR(20),
+col3 DATE)
+PARTITION BY HASH (YEAR(col3))
+PARTITIONS 4;
+
+--echo Insert data
+
+INSERT INTO `modifies` VALUES
+(1,'a','1942-10-09'),(2,'b','1950-08-07'),
+(3,'c','1952-10-10'),(4,'d','1954-10-04');
+
+--echo selecting data
+
+SELECT * FROM `modifies` ORDER BY col3;
+SELECT COUNT(*) FROM `modifies`;
+--echo ********Creating table partition with keys*******
+
+CREATE TABLE `key`(id INT)
+PARTITION BY KEY(id)
+PARTITIONS 2;
+
+--echo insert data
+
+INSERT INTO `key` VALUES(1),(2),(3),(4);
+
+--echo selecting the data
+
+SELECT * FROM `key`;
+SELECT COUNT(*) FROM `key`;
+
+--echo ***Creating views from partitoned Tables****
+
+CREATE VIEW `values` AS SELECT * FROM `range`;
+
+# We mask some of the columns in Explain Partitions command because of
+# Bug #37532 Explain command shows incorrect rows,
+# when table is partitioned and innodb.
+
+--echo Obtaining information about Partitions
+SHOW FULL TABLES;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `key`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `modifies`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `left`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `range`;
+
+--echo backup data
+--replace_column 1 #
+BACKUP DATABASE partitions TO 'partitions.bak';
+
+--echo dropping database.
+
+DROP DATABASE partitions;
+
+--echo Restore
+--replace_column 1 #
+RESTORE FROM 'partitions.bak';
+--remove_file $MYSQLTEST_VARDIR/master-data/partitions.bak
+
+--echo
+--echo ** RESULTS AFTER RESTORE **
+--echo
+
+#show data and create statements
+--echo Obtaining Information about Partitions
+--query_vertical SHOW FULL TABLES;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `key`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `modifies`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `left`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `range`;
+
+# Make some changes to existing partitions, take backup and then perform
+# Restore
+
+ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
+ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));
+INSERT INTO `left` VALUES(10,'h'),(3,'b'),(10,'s'),(5,'l');
+SELECT * FROM `left`;
+SELECT COUNT(*) FROM `left`;
+
+INSERT INTO `values` VALUES(17,'kk','90','2020-12-19',2000);
+SELECT COUNT(*) FROM `values`;
+SELECT COUNT(*) FROM `range`;
+
+--echo
+--echo **Creating table with subpartitions**
+
+CREATE TABLE `change` (`int` INT)
+PARTITION BY range (`int`)
+SUBPARTITION BY key (`int`)
+(PARTITION p0 VALUES LESS THAN (2));
+
+INSERT INTO `change` VALUES(0),(1);
+
+#show data and create statements
+SHOW FULL TABLES;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `left`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `range`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `change`;
+
+--replace_column 1 #
+BACKUP DATABASE partitions TO 'partitions.bak';
+DROP DATABASE partitions;
+--replace_column 1 #
+RESTORE FROM 'partitions.bak';
+--remove_file $MYSQLTEST_VARDIR/master-data/partitions.bak
+
+#show data and create statements
+--echo showing objects and create statements
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `key`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `modifies`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `left`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `range`;
+
+SELECT * FROM `left` ORDER BY `numeric`;
+SELECT * FROM `key`;
+SELECT * FROM `modifies` ORDER BY col3;
+SELECT * FROM `range` ORDER BY DOB;
+SELECT * FROM `change`;
+
+--echo **creating view from view***
+CREATE VIEW v2 AS SELECT * FROM `values`;
+INSERT INTO v2 VALUES(18,'pp',51,'1990-10-19',6009.89);
+
+
+SELECT COUNT(*) FROM `values`;
+SELECT COUNT(*) FROM `range`;
+
+--echo Make some changes and then perform Restore.
+
+ALTER TABLE `change` ADD PARTITION (PARTITION p1 VALUES LESS THAN (4));
+INSERT INTO `change` VALUES(2),(3),(1);
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `change`;
+SHOW FULL TABLES;
+
+--replace_column 1 #
+BACKUP DATABASE partitions to 'partitions.bak';
+
+DROP DATABASE partitions;
+--replace_column 1 #
+RESTORE FROM 'partitions.bak';
+
+SHOW FULL TABLES;
+SELECT * FROM `change`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `change`;
+SELECT * FROM `values` ORDER BY DOB;
+SELECT COUNT(*) FROM `range`;
+
+# Test cleanup section
+
+--echo
+--echo *** DROP partitions DATABASE ****
+--echo
+DROP DATABASE partitions;
+
+--remove_file $MYSQLTEST_VARDIR/master-data/partitions.bak
+
