test/cache/Bidirectional/exp.test008.ksh

   1 table csql_log_int is created with records in target db
   2 server 1 started
   3 cache node 2
   4 echo select * from t1;
   5 ---------------------------------------------------------
   6         t1.f1   t1.f2
   7 ---------------------------------------------------------
   8         1       11
   9         2       21
  10         3       31
  11         4       41
  12         5       51
  13         6       61
  14         7       71
  15         8       81
  16         9       91
  17         10      101
  18
  19 echo select * from t2;
  20 ---------------------------------------------------------
  21         t2.f1   t2.f2
  22 ---------------------------------------------------------
  23         1       11
  24         2       21
  25         3       31
  26         4       41
  27         5       51
  28         6       61
  29         7       71
  30         8       81
  31         9       91
  32         10      101
  33
  34 server 2 started
  35 cache node 1
  36 echo select * from t1;
  37 ---------------------------------------------------------
  38         t1.f1   t1.f2
  39 ---------------------------------------------------------
  40         1       11
  41         2       21
  42         3       31
  43         4       41
  44         5       51
  45         6       61
  46         7       71
  47         8       81
  48         9       91
  49         10      101
  50
  51 echo select * from t2;
  52 ---------------------------------------------------------
  53         t2.f1   t2.f2
  54 ---------------------------------------------------------
  55         1       11
  56         2       21
  57         3       31
  58         4       41
  59         5       51
  60         6       61
  61         7       71
  62         8       81
  63         9       91
  64         10      101
  65
  66 cache node 1
  67 echo select * from t1;
  68 ---------------------------------------------------------
  69         t1.f1   t1.f2
  70 ---------------------------------------------------------
  71         1       11
  72         2       21
  73         3       31
  74         4       41
  75         5       51
  76         6       61
  77         7       71
  78         8       81
  79         9       91
  80         10      101
  81         12      123
  82
  83 echo select * from t2;
  84 ---------------------------------------------------------
  85         t2.f1   t2.f2
  86 ---------------------------------------------------------
  87         1       11
  88         2       21
  89         3       31
  90         4       41
  91         5       51
  92         6       61
  93         7       71
  94         8       81
  95         9       91
  96         10      101
  97         15      125
  98
  99 cache node 2
 100 echo select * from t1;
 101 ---------------------------------------------------------
 102         t1.f1   t1.f2
 103 ---------------------------------------------------------
 104         1       11
 105         2       21
 106         3       31
 107         4       41
 108         5       51
 109         6       61
 110         7       71
 111         8       81
 112         9       91
 113         10      101
 114         12      123
 115
 116 echo select * from t2;
 117 ---------------------------------------------------------
 118         t2.f1   t2.f2
 119 ---------------------------------------------------------
 120         1       11
 121         2       21
 122         3       31
 123         4       41
 124         5       51
 125         6       61
 126         7       71
 127         8       81
 128         9       91
 129         10      101
 130         15      125
 131