test/cache/CacheTable/exp.test029.ksh

   1 Table t1 and t2 created in target DB.
   2 cachetable -t t5 -D
   3 cachetable -t t6 -D
   4 select query on t1 and t2 table
   5 Statement Executed: Rows Affected = 1
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed: Rows Affected = 1
   8 Statement Executed: Rows Affected = 1
   9 ---------------------------------------------------------
  10         t5.f1   t5.f2
  11 ---------------------------------------------------------
  12
  13 ---------------------------------------------------------
  14         t6.f1   t6.f2
  15 ---------------------------------------------------------
  16
  17 +---------------------------------------+
  18 | Connected!                            |
  19 |                                       |
  20 | sql-statement                         |
  21 | help [tablename]                      |
  22 | quit                                  |
  23 |                                       |
  24 +---------------------------------------+
  25 \e[?1034hSQL> select * from t5;
  26 +-----------+-----------+
  27 | f1        | f2        |
  28 +-----------+-----------+
  29 | 15        | 20        |
  30 | 16        | 21        |
  31 +-----------+-----------+
  32 SQLRowCount returns 2
  33 2 rows fetched
  34 SQL> select * from t6;
  35 +-----------+-----------+
  36 | f1        | f2        |
  37 +-----------+-----------+
  38 | 15        | 20        |
  39 | 16        | 21        |
  40 +-----------+-----------+
  41 SQLRowCount returns 2
  42 2 rows fetched
  43 SQL>