test/cache/Durability/exp.test002.ksh.SunOS

   1 INSERTING 5 RECORDS IN TARGET DB
   2 +---------------------------------------+
   3 | Connected!                            |
   4 |                                       |
   5 | sql-statement                         |
   6 | help [tablename]                      |
   7 | quit                                  |
   8 |                                       |
   9 +---------------------------------------+
  10 SQL> +-----------+---------------------+-----------+
  11 | f1        | f2                  | f3        |
  12 +-----------+---------------------+-----------+
  13 | 1         | Bijay               | 10        |
  14 | 2         | Jiten               | 20        |
  15 | 3         | Praba               | 30        |
  16 | 4         | Kisor               | 40        |
  17 | 5         | Nihar               | 50        |
  18 +-----------+---------------------+-----------+
  19 SQLRowCount returns 5
  20 5 rows fetched
  21 SQL> CACHING THROUGH SITE1
  22 cachetable -U root -P manager -t t1
  23 Statement Executed
  24 Statement Executed: Rows Affected = 1
  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 Server Killed
  30
  31 Durablity = TRUE
  32 Server Started
  33 Checking Durability
  34 Durability Works Fine
  35 INSERTING 5 RECORDS IN CACHED TABLE t1 AT CSQL
  36 Statement Executed: Rows Affected = 1
  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 INSERTING 5 RECORDS AT NON CACHED TABLE t2 AT CSQL
  42 Statement Executed: Rows Affected = 1
  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 Server Killed
  48
  49 Durablity = TRUE
  50 Server Started
  51 Checking Durability
  52 Durability Works Fine
  53 UPDATING 5 RECORDS IN CACHED TABLE t1 AT CSQL
  54 Statement Executed: Rows Affected = 5
  55 UPDATING 5 RECORDS AT NON CACHED TABLE t2 AT CSQL
  56 Statement Executed: Rows Affected = 5
  57 Server Killed
  58
  59 Durablity = TRUE
  60 Server Started
  61 Checking Durability
  62 Durability Works Fine
  63 DELETING 7 RECORDS IN CACHED TABLE t1 AT CSQL
  64 Statement Executed: Rows Affected = 7
  65 DELETING 7 RECORDS AT NON CACHED TABLE t2 AT CSQL
  66 Statement Executed: Rows Affected = 7
  67 Server Killed
  68
  69 Durablity = TRUE
  70 Server Started
  71 Checking Durability
  72 Durability Works Fine
  73 +---------------------------------------+
  74 | Connected!                            |
  75 |                                       |
  76 | sql-statement                         |
  77 | help [tablename]                      |
  78 | quit                                  |
  79 |                                       |
  80 +---------------------------------------+
  81 SQL> SQLRowCount returns 0
  82 SQL> Statement Executed