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

   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 prepare failed with error -31
   6 Statement prepare failed with error -31
   7 Statement prepare failed with error -31
   8 Statement prepare failed with error -31
   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 SQL> +-----------+-----------+
  38 | f1        | f2        |
  39 +-----------+-----------+
  40 | 5         | 6         |
  41 | 6         | 7         |
  42 | 7         | 8         |
  43 | 8         | 9         |
  44 | 9         | 10        |
  45 | 10        | 11        |
  46 | 11        | 12        |
  47 | 12        | 13        |
  48 | 13        | 14        |
  49 | 14        | 15        |
  50 | 15        | 16        |
  51 +-----------+-----------+
  52 SQLRowCount returns 11
  53 11 rows fetched
  54 SQL> +-----------+-----------+
  55 | f1        | f2        |
  56 +-----------+-----------+
  57 | 5         | 6         |
  58 | 6         | 7         |
  59 | 7         | 8         |
  60 | 8         | 9         |
  61 | 9         | 10        |
  62 | 10        | 11        |
  63 | 11        | 12        |
  64 | 12        | 13        |
  65 | 13        | 14        |
  66 | 14        | 15        |
  67 | 15        | 16        |
  68 +-----------+-----------+
  69 SQLRowCount returns 11
  70 11 rows fetched
  71 SQL>