test/cache/CacheTable/exp.test030.ksh

   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 Executed: Rows Affected = 1
   6 Statement execute failed with error -14
   7 Statement Executed: Rows Affected = 1
   8 Statement Executed: Rows Affected = 1
   9 ---------------------------------------------------------
  10         f1      f2
  11 ---------------------------------------------------------
  12         10      11
  13         11      12
  14         12      13
  15         13      14
  16         14      15
  17         15      16
  18
  19 ---------------------------------------------------------
  20         f1      f2
  21 ---------------------------------------------------------
  22         10      11
  23         11      12
  24         12      13
  25         13      14
  26         14      15
  27         15      16
  28
  29 +---------------------------------------+
  30 | Connected!                            |
  31 |                                       |
  32 | sql-statement                         |
  33 | help [tablename]                      |
  34 | quit                                  |
  35 |                                       |
  36 +---------------------------------------+
  37 \e[?1034hSQL> select * from t5;
  38 +-----------+-----------+
  39 | f1        | f2        |
  40 +-----------+-----------+
  41 | 5         | 6         |
  42 | 6         | 7         |
  43 | 7         | 8         |
  44 | 8         | 9         |
  45 | 9         | 10        |
  46 | 10        | 11        |
  47 | 11        | 12        |
  48 | 12        | 13        |
  49 | 13        | 14        |
  50 | 14        | 15        |
  51 | 15        | 16        |
  52 | 16        | 20        |
  53 +-----------+-----------+
  54 SQLRowCount returns 12
  55 12 rows fetched
  56 SQL> select * from t6;
  57 +-----------+-----------+
  58 | f1        | f2        |
  59 +-----------+-----------+
  60 | 5         | 6         |
  61 | 6         | 7         |
  62 | 7         | 8         |
  63 | 8         | 9         |
  64 | 9         | 10        |
  65 | 10        | 11        |
  66 | 11        | 12        |
  67 | 12        | 13        |
  68 | 13        | 14        |
  69 | 14        | 15        |
  70 | 15        | 16        |
  71 | 16        | 20        |
  72 | 15        | 21        |
  73 +-----------+-----------+
  74 SQLRowCount returns 13
  75 13 rows fetched
  76 SQL>