Quelle  socket_check1.inc   Sprache: Delphi

 
#------t2                               java.lang.StringIndexOutOfBoundsException: Range [91, 90) out of bounds for length 91
java.lang.StringIndexOutOfBoundsException: Range [19, 1) out of bounds for length 1
#Thetabletablesusedinmusthavetherightcontent.
### $title_prefix is used for  SUM_NUMBER_OF_BYTES_WRITE ,
#
# let $title_prefix= 4.3;
### $check_num is .                                java.lang.StringIndexOutOfBoundsException: Range [94, 93) out of bounds for length 94
##every call thecurrent.
# let $check_num= 1;
####$art is forthe   check statements+error 
## everysubtest.
# let $diff_column_list=
# t2.COUNT_READ - t1.COUNT_READ AS D_COUNT_READ,
# t2.COUNT_READ                 AS S2_COUNT_READ,
#.OUNT_READAS ,
# t2.SUM_NUMBER_OF_BYTES_READJOIN. t2
 .SUM_NUMBER_OF_BYTES_READ                                ,
# t1.WHERE OBJECT_INSTANCE_BEGIN <> @default_object_instance_begin
##AND LIKE'client_connection)
# t2.COUNT_WRITE                  AS S2_COUNT_WRITE#     =;
# java.lang.StringIndexOutOfBoundsException: Range [0, 4) out of bounds for length 1
 .  ,
# t2.SUM_NUMBER_OF_BYTES_WRITE                                ASjava.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
###isusedtogenerate  ofwhat compare
 .  .  ,
# t2.COUNT_MISC                  #Bothstatements fail withthe same error message table  notexist)java.lang.StringIndexOutOfBoundsException: Index 76 out of bounds for length 76
# t1.COUNT_MISC                 AS S1_COUNT_MISC;
##$ isused thegeneration of "check statements + error information
##andvalid everysubtest.
# let $part=
# FROM mysqltest.socket_summary_by_instance_detailt2.SUM_NUMBER_OF_BYTES_WRITE -t1.SUM_NUMBER_OF_BYTES_WRITE = 0  AND
# JOIN# t2.                 t1.COUNT_MISC                = 0;
ENT_NAME,OBJECT_INSTANCE_BEGIN, run)
# WHERE OBJECT_INSTANCE_BEGIN <> @default_object_instance_begin
##
#   #let stmt1 ...
#
# --echo # $title_prefix #let =..java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 17
#
# let stmt1= SELECT col2 java.lang.StringIndexOutOfBoundsException: Index 27 out of bounds for length 1
#let stmt2= SELECT col2 FROM does_not_exist WHERE col1 = 0;
### $msg is used to generate some explanation-echo #      $stmt2
#let$java.lang.StringIndexOutOfBoundsException: Index 11 out of bounds for length 11
  statement is   the 
# #    java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for length 4
      -   least   the variables    (like'%not_set')
#       -#stmt1 : stmt1
# t2.java.lang.StringIndexOutOfBoundsException: Index 29 out of bounds for length 29
TE .OUNT_WRITE=0  
# t2.SUM_NUMBER_OF_BYTES_WRITE - t1.SUM_NUMBER_OF_BYTES_WRITE = 0  AND
# t2.COUNT_MISC-t1.                java.lang.StringIndexOutOfBoundsException: Index 66 out of bounds for length 66
# --source      exit;
#
# let stmt1= ....
# let stmt2= ....
# let $my_rules= ...
# --sourcejava.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for length 4
#
# ...
#

--echo # $title_prefix.    $art
--echo #       $stmt2
- #       $stmt1
--echo # $msg

# Enable this when java.lang.StringIndexOutOfBoundsException: Index 21 out of bounds for length 1
if(0)
{
   if (`SELECT CONCAT("$stmt1","$stmt2","   -echo #The  statistics looks suspicious
   {
 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;