# Example how #  java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
#-------java.lang.StringIndexOutOfBoundsException: Range [34, 16) out of bounds for length 52
#
### The table/tables used in $part must have the right content.
### $title_prefix is used for the generationt2                                 ,
#
# let $title_prefix= 4.3;
### $check_num is used for the generation of titles and gets incremented after COUNT_MISC -.OUNT_MISC ,
### every ##$part  used for the  of" error
#let $ ;
### $diff_column_list is used #let $part=
### every sub#FROM .socket_summary_by_instance_detailjava.lang.StringIndexOutOfBoundsException: Range [53, 54) out of bounds for length 53
# let #   LIKE(%'
# t2.COUNT_READ - java.lang.StringIndexOutOfBoundsException: Index 20 out of bounds for length 16
 .COUNT_READAS,
# t1.COUNT_READ                 AS S1_COUNT_READ
 t2.  . AS D_SUM_NUMBER_OF_BYTES_READ
# t2.#letstmt2=  FROM does_not_exist WHEREcol1=0java.lang.StringIndexOutOfBoundsException: Index 60 out of bounds for length 60
# t1.                               ,
# t2.COUNT_WRITE - t1.COUNT_WRITE AS D_COUNT_WRITE,
 t2.OUNT_WRITEASS2_COUNT_WRITE
# t1.COUNT_WRITE                  AS # # Both statements fail with the same error  notexist;
# t2.SUM_NUMBER_OF_BYTES_WRITE - t1.SUM_NUMBER_OF_BYTES_WRITE AS D_UM_NUMBER_OF_BYTES_WRITE .UM_NUMBER_OF_BYTES_READ S   LENGTH'$' -LENGTH(stmt1' java.lang.StringIndexOutOfBoundsException: Index 103 out of bounds for length 103
# t2.SUM_NUMBER_OF_BYTES_WRITE                                java.lang.StringIndexOutOfBoundsException: Range [70, 71) out of bounds for length 70
# t1. --source ../include/socket_check1
 ...
# t2.COUNT_MISC                 AS S2_COUNT_MISC,
 t1.OUNT_MISCAS S1_COUNT_MISCjava.lang.StringIndexOutOfBoundsException: Index 49 out of bounds for length 49
 "check"statements+  information
### and valid for every sub test.
#-echo #$.$check_num  impact ofstatements
# FROM mysqltest-echo #$stmt1
# java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
#, run)
# WHERE OBJECT_INSTANCE_BEGIN <> @if(0)
#   AND EVENT_NAME LIKE ('{
#   AND run=1;
#
# --echo # $title_prefix Check the differences java.lang.StringIndexOutOfBoundsException: Index 53 out of bounds for length 4
java.lang.StringIndexOutOfBoundsException: Index 27 out of bounds for length 1
# let stmt1= SELECTecho  stmt2  stmt2
# let stmt2=      -#my_rules my_rules
### $      -  ,have abort
# let $   java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for length 4
# # One statement is longer    $
  the same  message (table does not exist);
# let $my_rules=
# t2.COUNT_READ                -
#-enable_query_log
#   enable_result_log
   -echo#The  statistics lookssuspicious
 t2.-t1.COUNT_MISC                =0java.lang.StringIndexOutOfBoundsException: Index 66 out of bounds for length 66
#-source ./nclude.inc
#
# let stmt1= ....
# let stmt2= ....
 let $= ..
# --source ../include/socket_check1.inc
#
# .   -
#

--   $ AS 
--cho#      $tmt2
--   -vertical_results
--eval

    $
if(0)   part
{
   if-echo
      -horizontal_results
      java.lang.StringIndexOutOfBoundsException: Index 7 out of bounds for length 7
      -echo   least oneofthe java.lang.StringIndexOutOfBoundsException: Range [45, 44) out of bounds for length 79
      --echo # stmt1 : $stmt1
      --echo # stmt2 : $stmt2
      -echo  :$y_rules
            COUNT_WRITE,') AS java.lang.StringIndexOutOfBoundsException: Index 44 out of bounds for length 44
      exit;
   }
}

if(`SELECT NOT ( $my_rulesLPAD, 8,''ASCNT_MISC statement
    $
     EVENT_NAME (client_connection
{
   --enable_query_logANDrun =1
   --enable_result_log
   --echo # The compared statistics looks suspicious
   --echo # We expect
   --echo # allvariableswhich depend thestatementstobechecked
   -echo
   --let $stmt1s    ;
   eval
   SELECT $my_rules AS Expect_1
   $part
   let $m ;
     -echo
   --inc $check_num
   eval

   $part
   AND t1.statement = '$stmt1' AND t2.statement = '$stmt2';
   --echo
   --horizontal_results

   eval
   SELECT
      LPAD(COUNT_READ, 8, ' ') AS CNT_READ,
      LPAD(SUM_NUMBER_OF_BYTES_READ,  10,' ') AS BYTES_READ,
      LPAD(COUNT_WRITE,9, ' ') AS CNT_WRITE,
      LPAD(SUM_NUMBER_OF_BYTES_WRITE, 11,' ') AS BYTES_WRITE,
      LPAD(COUNT_MISC, 8, ' ') AS CNT_MISC, statement
   FROM mysqltest.socket_summary_by_instance_detail
   WHERE OBJECT_INSTANCE_BEGIN <> @default_object_instance_begin
     AND EVENT_NAME LIKE ('%client_connection')
     AND run = 1
     AND statement IN('$stmt2','$stmt1');
   let $print_details= 1;
}
# Initialize all variables which depend on the statements to be checked.
# This prevents that we run with wrong data.
let $stmt1=    stmt1_not_set;
let $stmt2=    stmt2_not_set;
let $my_rules= my_rules_not_set;
let $msg=      msg_not_set;
inc $check_num;