test/cache/CacheVerify/exp.test008.ksh

   1
   2 Number of Records:
   3 -------------------+-------------------+-------------------+
   4   Data             |  In CSQL          |  In TargetDB      |
   5 -------------------+-------------------+-------------------+
   6   No. Of Records   |  7                |  8                |
   7 -------------------+-------------------+-------------------+
   8
   9 Number of Records:
  10 -------------------+-------------------+-------------------+
  11   Data             |  In CSQL          |  In TargetDB      |
  12 -------------------+-------------------+-------------------+
  13   No. Of Records   |  7                |  8                |
  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   3                |                   |  X                |
  23   8                |                   |  X                |
  24   4                |  X                |                   |
  25   6                |  X                |                   |
  26   9                |  X                |                   |
  27 -------------------+-------------------+-------------------+
  28
  29 Number of Records:
  30 -------------------+-------------------+-------------------+
  31   Data             |  In CSQL          |  In TargetDB      |
  32 -------------------+-------------------+-------------------+
  33   No. Of Records   |  7                |  8                |
  34 -------------------+-------------------+-------------------+
  35
  36 Primary key field name is 'f1'
  37
  38 Missing Records: Marked by 'X'
  39 -------------------+-------------------+-------------------+
  40   Primary Key      |  In CSQL          |  In Target DB     |
  41 -------------------+-------------------+-------------------+
  42   3                |                   |  X                |
  43   8                |                   |  X                |
  44   4                |  X                |                   |
  45   6                |  X                |                   |
  46   9                |  X                |                   |
  47 -------------------+-------------------+-------------------+
  48
  49 Inconsistent Records for the same key:
  50 -------------------+-------------------+-------------------+-------------------+
  51   Primary Key      |  Field Name       |  In CSQL          |  In Trgt DB       |
  52 -------------------+-------------------+-------------------+-------------------+
  53   2                |  t1.f2            |  2020             |  1978             |
  54   5                |  t1.f4            |  rajani           |  ganesh           |
  55   7                |  t1.f7            |  1975/12/25       |  2020/2/20        |
  56   10               |  t1.f8            |  20:42:35.0       |  20:20:20.0       |
  57 -------------------+-------------------+-------------------+-------------------+