test/cache/CacheVerify/exp.test011.ksh

   1 cacheverify -t t1
   2
   3 Number of Records:
   4 -------------------+-------------------+-------------------+
   5   Data             |  In CSQL          |  In TargetDB      |
   6 -------------------+-------------------+-------------------+
   7   No. Of Records   |  5                |  5                |
   8 -------------------+-------------------+-------------------+
   9 cacheverify -t t1 -p
  10
  11 Number of Records:
  12 -------------------+-------------------+-------------------+
  13   Data             |  In CSQL          |  In TargetDB      |
  14 -------------------+-------------------+-------------------+
  15   No. Of Records   |  5                |  5                |
  16 -------------------+-------------------+-------------------+
  17
  18 Primary key field name is 'f2'
  19
  20 Missing Records: Marked by 'X'
  21 -------------------+-------------------+-------------------+
  22   Primary Key      |  In CSQL          |  In Target DB     |
  23 -------------------+-------------------+-------------------+
  24   No missing Records in either of the databases            |
  25 -------------------+-------------------+-------------------+
  26 cacheverify -t t1 -f
  27
  28 Number of Records:
  29 -------------------+-------------------+-------------------+
  30   Data             |  In CSQL          |  In TargetDB      |
  31 -------------------+-------------------+-------------------+
  32   No. Of Records   |  5                |  5                |
  33 -------------------+-------------------+-------------------+
  34
  35 Primary key field name is 'f2'
  36
  37 Missing Records: Marked by 'X'
  38 -------------------+-------------------+-------------------+
  39   Primary Key      |  In CSQL          |  In Target DB     |
  40 -------------------+-------------------+-------------------+
  41   No missing Records in either of the databases            |
  42 -------------------+-------------------+-------------------+
  43
  44 Inconsistent Records for the same key:
  45 -------------------+-------------------+-------------------+-------------------+
  46   Primary Key      |  Field Name       |  In CSQL          |  In Trgt DB       |
  47 -------------------+-------------------+-------------------+-------------------+
  48                   The data is consistent in both the databases                 |
  49 -------------------+-------------------+-------------------+-------------------+
  50 updating 2 records in csql through gateway
  51 cacheverify -t t1 -f
  52
  53 Number of Records:
  54 -------------------+-------------------+-------------------+
  55   Data             |  In CSQL          |  In TargetDB      |
  56 -------------------+-------------------+-------------------+
  57   No. Of Records   |  5                |  5                |
  58 -------------------+-------------------+-------------------+
  59
  60 Primary key field name is 'f2'
  61
  62 Missing Records: Marked by 'X'
  63 -------------------+-------------------+-------------------+
  64   Primary Key      |  In CSQL          |  In Target DB     |
  65 -------------------+-------------------+-------------------+
  66   No missing Records in either of the databases            |
  67 -------------------+-------------------+-------------------+
  68
  69 Inconsistent Records for the same key:
  70 -------------------+-------------------+-------------------+-------------------+
  71   Primary Key      |  Field Name       |  In CSQL          |  In Trgt DB       |
  72 -------------------+-------------------+-------------------+-------------------+
  73                   The data is consistent in both the databases                 |
  74 -------------------+-------------------+-------------------+-------------------+
  75 deleting 2 records in csql through gateway
  76 cacheverify -t t1 -p
  77
  78 Number of Records:
  79 -------------------+-------------------+-------------------+
  80   Data             |  In CSQL          |  In TargetDB      |
  81 -------------------+-------------------+-------------------+
  82   No. Of Records   |  3                |  3                |
  83 -------------------+-------------------+-------------------+
  84
  85 Primary key field name is 'f2'
  86
  87 Missing Records: Marked by 'X'
  88 -------------------+-------------------+-------------------+
  89   Primary Key      |  In CSQL          |  In Target DB     |
  90 -------------------+-------------------+-------------------+
  91   No missing Records in either of the databases            |
  92 -------------------+-------------------+-------------------+
  93 updating 2 records in mysql
  94 cacheverify -t t1 -f
  95
  96 Number of Records:
  97 -------------------+-------------------+-------------------+
  98   Data             |  In CSQL          |  In TargetDB      |
  99 -------------------+-------------------+-------------------+
 100   No. Of Records   |  3                |  3                |
 101 -------------------+-------------------+-------------------+
 102
 103 Primary key field name is 'f2'
 104
 105 Missing Records: Marked by 'X'
 106 -------------------+-------------------+-------------------+
 107   Primary Key      |  In CSQL          |  In Target DB     |
 108 -------------------+-------------------+-------------------+
 109   No missing Records in either of the databases            |
 110 -------------------+-------------------+-------------------+
 111
 112 Inconsistent Records for the same key:
 113 -------------------+-------------------+-------------------+-------------------+
 114   Primary Key      |  Field Name       |  In CSQL          |  In Trgt DB       |
 115 -------------------+-------------------+-------------------+-------------------+
 116   1                |  t1.f5            |  100.111000       |  150.000000       |
 117   2                |  t1.f5            |  200.222000       |  150.000000       |
 118 -------------------+-------------------+-------------------+-------------------+
 119 deleting 2 records in mysql
 120 cacheverify -t t1 -p
 121
 122 Number of Records:
 123 -------------------+-------------------+-------------------+
 124   Data             |  In CSQL          |  In TargetDB      |
 125 -------------------+-------------------+-------------------+
 126   No. Of Records   |  3                |  1                |
 127 -------------------+-------------------+-------------------+
 128
 129 Primary key field name is 'f2'
 130
 131 Missing Records: Marked by 'X'
 132 -------------------+-------------------+-------------------+
 133   Primary Key      |  In CSQL          |  In Target DB     |
 134 -------------------+-------------------+-------------------+
 135   1                |                   |  X                |
 136   2                |                   |  X                |
 137 -------------------+-------------------+-------------------+