test/cache/CacheTable/exp.test012.ksh.SunOS

   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 SQL> SQLRowCount returns 5
  37 SQL> table t1 reloaded
  38 table t2 reloaded
  39 ---------------------------------------------------------
  40         t1.t1f1 t1.t2f2
  41 ---------------------------------------------------------
  42         1       11
  43         2       21
  44         3       31
  45         4       41
  46         5       51
  47         6       61
  48         7       71
  49         8       81
  50         9       91
  51         10      101
  52
  53 ---------------------------------------------------------
  54         t2.t2f1 t2.t2f2
  55 ---------------------------------------------------------
  56         1       11
  57         3       31
  58         5       51
  59         7       71
  60         9       91
  61