##################################################
# Author: Jeb
# Date: 14-12-2006
# Purpose: Test case for :Bug #23997 Replication 
#          fails between Linux master and OS X 
#          slave using mixed case names
###################################################

--disable_warnings
--disable_query_log
source include/master-slave.inc;
DROP TABLE IF EXISTS TestMe.TestNumberOne;
DROP DATABASE IF EXISTS TestMe;
--enable_query_log
--enable_warnings

--echo ** Master Values ** 
show variables like '%case%';
connection slave;
STOP SLAVE;
--echo ** Slave Values **
show variables like '%case%';
connection master;
--echo

--echo ** Create Database on Master **
CREATE DATABASE TestMe;
use TestMe;
--echo

--echo ** Create Tables on Master **
CREATE TABLE TestNumberOne (TestID int AUTO_INCREMENT KEY,
                            TestChar varchar(10) not null);
--echo

--echo ** Show Tables on Master **
show tables;
--echo


connection slave;
--echo ** Show databases on The Slave **
show databases;
--echo

--echo ** Start Slave **
slave start;
--sleep 5
show databases;
connection master;
--sync_slave_with_master
--echo

--echo ** Show databases on The Slave **
show databases;
--echo

use TestMe;

--echo ** Show Tables on Slave **
show tables;
--echo

connection master;
--echo ** Insert Data on Master **
--disable_query_log
use TestMe;
let $i = 20;
while ($i)
{
  INSERT INTO TestNumberOne VALUES (NULL,'abcdefghij');
  dec $i;
}
--enable_query_log
--echo

--echo ** Select Count from Master **
SELECT COUNT(*) FROM TestNumberOne;
--echo

--sync_slave_with_master
use TestMe;
--echo ** Select Count from slave **
SELECT COUNT(*) FROM TestNumberOne;
--echo

connection master;
--echo ** Insert Data on Master **
--disable_query_log
use TestMe;
let $i = 20;
while ($i)
{
  INSERT INTO TestNumberOne VALUES (NULL,'abcdefghij');
  dec $i;
}
--enable_query_log
--echo

--echo ** Select Count from Master **
SELECT COUNT(*) FROM TestNumberOne;
--echo

--sync_slave_with_master
use TestMe;
--echo ** Select Count from slave **
SELECT COUNT(*) FROM TestNumberOne;
--echo

connection master;



DROP TABLE IF EXISTS TestMe.TestNumberOne;
DROP DATABASE IF EXISTS TestMe;
--sync_slave_with_master