test/tools/csqldump/exp.test006.ksh

   1 CREATE TABLE t1 (f1 INT  NOT NULL , f2 INT  DEFAULT '10' );
   2 CREATE INDEX indx1 on t1 (  f1  )  HASH ;
   3 CREATE INDEX indx2 on t1 (  f2  )  HASH ;
   4 SET AUTOCOMMIT OFF;
   5 INSERT INTO t1 VALUES(131,10);
   6 INSERT INTO t1 VALUES(141,10);
   7 INSERT INTO t1 VALUES(13,41);
   8 INSERT INTO t1 VALUES(143,41);
   9 INSERT INTO t1 VALUES(153,41);
  10 INSERT INTO t1 VALUES(163,41);
  11 INSERT INTO t1 VALUES(151,10);
  12 INSERT INTO t1 VALUES(1631,10);
  13 INSERT INTO t1 VALUES(163,41);
  14 INSERT INTO t1 VALUES(13,41);
  15 INSERT INTO t1 VALUES(23,41);
  16 INSERT INTO t1 VALUES(551,10);
  17 INSERT INTO t1 VALUES(631,10);
  18 INSERT INTO t1 VALUES(43,41);
  19 INSERT INTO t1 VALUES(3,41);
  20 INSERT INTO t1 VALUES(3,41);
  21 INSERT INTO t1 VALUES(33,41);
  22 INSERT INTO t1 VALUES(31,10);
  23 INSERT INTO t1 VALUES(31,10);
  24 INSERT INTO t1 VALUES(4,41);
  25 INSERT INTO t1 VALUES(31,10);
  26 INSERT INTO t1 VALUES(31,10);
  27 INSERT INTO t1 VALUES(31,10);
  28 INSERT INTO t1 VALUES(31,10);
  29 INSERT INTO t1 VALUES(31,10);
  30 INSERT INTO t1 VALUES(41,10);
  31 INSERT INTO t1 VALUES(3,41);
  32 INSERT INTO t1 VALUES(43,41);
  33 INSERT INTO t1 VALUES(53,41);
  34 INSERT INTO t1 VALUES(63,41);
  35 INSERT INTO t1 VALUES(51,10);
  36 INSERT INTO t1 VALUES(631,10);
  37 INSERT INTO t1 VALUES(63,41);
  38 INSERT INTO t1 VALUES(3,41);
  39 INSERT INTO t1 VALUES(3,41);
  40 INSERT INTO t1 VALUES(51,10);
  41 INSERT INTO t1 VALUES(631,10);
  42 INSERT INTO t1 VALUES(3,41);
  43 INSERT INTO t1 VALUES(3,41);
  44 INSERT INTO t1 VALUES(3,41);
  45 INSERT INTO t1 VALUES(3,41);
  46 INSERT INTO t1 VALUES(31,10);
  47 INSERT INTO t1 VALUES(31,10);
  48 INSERT INTO t1 VALUES(4,41);
  49 INSERT INTO t1 VALUES(41,10);
  50 INSERT INTO t1 VALUES(3,41);
  51 INSERT INTO t1 VALUES(43,41);
  52 INSERT INTO t1 VALUES(53,41);
  53 INSERT INTO t1 VALUES(63,41);
  54 INSERT INTO t1 VALUES(51,10);
  55 INSERT INTO t1 VALUES(631,10);
  56 INSERT INTO t1 VALUES(63,41);
  57 INSERT INTO t1 VALUES(3,41);
  58 INSERT INTO t1 VALUES(3,41);
  59 INSERT INTO t1 VALUES(51,10);
  60 INSERT INTO t1 VALUES(631,10);
  61 INSERT INTO t1 VALUES(3,41);
  62 INSERT INTO t1 VALUES(3,41);
  63 INSERT INTO t1 VALUES(3,41);
  64 INSERT INTO t1 VALUES(3,41);
  65 INSERT INTO t1 VALUES(31,10);
  66 INSERT INTO t1 VALUES(31,10);
  67 INSERT INTO t1 VALUES(4,41);
  68 INSERT INTO t1 VALUES(41,10);
  69 INSERT INTO t1 VALUES(3,41);
  70 INSERT INTO t1 VALUES(43,41);
  71 INSERT INTO t1 VALUES(53,41);
  72 INSERT INTO t1 VALUES(63,41);
  73 INSERT INTO t1 VALUES(51,10);
  74 INSERT INTO t1 VALUES(631,10);
  75 INSERT INTO t1 VALUES(63,41);
  76 INSERT INTO t1 VALUES(3,41);
  77 INSERT INTO t1 VALUES(3,41);
  78 INSERT INTO t1 VALUES(51,10);
  79 INSERT INTO t1 VALUES(631,10);
  80 INSERT INTO t1 VALUES(3,41);
  81 INSERT INTO t1 VALUES(3,41);
  82 INSERT INTO t1 VALUES(3,41);
  83 INSERT INTO t1 VALUES(3,41);
  84 INSERT INTO t1 VALUES(31,10);
  85 INSERT INTO t1 VALUES(31,10);
  86 INSERT INTO t1 VALUES(4,41);
  87 INSERT INTO t1 VALUES(3,41);
  88 INSERT INTO t1 VALUES(43,41);
  89 INSERT INTO t1 VALUES(53,41);
  90 INSERT INTO t1 VALUES(63,41);
  91 INSERT INTO t1 VALUES(51,10);
  92 INSERT INTO t1 VALUES(631,10);
  93 INSERT INTO t1 VALUES(63,41);
  94 INSERT INTO t1 VALUES(3,41);
  95 INSERT INTO t1 VALUES(3,41);
  96 INSERT INTO t1 VALUES(51,10);
  97 INSERT INTO t1 VALUES(6317,10);
  98 INSERT INTO t1 VALUES(3,41);
  99 INSERT INTO t1 VALUES(3,413);
 100 INSERT INTO t1 VALUES(3,431);
 101 INSERT INTO t1 VALUES(3,941);
 102 INSERT INTO t1 VALUES(631,10);
 103 INSERT INTO t1 VALUES(431,10);
 104 INSERT INTO t1 VALUES(14,41);
 105 COMMIT;