You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
57 lines
2.3 KiB
57 lines
2.3 KiB
5 months ago
|
--source include/big_test.inc
|
||
|
|
|
||
|
|
--disable_query_log
|
||
|
|
CALL mtr.add_suppression("--character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.");
|
||
|
|
--enable_query_log
|
||
|
|
|
||
|
|
let BASEDIR= `select @@basedir`;
|
||
|
|
let DDIR= $MYSQL_TMP_DIR/dd_bootstrap_test;
|
||
|
|
let MYSQLD_LOG= $MYSQL_TMP_DIR/server.log;
|
||
|
|
let extra_args= --no-defaults --innodb_dedicated_server=OFF --log-error=$MYSQLD_LOG --secure-file-priv="" --loose-skip-auto_generate_certs --loose-skip-sha256_password_auto_generate_rsa_keys --skip-ssl --basedir=$BASEDIR --lc-messages-dir=$MYSQL_SHAREDIR;
|
||
|
|
let BOOTSTRAP_SQL= $MYSQL_TMP_DIR/tiny_bootstrap.sql;
|
||
|
|
|
||
|
|
--echo # Preparation: Shut server down.
|
||
|
|
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
||
|
|
--shutdown_server
|
||
|
|
--source include/wait_until_disconnected.inc
|
||
|
|
|
||
|
|
write_file $BOOTSTRAP_SQL;
|
||
|
|
CREATE SCHEMA test;
|
||
|
|
EOF
|
||
|
|
|
||
|
|
--echo # 1 First start the server with --initialize and --lower-case-table-names=1.
|
||
|
|
--echo # We need to make sure l-c-t-n is set during database initialization.
|
||
|
|
--echo # Otherwise the mysql.tables.name do not pick right collation.
|
||
|
|
--echo # This test also requires to be run with --character-set-server=utf8
|
||
|
|
--exec $MYSQLD $extra_args --initialize-insecure --datadir=$DDIR --init-file=$BOOTSTRAP_SQL --lower-case-table-names=1 --character-set-server=utf8
|
||
|
|
|
||
|
|
--echo # 2 Restart the server against DDIR
|
||
|
|
--exec echo "restart: --datadir=$DDIR --character-set-server=utf8 --no-console --log-error=$MYSQLD_LOG" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
||
|
|
--enable_reconnect
|
||
|
|
--source include/wait_until_connected_again.inc
|
||
|
|
|
||
|
|
#
|
||
|
|
# Bug#25830 SHOW TABLE STATUS behaves differently depending on table name
|
||
|
|
#
|
||
|
|
set names utf8;
|
||
|
|
create table `Ö` (id int);
|
||
|
|
show tables from test like 'Ö';
|
||
|
|
show tables from test like 'ö';
|
||
|
|
drop table `Ö`;
|
||
|
|
|
||
|
|
--echo # Shut server down.
|
||
|
|
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
||
|
|
--shutdown_server
|
||
|
|
--source include/wait_until_disconnected.inc
|
||
|
|
|
||
|
|
--echo #
|
||
|
|
--echo # Cleanup: Restarting the server against default datadir.
|
||
|
|
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
||
|
|
--enable_reconnect
|
||
|
|
--source include/wait_until_connected_again.inc
|
||
|
|
|
||
|
|
#Cleanup
|
||
|
|
--force-rmdir $DDIR
|
||
|
|
--remove_file $MYSQLD_LOG
|
||
|
|
--remove_file $BOOTSTRAP_SQL
|