adding test scripts
[csql.git] / test / cache / Durability / exp.test002.ksh.x86_64
blob2a3d9edef325c82fc1500d85f7254fabd25212b1
1 INSERTING 5 RECORDS IN TARGET DB
2 +---------------------------------------+
3 | Connected!                            |
4 |                                       |
5 | sql-statement                         |
6 | help [tablename]                      |
7 | quit                                  |
8 |                                       |
9 +---------------------------------------+
10 SQL> SELECT * FROM t1;
11 +-----------+---------------------+-----------+
12 | f1        | f2                  | f3        |
13 +-----------+---------------------+-----------+
14 | 1         | Bijay               | 10        |
15 | 2         | Jiten               | 20        |
16 | 3         | Praba               | 30        |
17 | 4         | Kisor               | 40        |
18 | 5         | Nihar               | 50        |
19 +-----------+---------------------+-----------+
20 SQLRowCount returns 5
21 5 rows fetched
22 SQL> CACHING THROUGH SITE1
23 cachetable -U root -P manager -t t1
24 Statement Executed
25 Statement Executed: Rows Affected = 1
26 Statement Executed: Rows Affected = 1
27 Statement Executed: Rows Affected = 1
28 Statement Executed: Rows Affected = 1
29 Statement Executed: Rows Affected = 1
30 Server Killed
32 Durablity = TRUE
33 Server Started
34 Checking Durability
35 Durability Works Fine
36 INSERTING 5 RECORDS IN CACHED TABLE t1 AT CSQL
37 Statement Executed: Rows Affected = 1
38 Statement Executed: Rows Affected = 1
39 Statement Executed: Rows Affected = 1
40 Statement Executed: Rows Affected = 1
41 Statement Executed: Rows Affected = 1
42 INSERTING 5 RECORDS AT NON CACHED TABLE t2 AT CSQL
43 Statement Executed: Rows Affected = 1
44 Statement Executed: Rows Affected = 1
45 Statement Executed: Rows Affected = 1
46 Statement Executed: Rows Affected = 1
47 Statement Executed: Rows Affected = 1
48 Server Killed
50 Durablity = TRUE
51 Server Started
52 Checking Durability
53 Durability Works Fine
54 UPDATING 5 RECORDS IN CACHED TABLE t1 AT CSQL
55 Statement Executed: Rows Affected = 5
56 UPDATING 5 RECORDS AT NON CACHED TABLE t2 AT CSQL
57 Statement Executed: Rows Affected = 5
58 Server Killed
60 Durablity = TRUE
61 Server Started
62 Checking Durability
63 Durability Works Fine
64 DELETING 7 RECORDS IN CACHED TABLE t1 AT CSQL
65 Statement Executed: Rows Affected = 7
66 DELETING 7 RECORDS AT NON CACHED TABLE t2 AT CSQL
67 Statement Executed: Rows Affected = 7
68 Server Killed
70 Durablity = TRUE
71 Server Started
72 Checking Durability
73 Durability Works Fine
74 +---------------------------------------+
75 | Connected!                            |
76 |                                       |
77 | sql-statement                         |
78 | help [tablename]                      |
79 | quit                                  |
80 |                                       |
81 +---------------------------------------+
82 SQL> DROP TABLE t1;
83 SQLRowCount returns 0
84 SQL> Statement Executed