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 ---------------------------------------------------------
11 ---------------------------------------------------------
19 ---------------------------------------------------------
21 ---------------------------------------------------------
29 +---------------------------------------+
36 +---------------------------------------+
37 \e[?1034hSQL> select * from t5;
38 +------------+------------+
40 +------------+------------+
53 +------------+------------+
54 SQLRowCount returns 12
56 SQL> select * from t6;
57 +------------+------------+
59 +------------+------------+
73 +------------+------------+
74 SQLRowCount returns 13