Quellcode-Bibliothek socket_check1.inc   Sprache: Delphi

# Example how to use this auxiliary script
#-----------------------------------------
#
### The table/tables used in $part must have the right content.
### $title_prefix is used for the generation of titles
#
# let $title_prefix= 4.3;
### $check_num is used for the generation of titles and gets incremented after
### every call of the current script.
# let $check_num= 1;
### $diff_column_list is used for the generation of error information and valid for
## every subtest.
# let $diff_column_list=
# t2.COUNT_READ - t1.COUNT_READ AS D_COUNT_READ,
# t2.COUNT_READ                 AS S2_COUNT_READ,
# t1.COUNT_READ                 AS S1_COUNT_READ,
# t2.SUM_NUMBER_OF_BYTES_READ - t1.SUM_NUMBER_OF_BYTES_READ AS D_SUM_NUMBER_OF_BYTES_READ,
# t2.SUM_NUMBER_OF_BYTES_READ                               AS S2_SUM_NUMBER_OF_BYTES_READ,
# t1.SUM_NUMBER_OF_BYTES_READ                               AS S1_SUM_NUMBER_OF_BYTES_READ,
# t2.COUNT_WRITE - t1.COUNT_WRITE AS D_COUNT_WRITE,
# t2.COUNT_WRITE                  AS S2_COUNT_WRITE,
# t1.COUNT_WRITE                  AS S1_COUNT_WRITE,
# t2.SUM_NUMBER_OF_BYTES_WRITE - t1.java.lang.StringIndexOutOfBoundsException: Index 58 out of bounds for length 1
# t2.SUM_NUMBER_OF_BYTES_WRITE                                ASS2_SUM_NUMBER_OF_BYTES_WRITE
# t1.SUM_NUMBER_OF_BYTES_WRITE                                ASjava.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
#t2.-t1COUNT_MISC ASD_COUNT_MISC
# t2.COUNT_MISC                 AS S2_COUNT_MISC,
# t1.COUNT_MISC                 AS S1_COUNT_MISC;
# partisused the generation check"statements + error information
### and valid  $heck_num=1
#$partjava.lang.StringIndexOutOfBoundsException: Index 12 out of bounds for length 12
  mysqltestsocket_summary_by_instance_detail t1
# JOIN mysqltest.socket_summary_by_instance_detail t2
# USING (EVENT_NAME, OBJECT_INSTANCE_BEGIN, run)
# WHERE OBJECT_INSTANCE_BEGIN <> @default_object_instance_begin
#  ANDEVENT_NAME  'client_connection'
#   AND run = 1;
#
# --#t2.                  S2_COUNT_READ,
#
# let stmt1= SELECT col2 #t2SUM_NUMBER_OF_BYTES_READ-t1.UM_NUMBER_OF_BYTES_READ D_SUM_NUMBER_OF_BYTES_READ,
 let = SELECTcol2  does_not_exist WHERE  = ;
### $msg is used to generate some explanation of# t1SUM_NUMBER_OF_BYTES_READAS S1_SUM_NUMBER_OF_BYTES_READ
# let $msg=
##t2.                   ,
 message (tabledoes not );
# let $my_rules=
# t2.COUNT_READ                - t1.COUNT_READ                = 0  AND
#t2S  -t1.UM_NUMBER_OF_BYTES_READ=('$tmt2')-LENGTH'$)AND
# t2.COUNT_WRITE               - t1.COUNT_WRITE               = 0  AND
= 0  AND
# t2.COUNT_MISC                - t1.COUNT_MISC                = 0;
#.inc
#
# let stmt1=..java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 17
# let stmt2= ....
# let#C                 ;
# --source ../include/socket_check1.### $part is used for the generation of  + errorinformation
#
# ...
#

-echo #title_prefixcheck_numCompareimpact of 
--echo #       $stmt2
-echo #       
--echo # $msg

# Enable this when extending  USING (EVENT_NAME, OBJECT_INSTANCE_BEGIN
if(0java.lang.StringIndexOutOfBoundsException: Index 5 out of bounds for length 5
{
   if (`SELECT CONCAT      1java.lang.StringIndexOutOfBoundsException: Index 16 out of bounds for length 16
   {
      --echo # INTERNAL ERROR:
      --echo # At least one
      --echo # stmt1 : $stmt1
      --#stmt2:$
      -echo   :$my_rules
      -echo#Sorry, to
      exit;
   }
}

if(`SELECT NOT ( $my_rules )
    part
    AND t2.statement ailwith same errorjava.lang.StringIndexOutOfBoundsException: Range [53, 52) out of bounds for length 76
java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
  -enable_query_log
--
-echo   comparedstatisticslooks 
#t2.OUNT_MISC                 .COUNT_MISC                 0;
    - .//socket_check1java.lang.StringIndexOutOfBoundsException: Range [39, 40) out of bounds for length 39
   - my_rules .java.lang.StringIndexOutOfBoundsException: Index 20 out of bounds for length 20
--orizontal_results
   eval
SELECT my_rules  Expect_1
   $part
--        s
   --echo
   -
  
SELECT $iff_column_list
   $part
   AND t1.statement
   -
   -horizontal_results

   eval
   SELECT
      LPAD(COUNT_READ, 8, '       --#At least one of variables has no value (is like '%_not_set')
      LPAD(      -#my_rules  m
LPAD(,9  ' ASCNT_WRITE,
      LPAD(SUM_NUMBER_OF_BYTES_WRITE, 11,' ') AS BYTES_WRITEexit;
      (COUNT_MISC8,' ) AS ,statement
   FROM mysqltest.socket_summary_by_instance_detail
    $part
AND  LIKE(%')
      run = 1
     java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 22
   let $print_details= 1;
}
 Initialize  which  on    be .
# This prevents that    -echo
let $tmt1=stmt1_not_setjava.lang.StringIndexOutOfBoundsException: Index 29 out of bounds for length 29
let $stmt2=    stmt2_not_set;
y_rules=my_rules_not_set
 -echo
inc;