adding test scripts
[csql.git] / test / cache / Durability / exp.test002.ksh.SunOS
blob864988b977bb4e5d4afb9ce8d4687b9d5561f089
1 INSERTING 5 RECORDS IN TARGET DB
2 +---------------------------------------+
3 | Connected!                            |
4 |                                       |
5 | sql-statement                         |
6 | help [tablename]                      |
7 | quit                                  |
8 |                                       |
9 +---------------------------------------+
10 SQL> +-----------+---------------------+-----------+
11 | f1        | f2                  | f3        |
12 +-----------+---------------------+-----------+
13 | 1         | Bijay               | 10        |
14 | 2         | Jiten               | 20        |
15 | 3         | Praba               | 30        |
16 | 4         | Kisor               | 40        |
17 | 5         | Nihar               | 50        |
18 +-----------+---------------------+-----------+
19 SQLRowCount returns 5
20 5 rows fetched
21 SQL> CACHING THROUGH SITE1
22 cachetable -U root -P manager -t t1
23 Statement Executed
24 Statement Executed: Rows Affected = 1
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 Server Killed
31 Durablity = TRUE
32 Server Started
33 Checking Durability
34 Durability Works Fine
35 INSERTING 5 RECORDS IN CACHED TABLE t1 AT CSQL
36 Statement Executed: Rows Affected = 1
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 INSERTING 5 RECORDS AT NON CACHED TABLE t2 AT CSQL
42 Statement Executed: Rows Affected = 1
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 Server Killed
49 Durablity = TRUE
50 Server Started
51 Checking Durability
52 Durability Works Fine
53 UPDATING 5 RECORDS IN CACHED TABLE t1 AT CSQL
54 Statement Executed: Rows Affected = 5
55 UPDATING 5 RECORDS AT NON CACHED TABLE t2 AT CSQL
56 Statement Executed: Rows Affected = 5
57 Server Killed
59 Durablity = TRUE
60 Server Started
61 Checking Durability
62 Durability Works Fine
63 DELETING 7 RECORDS IN CACHED TABLE t1 AT CSQL
64 Statement Executed: Rows Affected = 7
65 DELETING 7 RECORDS AT NON CACHED TABLE t2 AT CSQL
66 Statement Executed: Rows Affected = 7
67 Server Killed
69 Durablity = TRUE
70 Server Started
71 Checking Durability
72 Durability Works Fine
73 +---------------------------------------+
74 | Connected!                            |
75 |                                       |
76 | sql-statement                         |
77 | help [tablename]                      |
78 | quit                                  |
79 |                                       |
80 +---------------------------------------+
81 SQL> SQLRowCount returns 0
82 SQL> Statement Executed