#######
# Purpose: testing the replication in mixed mode
# Requirements: define binlog format for mysqld as in example below:
# ./mysql-test-run.pl --mysqld=--binlog-format=mixed
#########################################

--source include/master-slave.inc

# Check MIXED on both master and slave
connection master;
--source suite/rpl/include/rpl_mixed_show_binlog_format.inc
connection slave;
--source suite/rpl/include/rpl_mixed_show_binlog_format.inc
connection master;


CREATE DATABASE test_rpl;

--echo
--echo ******************** PREPARE TESTING ********************
evalCREATE  t1(a not null  254) KEYa))ENGINE=engine_type;
eval CREATEeval  t2(  notnull, 254) KEY(a) java.lang.StringIndexOutOfBoundsException: Range [89, 88) out of bounds for length 102
eval t2(     char)  a) ejava.lang.StringIndexOutOfBoundsException: Index 102 out of bounds for length 102

# DELETE 
INSERT INTO t1 VALUES(1, 't1, text 1');
INSERT INTO t1 VALUES(2, 't1, text 2');
INSERT INTO t2 VALUES(1, 't2, text 1');
--echo
--echo ******************** DELETE *******
DELETEsuiteincludejava.lang.StringIndexOutOfBoundsException: Range [50, 49) out of bounds for length 53
 b java.lang.StringIndexOutOfBoundsException: Range [35, 34) out of bounds for length 37
- java.lang.StringIndexOutOfBoundsException: Range [18, 17) out of bounds for length 18
-INTOt1VALUES6 

#INSERT
--echo
--echo ******************** INSERT **********ce //
 s2t1WHERE 7;
