adding test scripts
[csql.git] / test / cache / CacheTable / exp.test012.ksh.x86_64
blobb8c22a963e56286b5880b581115aaf9f4f84eff3
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     
17         
18 ---------------------------------------------------------
19         t2.t2f1 t2.t2f2 
20 ---------------------------------------------------------
21         6       61      
22         7       71      
23         8       81      
24         9       91      
25         10      101     
26         
27 Statement Executed: Rows Affected = 5
28 +---------------------------------------+
29 | Connected!                            |
30 |                                       |
31 | sql-statement                         |
32 | help [tablename]                      |
33 | quit                                  |
34 |                                       |
35 +---------------------------------------+
36 SQL> 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     
53         
54 ---------------------------------------------------------
55         t2.t2f1 t2.t2f2 
56 ---------------------------------------------------------
57         7       71      
58         9       91      
59