Quelle  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 sub test.
# 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.# Example how to use thisauxiliary script
# .SUM_NUMBER_OF_BYTES_READAS S2_SUM_NUMBER_OF_BYTES_READ,
# t1.SUM_NUMBER_OF_BYTES_READ                               AS S1_SUM_NUMBER_OF_BYTES_READ,
# t2.COUNT_WRITE - 
# t2.COUNT_WRITE                  AS S2_COUNT_WRITE,
# ##  / used in $part     content.
E-t1. ASD_UM_NUMBER_OF_BYTES_WRITE
# t2.SUM_NUMBER_OF_BYTES_WRITE                                AS S2_SUM_NUMBER_OF_BYTES_WRITE
# t1SUM_NUMBER_OF_BYTES_WRITEAS S1_SUM_NUMBER_OF_BYTES_WRITE,
# t2.COUNT_MISC - t1.COUNT_MISC AS D_COUNT_MISC,
# t2.COUNT_MISC                 AS S2_COUNT_MISC,
# t1.COUNT_MISC                 # every call of   script
# p isused   generationof""statements  error information
### every  testjava.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
# let $part=
# FROM#t1.                 S1_COUNT_READ
#  mysqltestsocket_summary_by_instance_detail
##t2.SUM_NUMBER_OF_BYTES_READ                               AS S2_SUM_NUMBER_OF_BYTES_READ
# java.lang.StringIndexOutOfBoundsException: Range [29, 7) out of bounds for length 63
    EVENT_NAME (%'java.lang.StringIndexOutOfBoundsException: Index 46 out of bounds for length 46
#   ANDrun=1java.lang.StringIndexOutOfBoundsException: Index 16 out of bounds for length 16
#
# --echo # $title_prefix Check -t1SUM_NUMBER_OF_BYTES_WRITEASD_UM_NUMBER_OF_BYTES_WRITE
#
# let stmt1= SELECT col2 FROM does_not_exist;
# let stmt2= SELECT col2 FROM does_not_exist WHERE col1 = 0;
## msg    generate someexplanation  we.
# let $msg=
# # One#t2.OUNT_MISC-t1.OUNT_MISCASD_COUNT_MISC
#    (does ;
# let $my_rules=
# t2.COUNT_READ                - t1.COUNT_READ                = 0  AND
###part  for of""java.lang.StringIndexOutOfBoundsException: Range [59, 58) out of bounds for length 78
# t2.COUNT_WRITE               -#   for  
#   java.lang.StringIndexOutOfBoundsException: Range [63, 61) out of bounds for length 70
# COUNT_MISC-java.lang.StringIndexOutOfBoundsException: Range [62, 46) out of bounds for length 66
# --source  java.lang.StringIndexOutOfBoundsException: Range [43, 42) out of bounds for length 48
#
  =.java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 17
# stmt2 ..
# let $my_rules= ...
# --source ../java.lang.StringIndexOutOfBoundsException: Index 20 out of bounds for length 1
#
# ...
#

--echo # $ java.lang.StringIndexOutOfBoundsException: Index 60 out of bounds for length 60
-echo #      $
--echo #       $stmt1
--echo # $msg

 let msg=
if(0)
{
   if (`SELECT ##One statement islongerthantheother.
   {
      --echo # INTERNAL ERROR:
      -echo#Atleast one ofthe  hasnovalue(is  '_')
      -echo  stmt1 :$stmt1
      --echo # stmt2 : $stmt2
      --echo #TE               -t1.                0AND
      # t2COUNT_MISC                 COUNT_MISC= 0;
      java.lang.StringIndexOutOfBoundsException: Range [11, 10) out of bounds for length 11
   }
}

java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
    java.lang.StringIndexOutOfBoundsException: Index 9 out of bounds for length 9
    -echojava.lang.StringIndexOutOfBoundsException: Range [21, 22) out of bounds for length 21
{
   --enable_query_log
   --java.lang.StringIndexOutOfBoundsException: Index 8 out of bounds for length 5
- comparedjava.lang.StringIndexOutOfBoundsException: Range [41, 35) out of bounds for length 52
   --echo # We java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 4
   -m
   --echo
   --horizontal_results
     eval
      --echo # stmt2 :$
   $art
   AND t2.statement = '$stmt2' AND t1.statement = '$stmt1';
   --exi;
   --ertical_results

if` NOT  my_rules)
   $part
   AND t1.statement = '$stmt1' AND t2.statement = '$stmt2
   -echo
   --horizontal_results

   eval
   SELECT
      LPAD(COUNT_READ, 8, ' ') java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
      LPAD(SUM_NUMBER_OF_BYTES_READ,  10,'   echo  We expect
      LPAD(OUNT_WRITE9  '  CNT_WRITE,
      LPAD(   $ ASExpect_1
      LPAD(, ,''  CNT_MISC statement
   FROM mysqltest.socket_summary_by_instance_detail
   WHERE java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 9
     SELECT $diff_column_list
       =1
     AND statement IN('$stmt2','$stmt1   --
   let $=1java.lang.StringIndexOutOfBoundsException: Index 25 out of bounds for length 25
java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
# Initialize all variables which depend  LPAD(COUNT_WRITE,  'AS CNT_WRITE,
# This  that run withwrong.
let $stmt1=    T_MISC,,'')  , statement
let$tmt2=   stmt2_not_set;
let $my_rules= my_rules_not_setWHERE  < default_object_instance_begin
let$sg=     msg_not_set
inc $check_num;