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 prepare failed with error -31
6 Statement prepare failed with error -31
7 Statement prepare failed with error -31
8 Statement prepare failed with error -31
9 ---------------------------------------------------------
11 ---------------------------------------------------------
19 ---------------------------------------------------------
21 ---------------------------------------------------------
29 +---------------------------------------+
36 +---------------------------------------+
37 SQL> +-----------+-----------+
39 +-----------+-----------+
51 +-----------+-----------+
52 SQLRowCount returns 11
54 SQL> +-----------+-----------+
56 +-----------+-----------+
68 +-----------+-----------+
69 SQLRowCount returns 11