-- source include/master-slave.inc

CREATE DATABASE viewdb;
use viewdb;

#
# VIEWs with national characters
#

CREATE TABLE initial_tü (cü CHAR);
CREATE SQL SECURITY INVOKER VIEW initial_vü   AS SELECT cü FROM initial_tü;
INSERT INTO initial_vü VALUES ('ü');
SELECT * FROM initial_vü;

save_master_pos;
connection slave;
sync_with_master;

--exec $MYSQL_DUMP viewdb --add-drop-table --flush-privileges  > $MYSQLTEST_VARDIR/tmp/i03_master.sql
--exec $MYSQL_DUMP_SLAVE viewdb --add-drop-table --flush-privileges  > $MYSQLTEST_VARDIR/tmp/i03_slave.sql