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

   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 +------------+
  97 SQLRowCount returns 2
  98 2 rows fetched
  99 SQL> Statement Executed
 100 +---------------------------------------+
 101 | Connected!                            |
 102 |                                       |
 103 | sql-statement                         |
 104 | help [tablename]                      |
 105 | quit                                  |
 106 |                                       |
 107 +---------------------------------------+
 108 \e[?1034hSQL> DROP TABLE t1;
 109 SQLRowCount returns 0
 110 SQL>