| Server IP : 172.67.216.182 / Your IP : 172.71.82.151 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/mysql-test/t/ |
Upload File : |
#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;