test/cache/CacheTable/exp.test045.ksh

   1 CREATING TABLE t1 and INSERTING 1 RECORDS IN TARGET DB
   2 +---------------------------------------+
   3 | Connected!                            |
   4 |                                       |
   5 | sql-statement                         |
   6 | help [tablename]                      |
   7 | quit                                  |
   8 |                                       |
   9 +---------------------------------------+
  10 \e[?1034hSQL> echo create table t1(f1 int);
  11 SQL> create table t1(f1 int);
  12 SQLRowCount returns 0
  13 SQL> echo insert into t1 values(1);
  14 SQL> insert into t1 values(1);
  15 SQLRowCount returns 1
  16 SQL> echo select * from t1;
  17 SQL> select * from t1;
  18 +-----------+
  19 | f1        |
  20 +-----------+
  21 | 1         |
  22 +-----------+
  23 SQLRowCount returns 1
  24 1 rows fetched
  25 SQL> CREATING TABLE t1 and INSERTING 1 RECORDS AT CSQL
  26 echo create table t1(f1 int);
  27 Statement Executed
  28 echo insert into t1 values(2);
  29 Statement Executed: Rows Affected = 1
  30 echo select * from t1;
  31 ---------------------------------------------------------
  32         t1.f1
  33 ---------------------------------------------------------
  34         2
  35
  36 AFTER INSERT AT CSQL DATA IN TDB
  37 +---------------------------------------+
  38 | Connected!                            |
  39 |                                       |
  40 | sql-statement                         |
  41 | help [tablename]                      |
  42 | quit                                  |
  43 |                                       |
  44 +---------------------------------------+
  45 \e[?1034hSQL> echo select * from t1;
  46 SQL> select * from t1;
  47 +-----------+
  48 | f1        |
  49 +-----------+
  50 | 1         |
  51 +-----------+
  52 SQLRowCount returns 1
  53 1 rows fetched
  54 SQL> echo drop table t1;
  55 Statement Executed
  56 +---------------------------------------+
  57 | Connected!                            |
  58 |                                       |
  59 | sql-statement                         |
  60 | help [tablename]                      |
  61 | quit                                  |
  62 |                                       |
  63 +---------------------------------------+
  64 \e[?1034hSQL> echo drop table t1;
  65 SQL> drop table t1;
  66 SQLRowCount returns 0
  67 SQL>