adding test scripts
[csql.git] / test / cache / CacheTable / exp.test012.ksh
blobd1d20124e143b55bdfe0949921ca54326ed1b0f5
1 table t1 and t2 are created with records in target db
2 Recovering table t1 NULL NULL
3 Recovering table t2 t2f1>5 NULL
4 ---------------------------------------------------------
5 t1.t1f1 t1.t2f2
6 ---------------------------------------------------------
7 1 11
8 2 21
9 3 31
10 4 41
11 5 51
12 6 61
13 7 71
14 8 81
15 9 91
16 10 101
18 ---------------------------------------------------------
19 t2.t2f1 t2.t2f2
20 ---------------------------------------------------------
21 6 61
22 7 71
23 8 81
24 9 91
25 10 101
27 Statement Executed: Rows Affected = 5
28 +---------------------------------------+
29 | Connected! |
30 | |
31 | sql-statement |
32 | help [tablename] |
33 | quit |
34 | |
35 +---------------------------------------+
36 \e[?1034hSQL> delete from t2 where t2f1 in (2,4,6,8,10);
37 SQLRowCount returns 5
38 SQL> table t1 reloaded
39 table t2 reloaded
40 ---------------------------------------------------------
41 t1.t1f1 t1.t2f2
42 ---------------------------------------------------------
43 1 11
44 2 21
45 3 31
46 4 41
47 5 51
48 6 61
49 7 71
50 8 81
51 9 91
52 10 101
54 ---------------------------------------------------------
55 t2.t2f1 t2.t2f2
56 ---------------------------------------------------------
57 7 71
58 9 91