⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.124
Server IP:
50.28.103.30
Server:
Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software:
nginx/1.28.0
PHP Version:
8.3.12
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
t
/
View File Name :
ctype_create.test
#Get deafult engine value --let $DEFAULT_ENGINE = `select @@global.default_storage_engine` # # Test for various CREATE statements and character sets # # Check that the database charset is taken from server charset by default: # - Change local character_set_server variable to latin5. # - Create database with and without CHARACTER SET specification. # At the same time check fix for the # Bug#2151: # "USE db" with non-default character set should never affect # further CREATE DATABASEs. SET @@character_set_server=latin5; CREATE DATABASE mysqltest1 DEFAULT CHARACTER SET cp1251; USE mysqltest1; CREATE DATABASE mysqltest2; # # This should be cp1251 # SHOW CREATE DATABASE mysqltest1; # # Database "mysqltest2" should take the default latin5 value from # the server level. # Afterwards, table "d2.t1" should inherit the default latin5 value from # the database "mysqltest2", using database option hash. # SHOW CREATE DATABASE mysqltest2; CREATE TABLE mysqltest2.t1 (a char(10)); #Replace default engine value with static engine string --replace_result $DEFAULT_ENGINE ENGINE SHOW CREATE TABLE mysqltest2.t1; DROP TABLE mysqltest2.t1; # # Now we check if the database charset is updated in # the database options hash when we ALTER DATABASE. # ALTER DATABASE mysqltest2 DEFAULT CHARACTER SET latin7; CREATE TABLE mysqltest2.t1 (a char(10)); #Replace default engine value with static engine string --replace_result $DEFAULT_ENGINE ENGINE SHOW CREATE TABLE mysqltest2.t1; DROP DATABASE mysqltest2; # # Now we check if the database charset is removed from # the database option hash when we DROP DATABASE. # CREATE DATABASE mysqltest2 CHARACTER SET latin2; CREATE TABLE mysqltest2.t1 (a char(10)); #Replace default engine value with static engine string --replace_result $DEFAULT_ENGINE ENGINE SHOW CREATE TABLE mysqltest2.t1; DROP DATABASE mysqltest2; # # Check that table value uses database level by default # USE mysqltest1; CREATE TABLE t1 (a char(10)); #Replace default engine value with static engine string --replace_result $DEFAULT_ENGINE ENGINE SHOW CREATE TABLE t1; DROP TABLE t1; # # Bug#3255 # CREATE TABLE t1 (a char(10)) DEFAULT CHARACTER SET latin1; #Replace default engine value with static engine string --replace_result $DEFAULT_ENGINE ENGINE SHOW CREATE TABLE t1; DROP TABLE t1; CREATE TABLE t1 (a char(10)) DEFAULT CHARACTER SET latin1 COLLATE latin1_german1_ci; #Replace default engine value with static engine string --replace_result $DEFAULT_ENGINE ENGINE SHOW CREATE TABLE t1; DROP TABLE t1; # # Bug# # CREATE TABLE and CREATE DATABASE didn't fail in some cases # --error 1302 create table t1 (a char) character set latin1 character set latin2; --error 1253 create table t1 (a char) character set latin1 collate latin2_bin; --error 1302 create database d1 default character set latin1 character set latin2; --error 1253 create database d1 default character set latin1 collate latin2_bin; # # DROP DATABASE mysqltest1; # # Synatx: 'ALTER DATABASE' without db_name # CREATE DATABASE mysqltest2 DEFAULT CHARACTER SET latin7; use mysqltest2; ALTER DATABASE DEFAULT CHARACTER SET latin2; show create database mysqltest2; drop database mysqltest2; --error 1046 ALTER DATABASE DEFAULT CHARACTER SET latin2; # End of 4.1 tests --error ER_TOO_LONG_IDENT ALTER DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa DEFAULT CHARACTER SET latin2; --error 1102 ALTER DATABASE `` DEFAULT CHARACTER SET latin2;