adding test scripts
[csql.git] / test / cache / Durability / exp.test001.ksh.psql
blob0729fe9d9a15c2b7eeeab004f75b41f51a56daed
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 +---------------------------------------+
37 | Connected!                            |
38 |                                       |
39 | sql-statement                         |
40 | help [tablename]                      |
41 | quit                                  |
42 |                                       |
43 +---------------------------------------+
44 \e[?1034hSQL> DROP TABLE t1;
45 SQLRowCount returns 0
46 SQL> Statement Executed