test/cache/Bidirectional/exp.test010.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 Update operation in cache node 1
  67 cache node 1
  68 echo select * from t1;
  69 ---------------------------------------------------------
  70         t1.f1   t1.f2
  71 ---------------------------------------------------------
  72         1       50
  73         2       50
  74         3       50
  75         4       50
  76         5       50
  77         6       61
  78         7       71
  79         8       81
  80         9       91
  81         10      101
  82
  83 echo select * from t2;
  84 ---------------------------------------------------------
  85         t2.f1   t2.f2
  86 ---------------------------------------------------------
  87         1       110
  88         2       110
  89         3       110
  90         4       110
  91         5       110
  92         6       61
  93         7       71
  94         8       81
  95         9       91
  96         10      101
  97
  98 cache node 2
  99 echo select * from t1;
 100 ---------------------------------------------------------
 101         t1.f1   t1.f2
 102 ---------------------------------------------------------
 103         1       50
 104         2       50
 105         3       50
 106         4       50
 107         5       50
 108         6       61
 109         7       71
 110         8       81
 111         9       91
 112         10      101
 113
 114 echo select * from t2;
 115 ---------------------------------------------------------
 116         t2.f1   t2.f2
 117 ---------------------------------------------------------
 118         1       110
 119         2       110
 120         3       110
 121         4       110
 122         5       110
 123         6       61
 124         7       71
 125         8       81
 126         9       91
 127         10      101
 128