Quelle binlog_row_img.result Sprache: Lisp

ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;

#
#
SET binlog_row_image = "FULL_NODUP";
CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 varchar(100),
c3 INT DEFAULT 1000, c4 TEXT);
CREATE TABLE t2 (c1 INT, c2 char(100), c3 INT DEFAULT 1000, c4 TEXT);
FLUSH BINARY LOGS;

##########################################################FULL_NODUP mode worksexpected
java.lang.StringIndexOutOfBoundsException: Range [20, 18) out of bounds for length 31
#######################################

INSERT INTO t1 VALUES(1, "INSERT INTO t1 VALUES(1, "insert_to_t1n1 COLLATE latin1_swedish_ci
(",2repeat( 20)))java.lang.StringIndexOutOfBoundsException: Index 40 out of bounds for length 40
( 20)java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
t1() VALUES(4);
UPDATE #binlog_row_image  FULL_NODUP
###########################################java.lang.StringIndexOutOfBoundsException: Index 73 out of bounds for length 73
DELETE FROM t1 WHERE c1 =3  INT DEFAULT 1000, c4 TEXT;

# Verify that rows events are binlogged as expeced.

/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
INSERT INTO()VALUES()
UPDATE   c2= "only_c2_changed"
TRANSACTION

#>INSERT  t1VALUES(,"nsert_to_t1",1 repeat'' 20)),
", 2, repeat(a' 20))
#Q> (3, "java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
# INTO`test`.t1`
### SET
###   @1=1
##' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */Q 2 i" 2,repeat'' 20),
##  3= /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */   2'' * VARSTRING(100) meta=100 nullable=1 is_null=0 */#  31/
##
##SET
###   @1=2 /* INT meta=0 nullable=0 is_null=0 */
###   @##   @='nsert_to_t1'
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */##  4='aaaaaaaaaaaaaaaaaaaa /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
##``.`t1
####3
##############=/
##java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
3 * INT meta=0 nullable=1 is_null=0 */
##'
# Number of rows: 3
/*!\C latin1 *//*!*/;of java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
COMMIT
/*!*/;
START#UPDATE`.1
/*!*/;#java.lang.StringIndexOutOfBoundsException: Range [9, 10) out of bounds for length 9
(#@=/* INT meta=0 nullable=1 is_null=0 */
###java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
### SET
###   @1=4 /* INT meta=0 nullable=0 is_null=0 */#   2' VARSTRING()
#   @NULL/* VARSTRING(100) meta=100 nullable=1 is_null=1 */
#   3#   1 /* INT meta=0 nullable=0 is_null=0 */
##INSERT `##@2/ INT 0= 0/
# Number of ## SET
OMMIT
/*!*/;
START java.lang.StringIndexOutOfBoundsException: Index 8 out of bounds for length 7
/*!*/;
#Q##   @4E`.`
#  `est.t1`
##
#@1/
###@='nsert_to_t1 /* VARSTRING(100) meta=100 nullable=1 is_null=0 */ @= * =0== /
#@= /* INT meta=0 nullable=1 is_null=0 */
# @=#
#SET
##   2' * VARSTRING(100) meta=100 nullable=1 is_null=0 */
`tjava.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 22
### WHERE
@ * INT meta=0 nullable=0 is_null=0 */ =java.lang.StringIndexOutOfBoundsException: Index 57 out of bounds for length 57
###   @2='# Number of rowsjava.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
/* INT meta=0 nullable=1 is_null=0 */
# @''*=nullable  /
#####java.lang.StringIndexOutOfBoundsException: Range [11, 10) out of bounds for length 22
#   @='##= /* VARSTRING(100) meta=100 nullable=1 is_null=0 */#@=/
# #   @2=NULL VARSTRING00 100=java.lang.StringIndexOutOfBoundsException: Range [61, 59) out of bounds for length 64
##
###   @1=3##@=_ /* BLOB/TEXT meta=2 nullable=1 is_null=0 */ ofjava.lang.StringIndexOutOfBoundsException: Range [17, 16) out of bounds for length 19
##
#@3
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
##SET
###   @2#   4'java.lang.StringIndexOutOfBoundsException: Range [31, 30) out of bounds for length 75
### UPDATE `##@'3'java.lang.StringIndexOutOfBoundsException: Index 68 out of bounds for length 68
#
#@4*   =/
###   @2=NULL /* VARSTRING(100) meta=100 nullable=1 is_null=1 */#   2#  ='/* VARSTRING(100) meta=100 nullable=1 is_null=0 */
##
# @=/
## SET
###  4c3_c4_changed*
Numberof  java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
COMMIT
/*!*/;#@=
##SET
/*!*/;
t1c3=,=""
### UPDATE `test`.`t1`
### WHERE
#@1
###   @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
#   31 *INTmeta=nullable## 2'
#   4=java.lang.StringIndexOutOfBoundsException: Range [31, 30) out of bounds for length 75
##
#java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
#  4'*
##@= /* INT meta=0 nullable=0 is_null=0 */
### WHERE
##@=2 /* INT meta=0 nullable=0 is_null=0 */
###   @2='###   @4=NULL /* BLOB# @1java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
###   @3=2/
###   4'# of  java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
D;
#Endof  file
##  4'' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
##UPDATE`.t1`
##WHERE
## LOGS
#
####  no
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
#SET
##@= /
###   @4='c3_c4_changedjava.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
##UPDATE`est.t1`
### WHERE( insert_to_t2 ,(a,20))
####(,,,',);
###   @2=only_c2_changed'/
##  31000 /* INT meta=0 nullable=1 is_null=0 */
# @=y_c2_changed /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
### SET
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
java.lang.StringIndexOutOfBoundsException: Index 75 out of bounds for length 68
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q>DELETEFROMt1 WHERE  =1
### UPDATE SET ,c4 ;
### WHERE
###   @1=1 /* INT meta=0 nullable=0 is_null=0 */##   4'c3_c4_changed'/ BLOBTEXT meta= nullable= is_null0*
###   ##  1=3 /* INT meta=0 nullable=0 is_null=0 */
#####  2t2  >;
##  @='3c4_changed'/* BLOB/TEXT meta=2 nullable=1 is_null=0 */
#
COMMIT
/*!*/;
# Verifyrows .
#Endof logfile
/* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;#UPDATE`test.t1`
##;

     .
    fulllable1=*
tablehas ### INSERT INT ``t`

INSERT INTO t2 java.lang.StringIndexOutOfBoundsException: Index 21 out of bounds for length 19
(2, "java.lang.StringIndexOutOfBoundsException: Index 16 out of bounds for length 6
(3,"insert_to_t2", 3,repeat# @1/
INSERT  (c1VALUES
UPDATE t2##INSERTINTO``**;
UPDATE t2 SET#SET
DELETE QDELETEFROMt1  =java.lang.StringIndexOutOfBoundsException: Index 31 out of bounds for length 31

    events arebinlogged as expeced

/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;#@''/
DELIMITER
# Warning: this binlog is either ##   31java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48

/*!*/;
#Q> java.lang.StringIndexOutOfBoundsException: Index 8 out of bounds for length 6
#Q (,##INSERT  test.java.lang.StringIndexOutOfBoundsException: Index 27 out of bounds for length 27
#Q (,i/
### INSERT INTO `test`.`t2`
### /
#   11/
###   @2='java.lang.StringIndexOutOfBoundsException: Index 20 out of bounds for length 18
#   31# t2 nokey.

### INSERT INTO `test`.`t2java.lang.StringIndexOutOfBoundsException: Index 26 out of bounds for length 21
##SET
###   @1=INSERT INTO t2java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
#
###   t2()4)
# @='/ TEXT INSERT  t2c1 ()java.lang.StringIndexOutOfBoundsException: Index 29 out of bounds for length 29
### INSERT INTO `test`.`t2`
## ET
##   @=3 /* INT meta=0 nullable=1 is_null=0 */
##@= * STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3= /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */DELIMITER/!/
# Number  rows java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
/*!\C latin1 *//*!*/;java.lang.StringIndexOutOfBoundsException: Range [6, 7) out of bounds for length 6
COMMIT
/*!*/;
START TRANSACTION/*!*/;
/*!*/;
#Q> INSERT /
# Q 3 ",epeat(' )java.lang.StringIndexOutOfBoundsException: Index 43 out of bounds for length 43
####
### SET= * 0=0*java.lang.StringIndexOutOfBoundsException: Index 49 out of bounds for length 48
###   @2##  #   2=insert_to_t2/()= 1is_null /
###   @3=1000 ##@=##   @2='only_c2_changed100 5124nullable =*
###   @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */#   4'java.lang.StringIndexOutOfBoundsException: Index 21 out of bounds for length 7
# Number of ###   @1=2 /* IN#@=/
COMMIT
/*!*/;
TRANSACTION
**;
#>UPDATE  SETc2= #@=/
### UPDATE##  2''/
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
#   @=
##  @= /* INT meta=0 nullable=1 is_null=0 */
###   @='/
### SET
###   #Numberof rows #   =
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
##@= /* INT meta=0 nullable=1 is_null=0 */
#java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
### ## INSERT`est``2java.lang.StringIndexOutOfBoundsException: Index 27 out of bounds for length 27
### ###   @1=#@'/
###   @1
###   #
###   1=/* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa#   33/
##SET
# meta0nullable1 0*
'java.lang.StringIndexOutOfBoundsException: Index 76 out of bounds for length 76
###/
#   4'
### UPDATE#  ```2`
#####   @2= STRING(100) meta=65124 nullable=1 is_null=1 */
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */#  @3#  ='
# 2'
#####  11
'
#####   @2='  @2='only_c2_changed
#   31000 /* INT meta=0 nullable=1 is_null=0 */
##  2''
###   @3=3 /* INT meta=0 nullable=1 is_null=0 */
#   @='aaaaaaaaaaaaaaaaaaa'/* BLOB/TEXT meta=2 nullable=1 is_null=0 */
`.##@= /* INT meta=0 nullable=1 is_null=0 */
## java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
###   @1=4# ```2`
##   11*=nullable  java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
#   =/
###@=
#SET
###   @1=4 /* INT meta=0 nullable=1 is_null=0 */
####  `est.t2java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 22
#   ##13/INTmeta=10*
##@=only_c2_changed
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> #   =
### UPDATE `test`.`#   @='/* BLOB/TEXT meta=2 nullable=1 is_null=0 */#   31000/* INT meta=0 nullable=1 is_null=0 */
### java.lang.StringIndexOutOfBoundsException: Index 8 out of bounds for length 7
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
##  java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
#   @3##@ * BLOB/TEXT meta=2 nullable=1 is_null=1 */
##   33java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
### SET
# #Q> UPDSET=1   c3_c4_changed
#####  13
# @1java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
###
###  @# t.2`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
###   @2###@=
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
#@' BLOB/= ==*
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
#   = /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
#   @=1java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
#   4c_java.lang.StringIndexOutOfBoundsException: Index 68 out of bounds for length 68
##UPDATE`est`#   3
java.lang.StringIndexOutOfBoundsException: Range [10, 9) out of bounds for length 9
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed##@= /* INT meta=0 nullable=1 is_null=0 */
#   4'java.lang.StringIndexOutOfBoundsException: Index 29 out of bounds for length 6
#@='/* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
#  = /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed##   @ /* INT meta=0 nullable=1 is_null=0 */
#@= *INT meta= = = #3 *java.lang.StringIndexOutOfBoundsException: Range [23, 22) out of bounds for length 48
#4c_#UPDATE``java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 22
UPDATE `est.`2#
##   14 /* INT meta=0 nullable=1 is_null=0 */
###  #@ /* INT meta=0 nullable=1 is_null=0 */
###   4'' * BLOB/TEXT meta=2 nullable=1 is_null=0 */
##umberof 2
java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
##
# offile
ROLLBACK/
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */#UPDATE/
#   @'_4'/
# Number of rows#   2''/
COMMIT
/*!*/;
START TRANSACTION
**;
Q  FROMt2  c1>2
### DELETE#   =/
### WHERE
@13/
###   2'/STRING100= 1=/
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */ c3_c4_changed'/
#DELETEFROM e``
### WHERE
###   @1###java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
#  2'  100)java.lang.StringIndexOutOfBoundsException: Range [48, 46) out of bounds for length 76
#@= * INT meta=0 nullable=1 is_null=0 */
###   @4='INTO
# Number of rows: 2
OMMIT
/*!*/;#   @1/
DELIMITER ;
  file
t1c)(;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
t1t2;
#
# MINIMAL modet1SET  ,="_"
#
  "INIMAL;
CREATE TABLEjava.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
c3 INT DEFAULT 1000, /*!*/;
java.lang.StringIndexOutOfBoundsException: Range [13, 12) out of bounds for length 69
FLUSH BINARY LOGS;

########### End/*!*/;
  = MINIMAL
#Q 2 ',)java.lang.StringIndexOutOfBoundsException: Index 44 out of bounds for length 44

INSERT INTO t1 VALUES(1DROP TABLE ,t2
(2, "insert_to_t1"#worksas
(3 @= /* INT meta=0 nullable=0 is_null=0 */ =""
INSERT INTO t1(c1#CREATE  1java.lang.StringIndexOutOfBoundsException: Range [35, 31) out of bounds for length 53
UPDATE ,TEXT
UPDATE  SET c3=1   /* BLOBTEXT===/
DELETE FLUSH BINAR ;

  rows     .

50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
ELIMITER/
##java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
CTION
/*!*/;
Q>INSERT /* INT meta=0 nullable=1 is_null=0 */ #########   =",' );
.`
#QUPDATE   c2  o"java.lang.StringIndexOutOfBoundsException: Index 37 out of bounds for length 37
##INSERT INTOest.1
### SET
#java.lang.StringIndexOutOfBoundsException: Range [7, 6) out of bounds for length 28
###   @2='' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */#3=/* INT meta=0 nullable=1 is_null=0 */
###
/
*
java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
#
###   @#t1() java.lang.StringIndexOutOfBoundsException: Index 25 out of bounds for length 17
## /*!*/;
###
# #1=
#Number ##INTO `1`
###   @1=3 /* INT meta=0 nullable=0 is_null=0 */
#  2'java.lang.StringIndexOutOfBoundsException: Range [23, 22) out of bounds for length 74
#   #  = "
### `est.t`
#umberofrows:
/*!\C latin1 *//*!*/;#
#12java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
/*!*/;
TART
/*!*/;
VALUES4java.lang.StringIndexOutOfBoundsException: Index 32 out of bounds for length 32
## ###   1 /* INT meta=0 nullable=0 is_null=0 */
#SET
###@''
#Number of #t``1

/*!*/;
START
/*!*/;### INSERT INTO `test`.`t1`/*!*/java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
Q  SET ="nly_c2_changed"
##>#/java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
##WHERE
###   @1=1 /* INT meta=0 nullable=0 is_null=0 */COMMIT#@=/* INT meta=0 nullable=0 is_null=0 */java.lang.StringIndexOutOfBoundsException: Index 8 out of bounds for length 1
#C/!;
#java.lang.StringIndexOutOfBoundsException: Index 16 out of bounds for length 6
### #Q> UPDATE c3 /*!*/;
#
#
#
#@=only_c2_changed'
##UPDATEtest``t1`
# WHERE
#
#
###   1#  2java.lang.StringIndexOutOfBoundsException: Range [26, 25) out of bounds for length 77
#
######SET
##@#test.java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 22
##2'java.lang.StringIndexOutOfBoundsException: Range [26, 25) out of bounds for length 77
###   @#UPDATE `#3 * INT meta=0 nullable=1 is_null=0 */
## #   4=java.lang.StringIndexOutOfBoundsException: Index 13 out of bounds for length 9
#@java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
/*!*/;
TARTTRANSACTION( =11*java.lang.StringIndexOutOfBoundsException: Index 65 out of bounds for length 64
/*!*/;
# WHERE
##t1java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 22
# WHERE
##SET
#java.lang.StringIndexOutOfBoundsException: Index 7 out of bounds for length 7
###   @3=###WHERE
##@=java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
##START@2'java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
#java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
  *
### SET
##31
###   @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
#####
##   ='*VARSTRING()100
###   @1#   =###   @3=1 /* INT meta=0 nullable=1 is_null=0 */ ;
# SET
`java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 22
d * BLOB/TEXT meta=2 nullable=1 is_null=0 */
# `testjava.lang.StringIndexOutOfBoundsException: Range [17, 5) out of bounds for length 18
java.lang.StringIndexOutOfBoundsException: Range [9, 10) out of bounds for length 9
##  1  java.lang.StringIndexOutOfBoundsException: Range [23, 22) out of bounds for length 60
#
##
##@'3java.lang.StringIndexOutOfBoundsException: Range [24, 23) out of bounds for length 68
of :3 java.lang.StringIndexOutOfBoundsException: Range [18, 17) out of bounds for length 40
##
/*!*/;java.lang.StringIndexOutOfBoundsException: Range [14, 13) out of bounds for length 37
START TRANSACTION
/*!*/;java.lang.StringIndexOutOfBoundsException: Range [6, 3) out of bounds for length 6
Q FROM##HERE
##   = *NTevents asjava.lang.StringIndexOutOfBoundsException: Index 51 out of bounds for length 51
##WHERE
#
# #@'java.lang.StringIndexOutOfBoundsException: Range [24, 23) out of bounds for length 68
java.lang.StringIndexOutOfBoundsException: Range [8, 6) out of bounds for length 6
/*!*/;
java.lang.StringIndexOutOfBoundsException: Range [6, 4) out of bounds for length 6
java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 17
> DELETE FROM t1 WHERE c1
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
LUSHBINARY#WHERE

has key.
java.lang.StringIndexOutOfBoundsException: Range [4, 4) out of bounds for length 0
C

DELIMITER1 /* INT meta=0 nullable=1 is_null=0 */
( repeat,)
(3,INTO t2# /
INSERT INTO t2# java.lang.StringIndexOutOfBoundsException: Range [7, 8) out of bounds for length 7
UPDATE t2 SET#@= /* STRING(100) meta=65124 nullable=1 is_null=0 */
t2=,   java.lang.StringIndexOutOfBoundsException: Range [42, 41) out of bounds for length 43
DELETEWHERE java.lang.StringIndexOutOfBoundsException: Range [24, 23) out of bounds for length 28

# Verify#java.lang.StringIndexOutOfBoundsException: Index 7 out of bounds for length 7

/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
/*!*/;
rning#  =/* INT meta=0 nullable=1 is_null=0 */
has
/*!*/;
Q    java.lang.StringIndexOutOfBoundsException: Index 23 out of bounds for length 0
#>2,"java.lang.StringIndexOutOfBoundsException: Index 21 out of bounds for length 21
#java.lang.StringIndexOutOfBoundsException: Range [6, 5) out of bounds for length 17
### INSERT INTO `NSERTQ #>INTOc1 )
java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 7
###   ### SE1   =0   java.lang.StringIndexOutOfBoundsException: Range [44, 43) out of bounds for length 48
# #@000* INT meta=0 nullable=1 is_null=0 */
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
#   @''/
### 0003SET@##   @4='aaaaaaaaaaaaaaaaaaaa
### ### SET iseither use  closed properlyjava.lang.StringIndexOutOfBoundsException: Index 67 out of bounds for length 67
###   ##  @2/* INT meta=0 nullable=1 is_null=0 */ java.lang.StringIndexOutOfBoundsException: Range [11, 10) out of bounds for length 40
java.lang.StringIndexOutOfBoundsException: Index 73 out of bounds for length 73
###   #
#   #@ajava.lang.StringIndexOutOfBoundsException: Range [32, 30) out of bounds for length 75
# java.lang.StringIndexOutOfBoundsException: Range [11, 10) out of bounds for length 27
###>(,"nsert_to_t2, , (a'
##> # ( java.lang.StringIndexOutOfBoundsException: Range [22, 21) out of bounds for length 43
# 2'java.lang.StringIndexOutOfBoundsException: Range [24, 22) out of bounds for length 73
###   @3=3 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
java.lang.StringIndexOutOfBoundsException: Index 73 out of bounds for length 19
/*!\C latin1 *//*!*/;

/*!*/;
START TRANSACTION# WHERE INTO`java.lang.StringIndexOutOfBoundsException: Range [22, 21) out of bounds for length 27
/*!*/;/*!*/;
Q java.lang.StringIndexOutOfBoundsException: Range [11, 10) out of bounds for length 32
# .`
### SET
##  1= /* INT meta=0 nullable=1 is_null=0 */
#   2NULL * STRING(100) meta=65124 nullable=1 is_null=1 */
#   31000 #  t```
###   @4#java.lang.StringIndexOutOfBoundsException: Index 7 out of bounds for length 7
# Number of rows: 1

/*!*/;

/*!*/;
#Q> ###   @4=java.lang.StringIndexOutOfBoundsException: Range [0, 30) out of bounds for length 19
# t``2
##OMMIT
###   @1=###1 /* INT meta=0 nullable=1 is_null=0 */
##@2''/
=
#   4'aaaaaaaaaaaaaaaaaaa *##   @3=3 /* INT meta=0 nullable=1 is_nulljava.lang.StringIndexOutOfBoundsException: Index 49 out of bounds for length 48
##SET
##   @13java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
#@only_c2_changed'
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */##`est`.#   2=##@=/java.lang.StringIndexOutOfBoundsException: Index 57 out of bounds for length 57
#### /
##UPDATE`#@4java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
### ###   @3#>UPDATEt2java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 9
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
# @=i#*BLOBTEXT 2 java.lang.StringIndexOutOfBoundsException: Range [43, 42) out of bounds for length 57
#####@'
#   11
##ET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
###  @'' /* STRING(100) meta=65124 nullable=1 is_null=0 */java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
#   @ /* INT meta=0 nullable=1 is_null=0 */
#   31000 /* INT meta=0 nullable=1 is_null=0 */
##@= /* BLOB/TEXT meta=2 nullable=1 is_null=1 */

Ojava.lang.StringIndexOutOfBoundsException: Index 7 out of bounds for length 6
  @
#**
###   @4# # 4/
### SET#insert_to_t2 /* STRING(100) meta=65124 nullable=1 is_null=0 */
##   =#  1
#   2ojava.lang.StringIndexOutOfBoundsException: Range [26, 25) out of bounds for length 76
####
/
# PDATE`java.lang.StringIndexOutOfBoundsException: Range [0, 17) out of bounds for length 7
## WHERE
#3 INT= 0 java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
) meta=65124 nullable1=*
###@java.lang.StringIndexOutOfBoundsException: Range [24, 23) out of bounds for length 68
##@ /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
#
# @ijava.lang.StringIndexOutOfBoundsException: Range [23, 22) out of bounds for length 73
#@3=/* INT meta=0 nullable=1 is_null=0 */
###   @3java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
###   @#  test.`# java.lang.StringIndexOutOfBoundsException: Index 7 out of bounds for length 7
# Number of :4
OMMIT
*!*/;

/*!*/;
>UPDATEt2# WHERE
## `est.`###@'_java.lang.StringIndexOutOfBoundsException: Range [24, 23) out of bounds for length 68
##WHERE
# #WHERE
#   2##@3 java.lang.StringIndexOutOfBoundsException: Range [18, 17) out of bounds for length 48
### #SET##@#Wjava.lang.StringIndexOutOfBoundsException: Range [9, 10) out of bounds for length 9
4'java.lang.StringIndexOutOfBoundsException: Range [75, 30) out of bounds for length 75
### #   3 /
#@1java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
@= /* STRING(100) meta=65124 nullable=1 is_null=0 */
##   31
###   @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
##STRANSACTION
### WHERE
/
## =java.lang.StringIndexOutOfBoundsException: Range [14, 4) out of bounds for length 18
#   32/* INT meta=0 nullable=1 is_null=0 */
##  4'  t1(   ,c2 (100,
### SET
@1= /* INT meta=0 nullable=1 is_null=0 */
###   @= * INT meta=0 nullable=1 is_null=0 */
##3=1/* INT meta=0 nullable=1 is_null=0 */
###   ####@  0java.lang.StringIndexOutOfBoundsException: Range [34, 33) out of bounds for length 48
### UPDATE `test`.`t2`
### WHERE
#@1java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
##   2='nly_c2_changed'/
##   3 #
####  C
# java.lang.StringIndexOutOfBoundsException: Range [6, 1) out of bounds for length 6
##   @3/
###   @=only_c2_changed #  test.`
###   @##
##@3/java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
e.java.lang.StringIndexOutOfBoundsException: Range [23, 22) out of bounds for length 22
### WHERE
###  1#@
##   2=only_c2_changed'
###@
###   @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
##
#   1= * INT meta=0 nullable=1 is_null=0 */@4/* INT meta=0 nullable=1 is_null=0 */
##@'java.lang.StringIndexOutOfBoundsException: Range [27, 25) out of bounds for length 76
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='##@
# /!

/*!*/; Djava.lang.StringIndexOutOfBoundsException: Range [10, 9) out of bounds for length 11
START TRANSACTION
/*!*/;
# java.lang.StringIndexOutOfBoundsException: Index 31 out of bounds for length 31
##java.lang.StringIndexOutOfBoundsException: Range [11, 10) out of bounds for length 27
### WHERE
l1java.lang.StringIndexOutOfBoundsException: Range [44, 43) out of bounds for length 48
###
##   @# @ t1INT KEY varchar100java.lang.StringIndexOutOfBoundsException: Index 53 out of bounds for length 53
#4''*
#  .2java.lang.StringIndexOutOfBoundsException: Index 27 out of bounds for length 27
#
#@= * INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
#   3=/
#   @=java.lang.StringIndexOutOfBoundsException: Range [24, 23) out of bounds for length 68
#  rows2
COMMIT
/*!*/;
DELIMITER ;
# End of java.lang.StringIndexOutOfBoundsException: Index 11 out of bounds for length 7
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
DROPTABLE t2java.lang.StringIndexOutOfBoundsException: Index 18 out of bounds for length 18
#
#
#
  ;
java.lang.StringIndexOutOfBoundsException: Range [25, 6) out of bounds for length 53
c3 INT DEFAULT 1000, c4 java.lang.StringIndexOutOfBoundsException: Range [1, 28) out of bounds for length 19
##   2'java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 17
FLUSH# @ LOGS

##### has
#java.lang.StringIndexOutOfBoundsException: Range [21, 18) out of bounds for length 27
##############################

INSERT  java.lang.StringIndexOutOfBoundsException: Range [23, 21) out of bounds for length 27
(2, "insert_to_t1", 2, repeat('a', 20)),
(3, "insert_to_t1", 3=01###   @3=1 /* INT meta=0 nullable=1 is_null
INSERT INTO t1(c1) VALUES(4);
UPDATE t1 SET c2 = "only_c2_changed";
UPDATE t1 SET c3 = 1, c4 = "c3_c4_changed";
DELETE FROM t1 WHERE 2'/* STRING(100) meta=65124 nullable=1 is_null=0 */

###@1java.lang.StringIndexOutOfBoundsException: Index 49 out of bounds for length 48

/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
ELIMITER/*;
# Warning#SET

/*!*/;
#Q#   2'only_c2_changed /* STRING(100) meta=65124 nullable=1 is_null=0 */
#Q> (##  @= /* INT meta=0 nullable=1 is_null=0 */ /* added by mysqlbinlog */;
#(,  ,a',)
###DROP TABLE,
##SET
###   @#   3 #13java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
##@='java.lang.StringIndexOutOfBoundsException: Range [24, 22) out of bounds for length 74
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa'
###
#c3DEFAULT 1000
#Q INSERTLE t2 changed
###   @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */#`st`java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 22
### INSERT INTO `test`.##@=
#java.lang.StringIndexOutOfBoundsException: Index 51 out of bounds for length 7
###   @1=3 /* INT meta=0 nullable=0 is_null=0 */
###   @2='Number of rows1
#   @= COMMIT
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# # : java.lang.StringIndexOutOfBoundsException: Range [23, 22) out of bounds for length 67
/*!\C latin1 *//*!*/;

/*!*/;
TART
/*!*/;
QINTOt1 (4
# ``java.lang.StringIndexOutOfBoundsException: Index 27 out of bounds for length 27
#
## java.lang.StringIndexOutOfBoundsException: Range [16, 15) out of bounds for length 27
@#
##   =000
# Number of rows: 1
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t1 SET c2 = "only_c2_changed"

##UPDATE`
##  =java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
### 4ajava.lang.StringIndexOutOfBoundsException: Range [31, 30) out of bounds for length 75
2java.lang.StringIndexOutOfBoundsException: Range [26, 25) out of bounds for length 76

###   @1
@'java.lang.StringIndexOutOfBoundsException: Range [27, 25) out of bounds for length 77
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
### UPDATE#   14 /* INT meta=0 nullable=1 is_null=0 */
### WHERE
#   @=java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
###   @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */ Number of rows:
#  =2/
### SETQ##@java.lang.StringIndexOutOfBoundsException: Range [8, 0) out of bounds for length 0
#@=
###   @2=@=java.lang.StringIndexOutOfBoundsException: Range [26, 25) out of bounds for length 76
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
START
#
#   =/
#####java.lang.StringIndexOutOfBoundsException: Range [9, 10) out of bounds for length 9
##   @3=3 *INT# java.lang.StringIndexOutOfBoundsException: Range [16, 15) out of bounds for length 27
### SET
###   @1=3 /* INT meta=0 nullable=0 is_null=0 */
####   12 /* INT meta=0 nullable=1 is_null=0 */
###   @3=3 /* INT meta=0 nullable=1 is_null=0 */
# 1java.lang.StringIndexOutOfBoundsException: Range [23, 22) out of bounds for length 22
####   @=4 *#   @3=3 /* INT
#@4 * INT meta=0 nullable=0 is_null=0 */
###   S
##   =
#SET
###   @1=4 /* INT meta=0 nullable=0 is_null=0 */
#'###   @2='only_c2_changed
###   @3=1000 /* INT meta=0 nullable=1 is_null=0 */
:
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q>
##    ,cchanged
### WHERE
#@1
###   @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
##1 /* INT meta=0 nullable=1 is_null=0 */ java.lang.StringIndexOutOfBoundsException: Range [24, 22) out of bounds for length 48
#
###   @1=1 /* INT meta=0 nullable=0 is_null=0 */
###   @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
@cc'
### UPDATE>DELETE t2WHERE c1>java.lang.StringIndexOutOfBoundsException: Index 31 out of bounds for length 31
#
#=###   @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
###   # testjava.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 22
#   =/
### SET
###   @1=2 /* INT meta=0 nullable=0 is_null=0 */
###= /* INT meta=0 nullable=1 is_null=0 */
##   4'#   @4='aaaaaaaaaaaaaaaaaaaa4java.lang.StringIndexOutOfBoundsException: Range [31, 30) out of bounds for length 75
java.lang.StringIndexOutOfBoundsException: Index 52 out of bounds for length 52
### UPDATE `test`.`t1`
java.lang.StringIndexOutOfBoundsException: Index 29 out of bounds for length 9
###   @1=3 /* INT meta=0 nullable=0 is_null=0 */
#   2'java.lang.StringIndexOutOfBoundsException: Range [77, 25) out of bounds for length 77
#   @
### SET
###   @1=3 /* INT meta=0 nullable=0 is_null=0 */
###   @2='only_c2_changed#4java.lang.StringIndexOutOfBoundsException: Index 57 out of bounds for length 57
###   ##  @= /* BLOB/TEXT meta=2 nullable=1 is_null=1 */>INSERTt1Cjava.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
###   @4##   @1
### UPDATE##@=only_c2_changed
#
#1  meta000java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
=#=/* INT meta=0 nullable=1 is_null=0 */
###   @3=1000 /* INT meta=0 nullable=1 is_null=0 */
#
###   @1=4 /* INT meta=0 nullable=0 is_null=0 */

###   /
###   @4#>DELETE java.lang.StringIndexOutOfBoundsException: Range [31, 30) out of bounds for length 75
#
# java.lang.StringIndexOutOfBoundsException: Index 7 out of bounds for length 7
/*!*/;
##   @=3
/*!*/;#@4'/
#Q> DELETE FROM # Number of rows:
### DELETE FROM `test`java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 6
java.lang.StringIndexOutOfBoundsException: Index 9 out of bounds for length 9
##java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
#   2''/
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
# Number of rows: 1

/*!*/;  of rows:java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
DELIMITERjava.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
FLUSH BINARY #   4c__java.lang.StringIndexOutOfBoundsException: Range [25, 23) out of bounds for length 68

# t2 has no primary key.
#It  java.lang.StringIndexOutOfBoundsException: Index 31 out of bounds for length 29
# java.lang.StringIndexOutOfBoundsException: Index 7 out of bounds for length 1

INSERT INTO t2 VALUES(1, "insert_to_t2", # SETjava.lang.StringIndexOutOfBoundsException: Range [13, 12) out of bounds for length 53
(2, "#INT 1000 TEXT)
,insert_to_t2#
INSERT INTO t2(c1) VALUES(4#    java.lang.StringIndexOutOfBoundsException: Range [13, 12) out of bounds for length 18
UPDATE t2 SET c2 = "only_c2_changed";
UPDATE t2 SET c3 = 1, c4 = "c3_c4_changed";
FROMc1 >;

# Verify that rows events are binlogged java.lang.StringIndexOutOfBoundsException: Range [1, 0) out of bounds for length 0

/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
("java.lang.StringIndexOutOfBoundsException: Range [18, 17) out of bounds for length 40
#binlog=nullable==*
START TRANSACTION
/*!*/;
#>INSERT t2 java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 7
#UPDATE SET c3  1  ="3c4_changed;#   4'#   2ojava.lang.StringIndexOutOfBoundsException: Range [27, 25) out of bounds for length 77
# 3 java.lang.StringIndexOutOfBoundsException: Range [22, 21) out of bounds for length 43
### INSERT @4='c3_c4_changedjava.lang.StringIndexOutOfBoundsException: Range [68, 51) out of bounds for length 51
# java.lang.StringIndexOutOfBoundsException: Index 7 out of bounds for length 7
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
###/
#
##java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
INTO `###   @1=4 /* INT met1   0   /
### SET
##   1#   =/* BLOB/TEXT meta=2 nullable=1 is_null=1 */
#java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
# 3/ = 0*
###   @4='aaaaaaaaaaaaaaaaaaaa'##`.t1# SET
### INSERT #   @1=1 /* =0###   @1=1 /* INT meta=0 nullable #10*/
#SET
###
o_t2'/* STRING(100) meta=65124 nullable=1 is_null=0 */
#;
###   @4='##   @2='only_c2_changed' #
java.lang.StringIndexOutOfBoundsException: Range [9, 8) out of bounds for length 36
/*!\C latin1 *//*!*/; `test`.java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 22
COMMIT
/*!*/;
START TRANSACTION
/*!*/;  #= /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
#Q> INSERT INTO t2(c1)## java.lang.StringIndexOutOfBoundsException: Range [59, 6) out of bounds for length 61
#`t
##SET
##@=java.lang.StringIndexOutOfBoundsException: Range [7, 6) out of bounds for length 29
###   @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
###   @3=1000 /* INT meta=0 nullable=1 is_null=0 */@ java.lang.StringIndexOutOfBoundsException: Range [21, 1) out of bounds for length 21
##/
# ##   @1 java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0

/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t2 SET c2 = "only_c2_changed"
## UPDATE test.t2`
##WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
###   @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
## SET=aaaaaaaaaaaaaaaaaaa/BLOBTEXT=nullable= java.lang.StringIndexOutOfBoundsException: Range [72, 70) out of bounds for length 75
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
##   3# UPDATE e`t2`
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
###   @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
##   32java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
##   4#@='/ /EXT meta= nullable=1 0*/
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
##' /* STRING(100) meta=65124 nullable=1 is_null=0 */
##   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4='##   @3=2 /* INT meta0 nullable=#SET
### UPDATE `test`.`t2`
### WHERE
##   @1=3 /* INT meta=0 nullable=1 is_null=0 */
###   2='' #@'aaaaaaaaaaaaaaaaaaaaV(100) meta==100  nullable= is_null= **java.lang.StringIndexOutOfBoundsException: Index 77 out of bounds for length 77
###   @3=3 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
###  @=3 * INT meta=0 nullable=1 is_null=0 */NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=3 *INT = nullable==1  is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### java.lang.StringIndexOutOfBoundsException: Index 9 out of bounds for length 7
##2/* INT meta=0 nullable=1 is_null=0 */
###   @1=4 /* INT meta=0 nullable=1 is_null=0 */
###   @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
###   @3=1000 /* INT meta=0 nullable=1 is_null=0 */
##   4=NULL/* BLOB/TEXT meta=2 nullable= is_null nullable= is_null=   @1000 /* INT meta=0 nullable=1 is_null=0 */
### SET
###   @#   @4= /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
##@3=Number  ofrows:
###   @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
# Number of rows: 4
COMMIT
/*!*/;
TARTTRANSACTION
/*!*/;
#Q> UPDATE java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
### UPDATE `test`.`t2`
###/
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
##   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */START TRANSACTION
##   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
##  t2  SETc3#@' 2 =is_null=*
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
###   @2='nly_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */# UPDATE ##  `test`.`t1`
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
#   =aaaaaaaaaaaaaaaaaaaa'/*BLOB/ #11
### UPDATE `test`.`t2`
### WHERE
###java.lang.StringIndexOutOfBoundsException: Index 7 out of bounds for length 7
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed##   @=1/*  = nullable# SET
###   3=1 /* INT meta=0 nullable=1 is_null=0 */
@4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
## UPDATE test```
### WHERE
###   @1##@#3 /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=3 #   @='aaaaaaaaaaaaaaaaaaa
##   @4'aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
### UPDATE `test`#java.lang.StringIndexOutOfBoundsException: Range [9, 8) out of bounds for length 19
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=##   @1
###   @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
#java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
### WHERE
###   @1=4 /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
## TRANSACTION
###   FROMt1WHEREc1 =1
### SET
###   1=java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */WHERE
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
##@4=c3_c4_changedlable=1 is_null=0 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;##   = /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
#Q> DELETE FROM t2 WHERE c1 > 2
### DELETE FROM `test`.`t2`###   @4='
##WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
# WHERE
###   @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### DELETE FROM `test`.`t2`##   1=/*INTmeta=/
## WHERE
###   @1= /* INT meta=0 nullable=1 is_null=0 */
## @==only_c2_changed'/java.lang.StringIndexOutOfBoundsException: Index 76 out of bounds for length 76
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='c3_c4_changed##   3=3/*java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
# Number of rows: 2
COMMIT
/*!*/;
FLUSH BIN LOGS;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
DROP TABLE t1, t2;
#
# FULL mode works as expected
#
SET binlog_row_image = "FULL";COMMIT
java.lang.StringIndexOutOfBoundsException: Range [21, 6) out of bounds for length 53
c3 INT DEFAULT 1000, c4 TEXT);
CREATE/*!*/;
#  3 /* INT meta=0 nullable=1 is_null=0 */

########################@=T
# binlog_row_image = FULL
########################################INSERT INTO

INSERT INTO t1 VALUES(1, "insert_to_t1", 1, repeat('a', 20)),2,"insert_to_t2 c3=# java.lang.StringIndexOutOfBoundsException: Range [9, 10) out of bounds for length 9
(3, insert_to_t2", 3, repeat('a', 20));
(3 "insert_to_t1", 3#@='only_c2_changed'/* STRING(100) meta=65124 nullable=1 is_null=0 */
INSERT INTO t1(c1) VALUES(4);
UPDATE t1 SET c2 = "only_c2_changed";
UPDATE t1 c3= 1,#4NULL/* BLOB/TEXT meta=2 nullable=1 is_null=1 */
DELETE FROM t1 WHERE c1 = 1;

# Verify

/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# Warning: this binlog is either in####@java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
START TRANSACTION
/*!*/;
RT INTO  meta= nullable= is_null=0 /
#Q",2 repeat(', 20))java.lang.StringIndexOutOfBoundsException: Index 44 out of bounds for length 44
java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
### INSERT INTO##java.lang.StringIndexOutOfBoundsException: Index 72 out of bounds for length 72
###SET
#DELIMITER /*!*/;
###   @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
###  java.lang.StringIndexOutOfBoundsException: Index 7 out of bounds for length 7
#'aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT INTO `test`.`t1`
###T
###   @1=2 /* INT meta=0 nullable=0 is_null=0 */
###   @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
=2 /* INT meta=0 nullable=1 is_null=0 */
###@4'aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT  `test.`nu=1 java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
###SET
###/
##   @2=insert_to_t1'/*#>(3, "", c1>2
###   @3=3 /* INT meta=0 nullable=1 is_null=0 */
####DELETE#INSERT INTO`test``t2
# Number of rows: 3
/*!\C latin1 *//*!*/;
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> INSERT INTO t1(c1) VALUES(4)
### NSERT INTO #   @=nsert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### SET
###   @14 /* INT meta=0 nullable=0 is_null=0 */
INSERT INTO `test`.`t2`
###   @3=1000 /* INT meta=0 nullable=1 is_null=0 */
##   @=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
r#@= /* INT meta=0 nullable=1 is_null=0 */
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t1 SET c2 = "only_c2_changed"
### UPDATE `test`.`t1`
### WHERE
###   @1=1 /* INT meta=0 nullable=0 is_null=0 */
###   @2='insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
###  @3=1 /* INT meta=0 nullable=1 is_null=0 */
#   @'aaaaaaaaaaaaaaaaaaaa'/* BLOBTEXTmeta=2 nullable=1 is_null0 #  2'' /* STRING(100) meta=65124 nullable=1 is_null=0 */
### SET
###   @1=1 /* INT meta=0 nullable=0 is_null=0 */
@SET
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t1`##   4##   @4='_' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
##WHERE
###   1= UPDATEtest`.`t2java.lang.StringIndexOutOfBoundsException: Range [23, 22) out of bounds for length 22
###   @2='###   @2='insert_to_t10 nullable=1 ## WHERE
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
###   @1=2/* INT meta=0 nullable=0 is_null=0 */
###   @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
## @2 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
#
### WHERE
###   @1=3 /* INT meta=0 nullable=0 is_null=0 */
###   @2=insert_to_t1' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
###   @3=3 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
###   @1=3 /* INT meta=0 nullable=0 is_null=0 */
###   @2'only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
##@= /* INT meta=0 nullable=1 is_null=0 */
@=aaaaaaaaaaaaaaaaaaaaINTO ``java.lang.StringIndexOutOfBoundsException: Range [27, 26) out of bounds for length 27
### UPDATE `   @1=4 /* INT meta=1is_null0/
### WHERE
##@=4 /* INT meta=0 nullable=0 is_null=0 */
###   @2NULL/* VARSTRING(100) meta=100 nullable=1 is_null=1 */
###   @3=1000 /* INT meta=0 nullable=1 is_null=0 */
###   @## @=''*/ =2 nullable=1is_null=0 *
### SET
###   @1=4 /* INT meta=0 nullable=0 is_null=0 */
##   2=only_c2_changed'/ VARSTRING(100 meta=100nullable=1 is_null=0 */
###   @3=1000 /* INT meta=0 nullable=1 is_null=0 */
###   @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
# java.lang.StringIndexOutOfBoundsException: Index 8 out of bounds for length 6
COMMIT##   1java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
/*!*/;
STARTTRANSACTION
/*!*/;
Q UPDATE t1 SET
### UPDATE `test`.`t1`
### WHERE
##   @1= /* INT meta=0 nullable=0 is_null=0 */
###   @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */`
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
#WHERE
###   @1=1 /* INT meta=0 nullable=0 is_null=0 */
###   @2='java.lang.StringIndexOutOfBoundsException: Index 25 out of bounds for length 7
###   @##@=aaaaaaaaaaaaaaaaaaaa'/* BLOB/TEXT meta=2 nullable=1 is_null=0 */
##
### UPDATE `test##@1= /* INT meta=0 nullable=1 is_null=0 */
java.lang.StringIndexOutOfBoundsException: Range [9, 10) out of bounds for length 9
###   @1=2 /* INT meta=0 nullable=0 is_null=0 */
###   @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
###   @1=2 /* INT meta=0 nullable=0 is_null=0 */
###   @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
##UPDATE`test`.t1`
### WHERE
###   @1=3 /* INT meta=0 nullable=0 is_null=0 */
##@2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
###   @3=3 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */java.lang.StringIndexOutOfBoundsException: Index 9 out of bounds for length 9
#
###   @1=3 /* INT meta=0 nullable=0 is_null=0 */
###   @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='### DELETE FROM `test#DELETE FROM test```
# UPDATEtest
#
####2o
###   @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
###   @3=1000 /* INT meta=0 nullable=1 is_null=0 */
###   @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
### SET
###   @1=4 /* INT meta=0 nullable=0 is_null=0 */
###   @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> DELETE FROM t1 WHERE c1 = 1
#`test``t1`
### WHERE
###   @1=1 /* INT meta=0 nullable=0 is_null=0 */
###   @2='only_c2_changed' /* VARSTRING(100) meta=100 nullable=1 is_null=0 */
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 1
COMMIT
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
FLUSH BINARY LOGS;

# t2 has no primary key.
# It will binlog full before and after image for all modes if the
# table has no primary key. FULL_NODUP follows the behavior.

INSERT INTO t2 VALUES(1, "insert_to_t2", 1, repeat('a', 20)),
(2, "insert_to_t2", 2, repeat('a', 20)),
(3, "insert_to_t2", 3, repeat('a', 20));
INSERT INTO t2(c1) VALUES(4);
UPDATE t2 SET c2 = "only_c2_changed";
c4 ="c3_c4_changed";
DELETE FROM t2 WHERE c1 > 2;

# Verify that rows events are binlogged as expeced.

/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# Warning: this binlog is either in use or was not closed properly.
START TRANSACTION
/*!*/;
#Q> ##   @2'only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
#Q> (2, "insert_to_t2", 2, repeat('a', 20)),
#Q> (3, "insert_to_t2", 3, repeat('a', 20))
### INSERT INTO `test`.`t2`
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
###   @=insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT INTO `test`.`t2`
### SET
###
###   @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */   @=3 /* INT meta=0 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
##@4=aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### INSERT INTO `test`.`t2`
### SET
##  @13
###   @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=3 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa'##   1= /* INT meta=0 nullable=1 is_null=0 */
# Number of rows: 3
/*!\C latin1 *//*!*/;
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> INSERT INTO t2(c1) VALUES(4)
### INSERT INTO `test`.`t2`
### SET
###  @= /* INT meta=0 nullable=1 is_null=0 */
###   @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
###   @3=1000 /* INT meta=0 nullable=1 is_null=0 */
##@4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
# Number of rows: 1
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t2 SET c2 = "only_c2_changed"
### UPDATE `test`.`t2`
### WHERE
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
###   @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
##   4=aaaaaaaaaaaaaaaaaaaa /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
##.t2
##
#@2
###   @2='insert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
#@'/
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */#  3= /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=2 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
##UPDATEtest`.t2`
##   2=only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   ##   @=3 /* INT meta=0 nullable=1 is_null=0 */
###   @='nsert_to_t2' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=3 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
##  @=3 /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=3 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
##WHERE
###   @1=4 /* INT meta=0 nullable=1 is_null=0 */
###   @2=NULL /* STRING(100) meta=65124 nullable=1 is_null=1 */
###   @3=1000 /* INT meta=0 nullable=1 is_null=0 */
###   @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
### SET
###   @1=4 /* INT meta=0 nullable=1 is_null=0 */##   @=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
##   3= /* INT meta=0 nullable=1 is_null=0 */
###   @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */#   @=only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> UPDATE t2 SET c3 = 1, c4 = "c3_c4_changed"
### UPDATE `test`.`t2`
### WHERE
##@11 /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
###   @1=1 /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
#####   3= /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=/*!*/;
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
###   @1=2 /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='c3_c4_changed' ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;
### UPDATE `test`.`t2`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=3 /* INT meta=0 nullable=1 is_null=0 */
###   @4='aaaaaaaaaaaaaaaaaaaa' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### SET
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### UPDATE `test`.`t2`
### WHERE
###   @1=4 /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=1000 /* INT meta=0 nullable=1 is_null=0 */
###   @4=NULL /* BLOB/TEXT meta=2 nullable=1 is_null=1 */
### SET
###   @1=4 /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 4
COMMIT
/*!*/;
START TRANSACTION
/*!*/;
#Q> DELETE FROM t2 WHERE c1 > 2
### DELETE FROM `test`.`t2`
### WHERE
###   @1=3 /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
### DELETE FROM `test`.`t2`
### WHERE
###   @1=4 /* INT meta=0 nullable=1 is_null=0 */
###   @2='only_c2_changed' /* STRING(100) meta=65124 nullable=1 is_null=0 */
###   @3=1 /* INT meta=0 nullable=1 is_null=0 */
###   @4='c3_c4_changed' /* BLOB/TEXT meta=2 nullable=1 is_null=0 */
# Number of rows: 2
COMMIT
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
DROP TABLE t1, t2;
RESET MASTER;
ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;

Messung V0.5 in Prozent

¤ Diese beiden folgenden Angebotsgruppen bietet das Unternehmen0.33Angebot ¤

*Eine klare Vorstellung vom Zielzustand

Wurzel

Suchen

PVS Prover

Isabelle Prover

NIST Cobol Testsuite

Cephes Mathematical Library

Vienna Development Method

Haftungshinweis

Die Informationen auf dieser Webseite wurden nach bestem Wissen sorgfältig zusammengestellt. Es wird jedoch weder Vollständigkeit, noch Richtigkeit, noch Qualität der bereit gestellten Informationen zugesichert.

Bemerkung:

Die farbliche Syntaxdarstellung und die Messung sind noch experimentell.