test/cache/CacheTable/exp.test015.ksh

   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
  18
  19 ---------------------------------------------------------
  20         t2.t2f1 t2.t2f2
  21 ---------------------------------------------------------
  22         1       11
  23         2       21
  24         3       31
  25         4       41
  26