adding test scripts
[csql.git] / test / cache / CacheTable / exp.test015.ksh
blobfcd7d4eba56ec60470682e69342c094b9e60466d
1 Table t1 and t2 created in target DB.
2 cachetable -t t1
3 cachetable -t t2 -c "t2f1<5"
4 select query on t1 and t2 table
5 ---------------------------------------------------------
6 t1.t1f1 t1.t2f2
7 ---------------------------------------------------------
8 1 11
9 2 21
10 3 31
11 4 41
12 5 51
13 6 61
14 7 71
15 8 81
16 9 91
17 10 101
19 ---------------------------------------------------------
20 t2.t2f1 t2.t2f2
21 ---------------------------------------------------------
22 1 11
23 2 21
24 3 31
25 4 41