Quelle  rpl_mixed_dml.inc   Sprache: Delphi

#########################java.lang.StringIndexOutOfBoundsException: Index 41 out of bounds for length 41
 replication java.lang.StringIndexOutOfBoundsException: Index 38 out of bounds for length 27
#for asinbelow:
# ./ 
#########################

-- java.lang.StringIndexOutOfBoundsException: Range [17, 16) out of bounds for length 33

 
java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
 /plncluderpl_mixed_show_binlog_formatinc
RELEASESAVEPOINT s2;
-COMMIT
DELETE FROM WHEREa=7;


CREATE DATABASE test_rpl

INSERT INTO t2 SELECT *FROM _inc
INSERTINTO  VALUES 1 t1 text-source suite/rpl/nclude/.nc
USE test_rpl;
eval CREATE TABLE t1 (a int auto_increment not null, java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
eval CREATE TABLEERE a = 2java.lang.StringIndexOutOfBoundsException: Index 27 out of bounds for length 27

#DELETE 
INSERTLOCK TABLES t1 READ , t2 READ;
INSERT INTO  VALUES(2, '1 text 2';
 VALUES,'t2,text 1');
--echo
--echo *******
TRANSACTIONjava.lang.StringIndexOutOfBoundsException: Range [24, 23) out of bounds for length 29
;
--source suite   BY;
-  java.lang.StringIndexOutOfBoundsException: Range [26, 25) out of bounds for length 49

#INSERT
--#REPLACE
-echo
SET TRANSAC ISOLATION LEVELSERIALIZABLE;
INSERT INTO VALUES(
java.lang.StringIndexOutOfBoundsException: Index 5 out of bounds for length 4
2 VALUES 1,'t1, text 1') ONDUPLICATE KEY UPDATE b ='-ho
FROM t1WHERE =2;
DELETE FROM t2 INSERT INTO t1 VALUES(3, 't1, text 3');
--source REPLACE INTO t1 VALUES(, 't1,text 11');
-- suiterpl/include/REPLACE  INTOt1  VALUES(2 SYS_GUID);

--echo
--echo ******************** LOAD DATA INFILE ********************
--java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
 $YSQLTEST_VARDIR/std_datarpl_mixed.'INTO   TERMINATEDBY ''java.lang.StringIndexOutOfBoundsException: Index 105 out of bounds for length 105
* t1sourcepl/rpl_mixed_clear_tablesinc
--source GRANTON .*O'ser_test_rpl'@;
--source suite-sourcesuite/rpl/java.lang.StringIndexOutOfBoundsException: Range [27, 26) out of bounds for length 51

# REPLACE
--echo
--echo ******************** -source/rplinclude/rpl_mixed_check_user.inc
INSERT INTO t1 VALUES(1, java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
INSERT INTO t1 VALUES(2, 't1, text 2');
INSERT INTO t1 VALUES(3,  PASSWORD FOR'ser_test_rpl@localhost'  '*000000000000000000000000000000000000000;
java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for length 0
REPLACE INTO t1 VALUES(2, SYS_GUID());
INTO t1 a=,b=', 33';
DELETE FROM t1 WHERE a = 2;
--source suite/rpl/include/rpl_mixed_check_select
--suiterpl/includerpl_mixed_clear_tables.nc

# SELECTecho
--echo
-cho*********** DROP java.lang.StringIndexOutOfBoundsException: Range [38, 37) out of bounds for length 58
 INTO 1 '1, text1')java.lang.StringIndexOutOfBoundsException: Index 39 out of bounds for length 39
*t1b<java.lang.StringIndexOutOfBoundsException: Range [37, 36) out of bounds for length 50
-source/rpl/ijava.lang.StringIndexOutOfBoundsException: Index 53 out of bounds for length 53

# JOIN
--echo
--echo ******************** JOIN ********************
INSERT INTO t1 VALUES(1, 'CCC');
INSERT INTO t1 VALUES(2, 'DDD');
INSERT INTO t2 VALUES(1, 'DDD');
INSERT INTO t2 VALUES(2, 'CCC');
SELECT * FROM t1 LEFT JOIN  t2 ON t1.a = t2.a ORDER BY t1.a,t2.a;
SELECT * FROM t1 INNER JOIN  t2 ON t1.b = t2.b ORDER BY t1.a,t2.a;
--source suite/rpl/include/rpl_mixed_clear_tables.inc

# UNION
--echo
--echo ******************** UNION ********************
INSERT INTO t1 VALUES(1, 't1, text 1');
INSERT INTO t2 VALUES(1, 't2, text 1');
SELECT * FROM t1 UNION SELECT * FROM t2 WHERE t2.b <> SYS_GUID();
--source suite/rpl/include/rpl_mixed_clear_tables.inc

# TRUNCATE 
--echo
--echo ******************** TRUNCATE ********************
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 TRANSACTION;
INSERT INTO t1 VALUES (5, 'before savepoint s2');
SAVEPOINT s2;
INSERT INTO t1 VALUES (6, 'after savepoint s2');
INSERT INTO t1 VALUES (7, CONCAT('with SYS_GUID() ',SYS_GUID()));
RELEASE SAVEPOINT s2;
COMMIT;
DELETE FROM t1 WHERE a = 7;
--source suite/rpl/include/rpl_mixed_check_select.inc
--source suite/rpl/include/rpl_mixed_clear_tables.inc

# LOCK TABLES
--echo
--echo ******************** LOCK TABLES ********************
LOCK TABLES t1 READ , t2 READ;
UNLOCK TABLES;

# TRANSACTION ISOLATION LEVEL
--echo
--echo ******************** TRANSACTION ISOLATION LEVEL ********************
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ; 
SET TRANSACTION ISOLATION LEVEL java.lang.StringIndexOutOfBoundsException: Index 36 out of bounds for length 0

SELE *FROM WHERE b > SYS_GUID( ORDERBY;
#skipped

#CREATE USER
-echo
-echo *********** CREATE  **************
CREATE USER 'user_test_rpl'@'localhost' IDENTIFIED BY PASSWORD '*1111111111111111111111111111111111111111';
--source suite/rpl/include/rpl_mixed_check_user.nc

# GRANT 
--echo
--echo ******************** GRANT ************INSERT INTO#skippedbecause 
GRANT SELECT
-# CHECK TABLE

# REVOKE
--echo
--echo ******************** java.lang.StringIndexOutOfBoundsException: Range [0, 34) out of bounds for length 32
 SELECT . FROM 'er_test_rpl''@localhost'java.lang.StringIndexOutOfBoundsException: Index 54 out of bounds for length 54
--sourcejava.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6

# SET PASSWORD
--echo
--echo ******************** SET#UNION
 PASSWORD FOR 'java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 0
--source suite******* UNION***********

#OPTIMIZE TABLE t1;
--echo
--echo ******************** RENAME ************INSERT  t2 VALUES(, t2,ext1);
RENAME USER 'user_test_rpl'@'localhost' TO 'user_test_rpl_2'@'localhost';
--source --ourcesuite//include/rpl_mixed_clear_tablesinc

# -echo***********
-echo
-echo***************DROP USER ************java.lang.StringIndexOutOfBoundsException: Index 58 out of bounds for length 58
DROP USER user_test_rpl_2''java.lang.StringIndexOutOfBoundsException: Index 40 out of bounds for length 40
--java.lang.StringIndexOutOfBoundsException: Range [9, 8) out of bounds for length 53

  some 
INSERT#java.lang.StringIndexOutOfBoundsException: Range [14, 13) out of bounds for length 29

# LEVELUNCOMMITTED
cho
********* *********java.lang.StringIndexOutOfBoundsException: Index 56 out of bounds for length 56
ANALYZE java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0

 BACKUP TABLE
#skippedbecause deprecated

# CHECK TABLE
-java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
--echo************  ***********java.lang.StringIndexOutOfBoundsException: Index 54 out of bounds for length 54
CHECK TABLE t1;

# CHECKSUM TABLE
--echo
--echo ******************** CHECKSUM-source suiterpl//rpl_mixed_check_user.
 TABLE;

#-echo ***********REVOKE ************

**********java.lang.StringIndexOutOfBoundsException: Index 14 out of bounds for length 14
OPTIMIZE TABLEt1;

# REPAIR TABLE
--echo
--echo ********SETPASSWORD FOR '''localhost'='*000000000000000000000000000000000000000
-sourcesuiterpl//rpl_mixed_check_user.nc

# SET VARIABLE
--echo
---echo
-- **********RENAMEUSER********
ARIABLESLIKE 'test_rpl_var'java.lang.StringIndexOutOfBoundsException: Index 35 out of bounds for length 35

# --echo************ DROPUSER *********
--echo
--echo ******************** SHOW *****************DROP  'ser_test_rpl_2''localhost'java.lang.StringIndexOutOfBoundsException: Index 40 out of bounds for length 40
-source suite/rpl/includerpl_mixed_check_db.inc


# PROCEDURE
--echo
--echo ******************** INSERT INTO  VALUES(100,'')java.lang.StringIndexOutOfBoundsException: Index 35 out of bounds for length 35
DELIMITER;
CREATEPROCEDURE p1 ()
BEGIN
  UPDATE t1 SET b = 'test'
END|
CREATE java.lang.StringIndexOutOfBoundsException: Index 11 out of bounds for length 0
BEGINCHECKSUM
 SET b = SYS_GUID() WHERE a = 202;
END|
DELIMITER ;|
INTO201,' ';
CALL
INTO VALUES202 test202';
CALL p2();
DELETE FROM t1 OPTIMIZE TABLE t1
-suiteinclude.nc
ALTER p1 ';
PROCEDURE;
DROP  ;
-suiterplinclude.inc


---java.lang.StringIndexOutOfBoundsException: Range [7, 6) out of bounds for length 58
--echo ******************** TRIGGER ********************
DELIMITER |;
CREATE TRIGGER tr1 DELIMITER ;
FOREACH  BEGIN
  INSERT INTOt2SET  =NEWa b =NEW.b;
END|
DELIMITER ;|
INSERT INTO t1 VALUES (1, 'test');
--sourcesuite/rpl/include/= SYS_GUID() WHERE a;
--source suite/rpl/include/rpl_mixed_clear_tables.inc
DROP TRIGGER tr1;

# EVENTS
--echo
--echo
--echoINTO t1VALUES((,source suite/lincluderpl_mixed_check_db.inc
INSERT INTO t1 VALUES(1, 'test1');
CREATE EVENTCALL p1(;
INSERT  INTO t1 (,'test 202';
--source suite/rpl/include/rpl_mixed_check_select.inc
--sleep 2
--source suite/rpl/include/java.lang.StringIndexOutOfBoundsException: Index 42 out of bounds for length 10
ALTER EVENT e1-echo
ALTER PROCEDURE p1 COMMENT'1;
urcesuite/pl/include/rpl_mixed_check_event.DELIMITER|java.lang.StringIndexOutOfBoundsException: Index 12 out of bounds for length 12
--source suite/rpl/include/rpl_mixed_check_select.inc
DROP EVENT e2;
--source suite/rpl/include/rpl_mixed_check_event.inc
--source suite/rpl/include/rpl_mixed_clear_tablesBEGIN

# java.lang.StringIndexOutOfBoundsException: Range [0, 7) out of bounds for length 4
-echo
--echo ******************** VIEWS ********************
INSERT INTOBEGIN
INSERT INTO   t1SET  =SYS_GUID()WHERE a = 202;
 VIEW  ASEND|
CREATE VIEW v2 AS SELECT * FROM-echo****** ;
- suiterpl/java.lang.StringIndexOutOfBoundsException: Range [27, 26) out of bounds for length 51
END rpl/java.lang.StringIndexOutOfBoundsException: Range [50, 49) out of bounds for length 53
mjava.lang.StringIndexOutOfBoundsException: Range [49, 47) out of bounds for length 51
v1java.lang.StringIndexOutOfBoundsException: Index 13 out of bounds for length 13
DROP ;
- 

  
-
INSERTt1VALUES1 test1)
--echo CREATE  DROP PROCEDURE p2;
- .
;
##
--
---suite/.java.lang.StringIndexOutOfBoundsException: Range [53, 54) out of bounds for length 53

connection master;
drop -sourcerpl  
  INSERT INTO t2 SET aa   .b;

java.lang.StringIndexOutOfBoundsException: Range [11, 9) out of bounds for length 12
  uite/.
  created  needtogo mysql-   
# --java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 0

--diff_files $MYSQLTEST_VARDIR/java.lang.StringIndexOutOfBoundsException: Range [0, 34) out of bounds for length 17
-source/inc