test/cache/Durability/exp.test004.ksh

   1 INSERTING 1 RECORDS IN TARGET DB
   2 +---------------------------------------+
   3 | Connected!                            |
   4 |                                       |
   5 | sql-statement                         |
   6 | help [tablename]                      |
   7 | quit                                  |
   8 |                                       |
   9 +---------------------------------------+
  10 \e[?1034hSQL> CREATE TABLE t1(f1 int);
  11 SQLRowCount returns 0
  12 SQL> INSERT INTO t1 values(1);
  13 SQLRowCount returns 1
  14 SQL> +---------------------------------------+
  15 | Connected!                            |
  16 |                                       |
  17 | sql-statement                         |
  18 | help [tablename]                      |
  19 | quit                                  |
  20 |                                       |
  21 +---------------------------------------+
  22 \e[?1034hSQL> SELECT * FROM t1;
  23 +-----------+
  24 | f1        |
  25 +-----------+
  26 | 1         |
  27 +-----------+
  28 SQLRowCount returns 1
  29 1 rows fetched
  30 SQL> CACHING THROUGH SITE1
  31 cachetable -U root -P manager -t t1
  32 ---------------------------------------------------------
  33         t1.f1
  34 ---------------------------------------------------------
  35         1
  36
  37 INSERTING 1 RECORD IN CACHED TABLE t1 AT CSQL
  38 Statement Executed: Rows Affected = 1
  39 AFTER INSERT AT CSQL DATA IN CSQL
  40 ---------------------------------------------------------
  41         t1.f1
  42 ---------------------------------------------------------
  43         1
  44         2
  45
  46 AFTER INSERT AT CSQL DATA IN TDB
  47 +---------------------------------------+
  48 | Connected!                            |
  49 |                                       |
  50 | sql-statement                         |
  51 | help [tablename]                      |
  52 | quit                                  |
  53 |                                       |
  54 +---------------------------------------+
  55 \e[?1034hSQL> SELECT * FROM t1;
  56 +-----------+
  57 | f1        |
  58 +-----------+
  59 | 1         |
  60 | 2         |
  61 +-----------+
  62 SQLRowCount returns 2
  63 2 rows fetched
  64 SQL> Server Killed
  65
  66 Durablity = TRUE
  67 Cache_table = FALSE
  68 Server Started
  69 Checking Durability
  70 Durability Works Fine
  71 INSERTING ANOTHER RECORD IN CACHED TABLE t1 AT CSQL
  72 Statement Executed: Rows Affected = 1
  73 AFTER INSERT AT CSQL DATA IN CSQL
  74 ---------------------------------------------------------
  75         t1.f1
  76 ---------------------------------------------------------
  77         1
  78         2
  79         3
  80
  81 AFTER INSERT AT CSQL DATA IN TDB
  82 +---------------------------------------+
  83 | Connected!                            |
  84 |                                       |
  85 | sql-statement                         |
  86 | help [tablename]                      |
  87 | quit                                  |
  88 |                                       |
  89 +---------------------------------------+
  90 \e[?1034hSQL> SELECT * FROM t1;
  91 +-----------+
  92 | f1        |
  93 +-----------+
  94 | 1         |
  95 | 2         |
  96 | 3         |
  97 +-----------+
  98 SQLRowCount returns 3
  99 3 rows fetched
 100 SQL> Statement Executed
 101 +---------------------------------------+
 102 | Connected!                            |
 103 |                                       |
 104 | sql-statement                         |
 105 | help [tablename]                      |
 106 | quit                                  |
 107 |                                       |
 108 +---------------------------------------+
 109 \e[?1034hSQL> DROP TABLE t1;
 110 SQLRowCount returns 0
 111 SQL>