CREATEDATABASE;
INSERT  t2 *_
 t2VALUES(,',-sourcesuite//java.lang.StringIndexOutOfBoundsException: Range [50, 49) out of bounds for length 53
 FROM t1 WHERE a = 2;
ERE a=2
--- ********java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
INTOt1VALUES2 ', ';

--echo
-- 2(1 t2 java.lang.StringIndexOutOfBoundsException: Range [35, 34) out of bounds for length 39
--java.lang.StringIndexOutOfBoundsException: Range [6, 7) out of bounds for length 6
 DATA $DELETE FROM t2 WHERE b <> SYS_GUID
SELECT*FROM t1 ORDERBY a
--- java.lang.StringIndexOutOfBoundsException: Range [16, 15) out of bounds for length 49
--source  

 
-echo
INSERT TION ;
INTOt1 java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
INSERT INTO t1 VALUES(2, ' INSERT INTO t (,'t1 KEY b  -java.lang.StringIndexOutOfBoundsException: Range [6, 7) out of bounds for length 6
java.lang.StringIndexOutOfBoundsException: Range [21, 6) out of bounds for length 39
 ( ' java.lang.StringIndexOutOfBoundsException: Range [36, 35) out of bounds for length 41
  ( )java.lang.StringIndexOutOfBoundsException: Index 38 out of bounds for length 38
  eval'YSQLTEST_VARDIRstd_data.' t1FIELDS' ;
DELETE FROM t1 WHERE a = 2;
--cerplincludejava.lang.StringIndexOutOfBoundsException: Range [50, 49) out of bounds for length 53
--source //nclude/java.lang.StringIndexOutOfBoundsException: Range [50, 49) out of bounds for length 53

# SELECT
--echo
--echo ******************** SELECT ********************
INSERT INTO t1
CT  t1<)  a
- 

##USER
--
-********* USER *********rpli
java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
  java.lang.StringIndexOutOfBoundsException: Range [10, 9) out of bounds for length 28
java.lang.StringIndexOutOfBoundsException: Index 8 out of bounds for length 8
INSERT INTO t2 VALUES(2
--echo********ON*FROM ujava.lang.StringIndexOutOfBoundsException: Range [41, 40) out of bounds for length 54
echo
---echo******java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0

 
--SETjava.lang.StringIndexOutOfBoundsException: Range [13, 12) out of bounds for length 91
****** *************
INSERT TABLE java.lang.StringIndexOutOfBoundsException: Index 18 out of bounds for length 18
INTO 1 , 1;
SELECT * FROM'java.lang.StringIndexOutOfBoundsException: Range [27, 26) out of bounds for length 73
-java.lang.StringIndexOutOfBoundsException: Range [9, 8) out of bounds for length 53

-
--- *******************
--echo *******************DROP USER''@localhost;
INSERT INTO t1 VALUES(1, 't1, text 1');
--source suite/rpl/include/rpl_mixed_check_select.inc
TRUNCATE t1;
--source suite/rpl/include/rpl_mixed_check_select.inc
--source suite/rpl/include/rpl_mixed_clear_tables.inc

# UPDATE 
--echo
--echo ******************** UPDATE ********************
INSERT INTO t1 VALUES(1, 't1, text 1');
INSERT INTO t2 VALUES(1, 't2, text 1');
UPDATE t1 SET b = 't1, text 1 updated' WHERE a = 1;
--source suite/rpl/include/rpl_mixed_check_select.inc
UPDATE t1, t2 SET t1.b = 'test', t2.b = 'test';
--source suite/rpl/include/rpl_mixed_check_select.inc
--source suite/rpl/include/rpl_mixed_clear_tables.inc

# DESCRIBE
--echo
--echo ******************** DESCRIBE ********************
DESCRIBE t1;
DESCRIBE t2 b;

# USE
--echo
--echo ******************** USE ********************
USE test_rpl;

# TRANSACTION 
--echo
--echo ******************** TRANSACTION ********************
START TRANSACTION;
INSERT INTO t1 VALUES (1, 'start');
COMMIT;
--source suite/rpl/include/rpl_mixed_check_select.inc
START TRANSACTION;
INSERT INTO t1 VALUES (2, 'rollback');
ROLLBACK;
--source suite/rpl/include/rpl_mixed_check_select.inc
START TRANSACTION;
INSERT INTO t1 VALUES (3, 'before savepoint s1');
SAVEPOINT s1;
INSERT INTO t1 VALUES (4, 'after savepoint s1');
ROLLBACK TO SAVEPOINT s1;
--source suite/rpl/include/rpl_mixed_check_select.inc
START ;
# SET 
java.lang.StringIndexOutOfBoundsException: Index 9 out of bounds for length 6
INSERT INTO t1 VALUES (6, 'after savepoint s2');
INSERT INTO t1 VALUES (7, CONCAT('with 
RELEASE SAVEPOINT s2;
COMMIT;
DELETE FROM t1 WHERE a = 7;
-source suite/rpl/include/rpl_mixed_check_select.inc
--source suite/rpl/include

# LOCK TABLES
--echo
--echo *-echo
LOCK-echo***-
#Prepring forsome following operations

#TRANSACTION ISOLATION LEVEL
--echo
--echo ********************
ETTRANSACTION ISOLATION  READ ;
SET
SET --echo ************ANALYZE ************
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

# XA
# skipped

# CREATE USER
--
--echo#BACKUP 
   
--source 

# GRANT 
--echo
- *********GRANT**********
GRANT SELECT ON *.* TO 'java.lang.StringIndexOutOfBoundsException: Index 37 out of bounds for length 15
-sourcesuite/include.nc

# CHECKSUM t1
--echo
-*********  **********
REVOKE SELECT 
--source ******** OPTIMIZE TABLE ********************

# SET PASSWORD
--echo
--echo ************OPTIMIZE java.lang.StringIndexOutOfBoundsException: Index 18 out of bounds for length 18
SET PASSWORD  user_test_rpl@  *000000000000000000000000000000000000000';
- /include.nc

#java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
-
-echo ***********   **************
SHOW V LIKE ';
--source suite/rpl/include/rpl_mixed_check_user.inc

# DROP
--echo
 *********   ************
USER'@;
--source suite/rpl/include/rpl_mixed_check_user.inc

# Prepring for some- rpl/java.lang.StringIndexOutOfBoundsException: Range [46, 45) out of bounds for length 49
t1 VALUES100,test)

# ANALYZE
--echo
--echo ************* |
CREATE java.lang.StringIndexOutOfBoundsException: Range [17, 16) out of bounds for length 22

# BACKUP TABLE
# skipped java.lang.StringIndexOutOfBoundsException: Index 12 out of bounds for length 4

# CHECK TABLE
--echo
--echo ******************** CHECK TABLE ********************
CHECK TABLE t1;

# CHECKSUM TABLE
--echo
--echo  UPDATE t1 java.lang.StringIndexOutOfBoundsException: Range [29, 15) out of bounds for length 45
java.lang.StringIndexOutOfBoundsException: Index 7 out of bounds for length 4

# INSERT   t1 VALUES(201 test201';
ho
-INSERT   t1 VALUES(202,'test 202'java.lang.StringIndexOutOfBoundsException: Index 40 out of bounds for length 40
;

# --source/rpl/include/rpl_mixed_check_selectinc
--echo PROCEDURE COMMENT '1'
--echoDROP  p1
REPAIR TABLE t1;

# SET VARIABLE
--echo
--echo ******************** SET VARIABLE ********************
SET @test_rpl_var = 1;
SHOW VARIABLES LIKE 'test_rpl_var';

# SHOW
--echo
--echo *****************DROP PROCEDUREp2;
--source ///rpl_mixed_clear_tablesinc


# TRIGGER
--echo
-echo ******************** PROCEDURE ********************
|
CREATE ROW
BEGIN
  UPDATE     a=.,b=java.lang.StringIndexOutOfBoundsException: Index 42 out of bounds for length 42
END|
CREATE -source suite rpl//pl_mixed_check_select.inc
BEGIN
  UPDATE t1 SET b = = 202java.lang.StringIndexOutOfBoundsException: Index 45 out of bounds for length 45
END|
java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
   t1 201-///java.lang.StringIndexOutOfBoundsException: Range [46, 45) out of bounds for length 49
)
   VALUES202 202'java.lang.StringIndexOutOfBoundsException: Index 40 out of bounds for length 40
CALL p2
java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
 -
PROCEDURE  ''
--so //;
 PROCEDUREp2-java.lang.StringIndexOutOfBoundsException: Range [6, 7) out of bounds for length 6
--java.lang.StringIndexOutOfBoundsException: Range [7, 6) out of bounds for length 34

# TRIGGER
--CREATEv1java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 4
- *****DELIMITER;
INSERT  INTO VALUES(-ourcesuite///.inc
CALL p1(;
   
   ()java.lang.StringIndexOutOfBoundsException: Index 10 out of bounds for length 10
osource//includerpl_mixed_check_select.inc
DELIMITER ;|
INSERT INTO t1 ALTER PROCEDURE   '1ixed_check_view.
--suite/rpl/ncludeDROP VIEWv1;
--source suite/rpl/include/rpl_mixed_clear_tables.inc
DROP TRIGGER tr1

#EVENTS
--echo
--#BINLOGEVENTS
--echo
 INTO  VALUES(1,'test1';
 EVENTe1ON
---sourceinclude/show_binlog_eventsinc
--source suite/sync_slave_with_master;
--java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for length 0
-source suite/rpl/nclude/rpl_mixed_check_selectinc
ALTERDELIMITER |
--sleep TRIGGER tr1 BEFOREINSERT  t1
--java.lang.StringIndexOutOfBoundsException: Index 5 out of bounds for length 0
- suite//FORjava.lang.StringIndexOutOfBoundsException: Range [9, 8) out of bounds for length 18
DROPjava.lang.StringIndexOutOfBoundsException: Range [10, 9) out of bounds for length 12
#the# the test/include/rpl_mixed_check_selectinc
-#willbe . Youwill  to  tothe mysql-estdir anddiff

# VIEWS
--echo
--echo ********java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
INSERT INTO t1 VALUES(1 'test1');
INSERT-- includerpl_end.inc
CREATE VIEW v1 java.lang.StringIndexOutOfBoundsException: Range [0, 17) out of bounds for length 0
CREATE VIEWv2  SELECT*FROM  WHEREb< SYS_GUID(;
--source suite/rpl/include/rpl_mixed_check_view.inc
ALTER VIEW v1 AS SELECT * FROM-echo ************* EVENTS*****( 'est1';
--source suite/rpl/include/rpl_mixed_check_view.nc
DROP VIEW v1;
DROP VIEW v2;
----sourcesuite/pl/ncluderpl_mixed_check_event.nc

# BINLOG EVENTS
--echo
--echo
-************ SHOW BINLOG EVENTS ***********
--java.lang.StringIndexOutOfBoundsException: Index 9 out of bounds for length 9
sync_slave_with_master
#ALTER   RENAME TOe2java.lang.StringIndexOutOfBoundsException: Index 28 out of bounds for length 28
sourcesuite/rpl//rpl_mixed_check_selectinc
--DROP EVENTe2;

connectionmaster
drop -source suite/rpl/include/rpl_mixed_clear_tables.inc
java.lang.StringIndexOutOfBoundsException: Index 15 out of bounds for length 0

# Let's compare. Note: If  t1(, ''java.lang.StringIndexOutOfBoundsException: Index 34 out of bounds for length 34
#   diff  statement   
# will be created. You will need SELECT*t1b<(java.lang.StringIndexOutOfBoundsException: Index 57 out of bounds for length 57
 your   see is

--diff_files $- java.lang.StringIndexOutOfBoundsException: Range [27, 26) out of bounds for length 51
-#