adding test scripts
[csql.git] / test / cache / Bidirectional / exp.test012.ksh
blob86b88b2b53c610e77e581efa01e190677ba2a8dd
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
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
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
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
66 Delete operation in cache node 1
67 cache node 1
68 echo select * from t1;
69 ---------------------------------------------------------
70 t1.f1 t1.f2
71 ---------------------------------------------------------
72 1 11
73 2 21
74 3 31
75 4 41
76 5 51
77 6 61
78 7 71
80 echo select * from t2;
81 ---------------------------------------------------------
82 t2.f1 t2.f2
83 ---------------------------------------------------------
84 7 71
85 8 81
86 9 91
87 10 101
89 cache node 2
90 echo select * from t1;
91 ---------------------------------------------------------
92 t1.f1 t1.f2
93 ---------------------------------------------------------
94 1 11
95 2 21
96 3 31
97 4 41
98 5 51
99 6 61
100 7 71
102 echo select * from t2;
103 ---------------------------------------------------------
104 t2.f1 t2.f2
105 ---------------------------------------------------------
106 7 71
107 8 81
108 9 91
109 10 101