1SET @@character_set_server=latin5; 2CREATE DATABASE mysqltest1 DEFAULT CHARACTER SET cp1251; 3USE mysqltest1; 4CREATE DATABASE mysqltest2; 5SHOW CREATE DATABASE mysqltest1; 6Database Create Database 7mysqltest1 CREATE DATABASE `mysqltest1` /*!40100 DEFAULT CHARACTER SET cp1251 */ 8SHOW CREATE DATABASE mysqltest2; 9Database Create Database 10mysqltest2 CREATE DATABASE `mysqltest2` /*!40100 DEFAULT CHARACTER SET latin5 */ 11CREATE TABLE mysqltest2.t1 (a char(10)); 12SHOW CREATE TABLE mysqltest2.t1; 13Table Create Table 14t1 CREATE TABLE `t1` ( 15 `a` char(10) DEFAULT NULL 16) ENGINE=MyISAM DEFAULT CHARSET=latin5 17DROP TABLE mysqltest2.t1; 18ALTER DATABASE mysqltest2 DEFAULT CHARACTER SET latin7; 19CREATE TABLE mysqltest2.t1 (a char(10)); 20SHOW CREATE TABLE mysqltest2.t1; 21Table Create Table 22t1 CREATE TABLE `t1` ( 23 `a` char(10) DEFAULT NULL 24) ENGINE=MyISAM DEFAULT CHARSET=latin7 25DROP DATABASE mysqltest2; 26CREATE DATABASE mysqltest2 CHARACTER SET latin2; 27CREATE TABLE mysqltest2.t1 (a char(10)); 28SHOW CREATE TABLE mysqltest2.t1; 29Table Create Table 30t1 CREATE TABLE `t1` ( 31 `a` char(10) DEFAULT NULL 32) ENGINE=MyISAM DEFAULT CHARSET=latin2 33DROP DATABASE mysqltest2; 34USE mysqltest1; 35CREATE TABLE t1 (a char(10)); 36SHOW CREATE TABLE t1; 37Table Create Table 38t1 CREATE TABLE `t1` ( 39 `a` char(10) DEFAULT NULL 40) ENGINE=MyISAM DEFAULT CHARSET=cp1251 41DROP TABLE t1; 42CREATE TABLE t1 (a char(10)) DEFAULT CHARACTER SET latin1; 43SHOW CREATE TABLE t1; 44Table Create Table 45t1 CREATE TABLE `t1` ( 46 `a` char(10) DEFAULT NULL 47) ENGINE=MyISAM DEFAULT CHARSET=latin1 48DROP TABLE t1; 49CREATE TABLE t1 (a char(10)) 50DEFAULT CHARACTER SET latin1 COLLATE latin1_german1_ci; 51SHOW CREATE TABLE t1; 52Table Create Table 53t1 CREATE TABLE `t1` ( 54 `a` char(10) COLLATE latin1_german1_ci DEFAULT NULL 55) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci 56DROP TABLE t1; 57create table t1 (a char) character set latin1 character set latin2; 58ERROR HY000: Conflicting declarations: 'CHARACTER SET latin1' and 'CHARACTER SET latin2' 59create table t1 (a char) character set latin1 collate latin2_bin; 60ERROR 42000: COLLATION 'latin2_bin' is not valid for CHARACTER SET 'latin1' 61create database d1 default character set latin1 character set latin2; 62ERROR HY000: Conflicting declarations: 'CHARACTER SET latin1' and 'CHARACTER SET latin2' 63create database d1 default character set latin1 collate latin2_bin; 64ERROR 42000: COLLATION 'latin2_bin' is not valid for CHARACTER SET 'latin1' 65DROP DATABASE mysqltest1; 66CREATE DATABASE mysqltest2 DEFAULT CHARACTER SET latin7; 67use mysqltest2; 68ALTER DATABASE DEFAULT CHARACTER SET latin2; 69show create database mysqltest2; 70Database Create Database 71mysqltest2 CREATE DATABASE `mysqltest2` /*!40100 DEFAULT CHARACTER SET latin2 */ 72drop database mysqltest2; 73ALTER DATABASE DEFAULT CHARACTER SET latin2; 74ERROR 3D000: No database selected 75ALTER DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa DEFAULT CHARACTER SET latin2; 76ERROR 42000: Incorrect database name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' 77ALTER DATABASE `` DEFAULT CHARACTER SET latin2; 78ERROR 42000: Incorrect database name '' 79USE test; 80# 81# Start of 10.0 tests 82# 83# 84# MDEV-7387 Alter table xxx CHARACTER SET utf8, CONVERT TO CHARACTER SET latin1 should fail 85# 86CREATE DATABASE tmp DEFAULT CHARACTER SET latin5; 87USE tmp; 88CREATE TABLE t1 (a VARCHAR(10)) CHARACTER SET DEFAULT, CHARACTER SET utf8; 89ERROR HY000: Conflicting declarations: 'CHARACTER SET DEFAULT' and 'CHARACTER SET utf8' 90CREATE TABLE t1 (a VARCHAR(10)) CHARACTER SET utf8, CHARACTER SET DEFAULT; 91ERROR HY000: Conflicting declarations: 'CHARACTER SET utf8' and 'CHARACTER SET DEFAULT' 92CREATE TABLE t1 (a VARCHAR(10)) CHARACTER SET utf8, CHARACTER SET utf8; 93DROP TABLE t1; 94CREATE TABLE t1 (a VARCHAR(10)) CHARACTER SET DEFAULT, CHARACTER SET DEFAULT; 95DROP TABLE t1; 96CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET latin1, b VARCHAR(10) CHARACTER SET utf8); 97ALTER TABLE t1 CONVERT TO CHARACTER SET utf8, CHARACTER SET latin1; 98ERROR HY000: Conflicting declarations: 'CHARACTER SET utf8' and 'CHARACTER SET latin1' 99ALTER TABLE t1 CONVERT TO CHARACTER SET utf8, CHARACTER SET DEFAULT; 100ERROR HY000: Conflicting declarations: 'CHARACTER SET utf8' and 'CHARACTER SET DEFAULT' 101ALTER TABLE t1 CONVERT TO CHARACTER SET latin1, CHARACTER SET utf8; 102ERROR HY000: Conflicting declarations: 'CHARACTER SET latin1' and 'CHARACTER SET utf8' 103ALTER TABLE t1 CONVERT TO CHARACTER SET latin1, CHARACTER SET DEFAULT; 104ERROR HY000: Conflicting declarations: 'CHARACTER SET latin1' and 'CHARACTER SET DEFAULT' 105ALTER TABLE t1 CONVERT TO CHARACTER SET DEFAULT, CHARACTER SET utf8; 106ERROR HY000: Conflicting declarations: 'CHARACTER SET latin5' and 'CHARACTER SET utf8' 107ALTER TABLE t1 CONVERT TO CHARACTER SET DEFAULT, CHARACTER SET latin1; 108ERROR HY000: Conflicting declarations: 'CHARACTER SET latin5' and 'CHARACTER SET latin1' 109DROP TABLE t1; 110DROP DATABASE tmp; 111USE test; 112# 113# End of 10.0 tests 114# 115