adding test scripts
[csql.git] / test / cache / Durability / exp.test002.ksh.psql
blobd55871ee635aa1bcdc0037a91630b99e2481b878
1 INSERTING 5 RECORDS IN TARGET DB
2 +---------------------------------------+
3 | Connected!                            |
4 |                                       |
5 | sql-statement                         |
6 | help [tablename]                      |
7 | quit                                  |
8 |                                       |
9 +---------------------------------------+
10 \e[?1034hSQL> 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 \e[?1034hSQL> DROP TABLE t1;
83 SQLRowCount returns 0
84 SQL> Statement Executed