test/cache/CacheVerify/exp.test009.ksh

   1
   2 Number of Records:
   3 -------------------+-------------------+-------------------+
   4   Data             |  In CSQL          |  In TargetDB      |
   5 -------------------+-------------------+-------------------+
   6   No. Of Records   |  10               |  10               |
   7 -------------------+-------------------+-------------------+
   8
   9 Number of Records:
  10 -------------------+-------------------+-------------------+
  11   Data             |  In CSQL          |  In TargetDB      |
  12 -------------------+-------------------+-------------------+
  13   No. Of Records   |  10               |  10               |
  14 -------------------+-------------------+-------------------+
  15
  16 Primary key field name is 'f1'
  17
  18 Missing Records: Marked by 'X'
  19 -------------------+-------------------+-------------------+
  20   Primary Key      |  In CSQL          |  In Target DB     |
  21 -------------------+-------------------+-------------------+
  22   No missing Records in either of the databases            |
  23 -------------------+-------------------+-------------------+
  24
  25 Number of Records:
  26 -------------------+-------------------+-------------------+
  27   Data             |  In CSQL          |  In TargetDB      |
  28 -------------------+-------------------+-------------------+
  29   No. Of Records   |  10               |  10               |
  30 -------------------+-------------------+-------------------+
  31
  32 Primary key field name is 'f1'
  33
  34 Missing Records: Marked by 'X'
  35 -------------------+-------------------+-------------------+
  36   Primary Key      |  In CSQL          |  In Target DB     |
  37 -------------------+-------------------+-------------------+
  38   No missing Records in either of the databases            |
  39 -------------------+-------------------+-------------------+
  40
  41 Inconsistent Records for the same key:
  42 -------------------+-------------------+-------------------+-------------------+
  43   Primary Key      |  Field Name       |  In CSQL          |  In Trgt DB       |
  44 -------------------+-------------------+-------------------+-------------------+
  45   2                |  t1.f2            |  2020             |  1978             |
  46   5                |  t1.f4            |  rajani           |  ganesh           |
  47   7                |  t1.f7            |  1975/12/25       |  2020/2/20        |
  48   10               |  t1.f8            |  20:42:35.0       |  20:20:20.0       |
  49 -------------------+-------------------+-------------------+-------------------+