test/tools/Pagesize/exp.test001.ksh

   1 echo CREATE TABLE t1(f1 int,f2 char(1000));
   2 Statement Executed
   3 echo CREATE TABLE t2(f1 int,f2 char(1000));
   4 Statement Executed
   5 echo CREATE INDEX idx1 ON t2(f1) HASH UNIQUE;
   6 Statement Executed
   7 echo CREATE TABLE t3(f1 int,f2 char(1000));
   8 Statement Executed
   9 echo CREATE INDEX idx2 ON t3(f1) TREE UNIQUE;
  10 Statement Executed
  11 echo CREATE TABLE t4(f1 int,f2 char(1000),PRIMARY KEY(f1));
  12 Statement Executed
  13 echo CREATE TABLE t5(f1 int,f2 int,foreign key(f1) references t4(f1));
  14 Statement Executed
  15 echo CREATE TABLE t6(f1 int,f2 char(1000),PRIMARY KEY(f2));
  16 Statement Executed
  17 echo CREATE TABLE t7(f1 int,f2 char,foreign key(f2) references t6(f2));
  18 Statement Executed
  19 echo CREATE TABLE t8(f1 int,f2 int,f3 char(1000),PRIMARY KEY(f3));
  20 Statement Executed
  21 2000 record inserted
  22 Statement Executed: Rows Affected = 2000
  23 echo DROP TABLE t1;
  24 Statement Executed
  25 echo DROP INDEX idx1;
  26 Statement Executed
  27 echo DROP TABLE t2;
  28 Statement Executed
  29 echo DROP INDEX idx2;
  30 Statement Executed
  31 echo DROP TABLE t3;
  32 Statement Executed
  33 echo DROP TABLE t5;
  34 Statement Executed
  35 echo DROP TABLE t4;
  36 Statement Executed
  37 echo DROP TABLE t7;
  38 Statement Executed
  39 echo DROP TABLE t6;
  40 Statement Executed
  41 echo DROP TABLE t8;
  42 Statement Executed