test/cache/Durability/exp.test001.ksh.psql

   1 INSERTING 5 RECORDS IN TARGET DB
   2 +---------------------------------------+
   3 | Connected!                            |
   4 |                                       |
   5 | sql-statement                         |
   6 | help [tablename]                      |
   7 | quit                                  |
   8 |                                       |
   9 +---------------------------------------+
  10 \e[?1034hSQL> SELECT * FROM t1;
  11 +------------+---------------------+------------+
  12 | f1         | f2                  | f3         |
  13 +------------+---------------------+------------+
  14 | 1          | Bijay               | 10         |
  15 | 2          | Jiten               | 20         |
  16 | 3          | Praba               | 30         |
  17 | 4          | Kisor               | 40         |
  18 | 5          | Nihar               | 50         |
  19 +------------+---------------------+------------+
  20 SQLRowCount returns 5
  21 5 rows fetched
  22 SQL> CACHING THROUGH SITE1
  23 cachetable -U root -P manager -t t1
  24 Statement Executed
  25 Statement Executed: Rows Affected = 1
  26 Statement Executed: Rows Affected = 1
  27 Statement Executed: Rows Affected = 1
  28 Statement Executed: Rows Affected = 1
  29 Statement Executed: Rows Affected = 1
  30 Server Killed
  31
  32 Durablity = TRUE
  33 Server Started
  34 Checking Durability
  35 Durability Works Fine
  36 +---------------------------------------+
  37 | Connected!                            |
  38 |                                       |
  39 | sql-statement                         |
  40 | help [tablename]                      |
  41 | quit                                  |
  42 |                                       |
  43 +---------------------------------------+
  44 \e[?1034hSQL> DROP TABLE t1;
  45 SQLRowCount returns 0
  46 SQL> Statement Executed