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