test/cache/CacheTable/exp.test024.ksh

   1 Table t1 and t2 created in target DB.
   2 cachetable -t t1 -c "t1f1<5"
   3 cachetable -t t2 -c "t2f1>15" -f "t2f1,t2f3,t2f5"
   4 select query on t1 and t2 table
   5 ---------------------------------------------------------
   6         t1.t1f1 t1.t1f2 t1.t1f3 t1.t1f4 t1.t1f5
   7 ---------------------------------------------------------
   8         1       fmode   11      test    111
   9         2       fmode   22      test    222
  10         3       fmode   33      test    333
  11         4       fmode   44      test    444
  12
  13 ---------------------------------------------------------
  14         t2.t2f1 t2.t2f3 t2.t2f5
  15 ---------------------------------------------------------
  16         16      116     1116
  17         17      117     1117
  18         18      118     1118
  19         19      119     1119
  20         20      220     1120
  21