test/cache/Durability/exp.test001.ksh

   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