test/cache/CacheTable/exp.test030.ksh.psql

   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         t5.f1   t5.f2
  11 ---------------------------------------------------------
  12         10      11
  13         11      12
  14         12      13
  15         13      14
  16         14      15
  17         15      16
  18
  19 ---------------------------------------------------------
  20         t6.f1   t6.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>