test/cache/Durability/exp.test002.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 INSERTING 5 RECORDS IN CACHED TABLE t1 AT CSQL
  37 Statement Executed: Rows Affected = 1
  38 Statement Executed: Rows Affected = 1
  39 Statement Executed: Rows Affected = 1
  40 Statement Executed: Rows Affected = 1
  41 Statement Executed: Rows Affected = 1
  42 INSERTING 5 RECORDS AT NON CACHED TABLE t2 AT CSQL
  43 Statement Executed: Rows Affected = 1
  44 Statement Executed: Rows Affected = 1
  45 Statement Executed: Rows Affected = 1
  46 Statement Executed: Rows Affected = 1
  47 Statement Executed: Rows Affected = 1
  48 Server Killed
  49
  50 Durablity = TRUE
  51 Server Started
  52 Checking Durability
  53 Durability Works Fine
  54 UPDATING 5 RECORDS IN CACHED TABLE t1 AT CSQL
  55 Statement Executed: Rows Affected = 5
  56 UPDATING 5 RECORDS AT NON CACHED TABLE t2 AT CSQL
  57 Statement Executed: Rows Affected = 5
  58 Server Killed
  59
  60 Durablity = TRUE
  61 Server Started
  62 Checking Durability
  63 Durability Works Fine
  64 DELETING 7 RECORDS IN CACHED TABLE t1 AT CSQL
  65 Statement Executed: Rows Affected = 7
  66 DELETING 7 RECORDS AT NON CACHED TABLE t2 AT CSQL
  67 Statement Executed: Rows Affected = 7
  68 Server Killed
  69
  70 Durablity = TRUE
  71 Server Started
  72 Checking Durability
  73 Durability Works Fine
  74 +---------------------------------------+
  75 | Connected!                            |
  76 |                                       |
  77 | sql-statement                         |
  78 | help [tablename]                      |
  79 | quit                                  |
  80 |                                       |
  81 +---------------------------------------+
  82 \e[?1034hSQL> DROP TABLE t1;
  83 SQLRowCount returns 0
  84 SQL> Statement Executed