adding test scripts
[csql.git] / test / cache / Durability / exp.test001.ksh
bloba4eef4f6b7fd8ee57c364d7d4943d50b072f34f4
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