adding test scripts
[csql.git] / test / cache / CacheTable / exp.test030.ksh.psql
blobc170520158e42ca13b8a790a5a46936610455c84
1 Table t5 and t6 created in target DB.
2 cachetable -t t5 -D -c "f1>=10"
3 cachetable -t t6 -D -c "f1>=10" 
4 select query on t1 and t2 table
5 Statement Executed: Rows Affected = 1
6 Statement execute failed with error -14
7 Statement Executed: Rows Affected = 1
8 Statement Executed: Rows Affected = 1
9 ---------------------------------------------------------
10         t5.f1   t5.f2   
11 ---------------------------------------------------------
12         10      11      
13         11      12      
14         12      13      
15         13      14      
16         14      15      
17         15      16      
18         
19 ---------------------------------------------------------
20         t6.f1   t6.f2   
21 ---------------------------------------------------------
22         10      11      
23         11      12      
24         12      13      
25         13      14      
26         14      15      
27         15      16      
28         
29 +---------------------------------------+
30 | Connected!                            |
31 |                                       |
32 | sql-statement                         |
33 | help [tablename]                      |
34 | quit                                  |
35 |                                       |
36 +---------------------------------------+
37 \e[?1034hSQL> select * from t5;
38 +------------+------------+
39 | f1         | f2         |
40 +------------+------------+
41 | 5          | 6          |
42 | 6          | 7          |
43 | 7          | 8          |
44 | 8          | 9          |
45 | 9          | 10         |
46 | 10         | 11         |
47 | 11         | 12         |
48 | 12         | 13         |
49 | 13         | 14         |
50 | 14         | 15         |
51 | 15         | 16         |
52 | 16         | 20         |
53 +------------+------------+
54 SQLRowCount returns 12
55 12 rows fetched
56 SQL> select * from t6;
57 +------------+------------+
58 | f1         | f2         |
59 +------------+------------+
60 | 5          | 6          |
61 | 6          | 7          |
62 | 7          | 8          |
63 | 8          | 9          |
64 | 9          | 10         |
65 | 10         | 11         |
66 | 11         | 12         |
67 | 12         | 13         |
68 | 13         | 14         |
69 | 14         | 15         |
70 | 15         | 16         |
71 | 16         | 20         |
72 | 15         | 21         |
73 +------------+------------+
74 SQLRowCount returns 13
75 13 rows fetched
76 SQL>