test/cache/CacheTable/exp.test012.ksh

   1 table t1 and t2 are created with records in target db
   2 Recovering table t1 NULL NULL
   3 Recovering table t2 t2f1>5 NULL
   4 ---------------------------------------------------------
   5         t1.t1f1 t1.t2f2
   6 ---------------------------------------------------------
   7         1       11
   8         2       21
   9         3       31
  10         4       41
  11         5       51
  12         6       61
  13         7       71
  14         8       81
  15         9       91
  16         10      101
  17
  18 ---------------------------------------------------------
  19         t2.t2f1 t2.t2f2
  20 ---------------------------------------------------------
  21         6       61
  22         7       71
  23         8       81
  24         9       91
  25         10      101
  26
  27 Statement Executed: Rows Affected = 5
  28 +---------------------------------------+
  29 | Connected!                            |
  30 |                                       |
  31 | sql-statement                         |
  32 | help [tablename]                      |
  33 | quit                                  |
  34 |                                       |
  35 +---------------------------------------+
  36 \e[?1034hSQL> delete from t2 where t2f1 in (2,4,6,8,10);
  37 SQLRowCount returns 5
  38 SQL> table t1 reloaded
  39 table t2 reloaded
  40 ---------------------------------------------------------
  41         t1.t1f1 t1.t2f2
  42 ---------------------------------------------------------
  43         1       11
  44         2       21
  45         3       31
  46         4       41
  47         5       51
  48         6       61
  49         7       71
  50         8       81
  51         9       91
  52         10      101
  53
  54 ---------------------------------------------------------
  55         t2.t2f1 t2.t2f2
  56 ---------------------------------------------------------
  57         7       71
  58         9       91
  59