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

   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>