test/tools/csqldump/exp.test008.ksh

   1 CREATE TABLE kishor (fld1 INT  NOT NULL , name1 CHAR (30));
   2 CREATE INDEX kishor_idx1_Primary on kishor (  fld1  )  UNIQUE;
   3 CREATE TABLE ravi (fld2 INT  NOT NULL , name1 CHAR (30));
   4 CREATE INDEX ravi_idx1_Primary on ravi (  fld2  )  UNIQUE;
   5 CREATE TABLE kiran (fld3 INT  NOT NULL , name1 CHAR (30));
   6 CREATE INDEX kiran_idx1_Primary on kiran (  fld3  )  UNIQUE;
   7 CREATE TABLE anand (fld4 INT  NOT NULL , name1 CHAR (30));
   8 CREATE INDEX anand_idx1_Primary on anand (  fld4  )  UNIQUE;
   9 CREATE TABLE vikas (fld5 INT  NOT NULL , name1 CHAR (30));
  10 CREATE INDEX vikas_idx1_Primary on vikas (  fld5  )  UNIQUE;
  11 CREATE TABLE vikram (fld6 INT  NOT NULL , name1 CHAR (30));
  12 CREATE INDEX vikram_idx1_Primary on vikram (  fld6  )  UNIQUE;
  13 CREATE TABLE vinod (fld7 INT  NOT NULL , name1 CHAR (30));
  14 CREATE INDEX vinod_idx1_Primary on vinod (  fld7  )  UNIQUE;
  15 CREATE TABLE jayant (fld8 INT  NOT NULL , name1 CHAR (30));
  16 CREATE INDEX jayant_idx1_Primary on jayant (  fld8  )  UNIQUE;
  17 CREATE TABLE rahul (fld9 INT  NOT NULL , name1 CHAR (30));
  18 CREATE INDEX rahul_idx1_Primary on rahul (  fld9  )  UNIQUE;
  19 CREATE TABLE ramesh (fld10 INT  NOT NULL , name1 CHAR (30));
  20 CREATE INDEX ramesh_idx1_Primary on ramesh (  fld10  )  UNIQUE;
  21 SET AUTOCOMMIT OFF;
  22 INSERT INTO kishor VALUES(11, 'raksha1');
  23 INSERT INTO kishor VALUES(2, 'Laxkshya2');
  24 INSERT INTO kishor VALUES(32, 'Laksxhya3');
  25 INSERT INTO kishor VALUES(4, 'Lakhya4');
  26 INSERT INTO kishor VALUES(5, 'Laka5');
  27 INSERT INTO kishor VALUES(63, 'shya6');
  28 INSERT INTO kishor VALUES(7, 'Laksya7');
  29 INSERT INTO kishor VALUES(18, 'Lakya8');
  30 INSERT INTO kishor VALUES(97, 'Lakhya9');
  31 INSERT INTO kishor VALUES(104, 'Laa10');
  32 COMMIT;
  33 INSERT INTO ravi VALUES(11, 'Lakshy');
  34 INSERT INTO ravi VALUES(22, 'raksha2');
  35 INSERT INTO ravi VALUES(33, 'raksha3');
  36 INSERT INTO ravi VALUES(44, 'Lak4');
  37 INSERT INTO ravi VALUES(55, 'raksha5');
  38 INSERT INTO ravi VALUES(66, 'Lakya6');
  39 INSERT INTO ravi VALUES(77, 'raksha7');
  40 INSERT INTO ravi VALUES(88, 'Laksa8');
  41 INSERT INTO ravi VALUES(99, 'Laksya9');
  42 INSERT INTO ravi VALUES(100, 'Lashya10');
  43 COMMIT;
  44 INSERT INTO kiran VALUES(31, 'raksha1');
  45 INSERT INTO kiran VALUES(42, 'Lakshya2');
  46 INSERT INTO kiran VALUES(53, 'raksha3');
  47 INSERT INTO kiran VALUES(64, 'Lakshya4');
  48 INSERT INTO kiran VALUES(58, 'raksha5');
  49 INSERT INTO kiran VALUES(63, 'Lakshya6');
  50 INSERT INTO kiran VALUES(74, 'raksha7');
  51 INSERT INTO kiran VALUES(87, 'Lakshya8');
  52 INSERT INTO kiran VALUES(94, 'raksha9');
  53 INSERT INTO kiran VALUES(10, 'Lakshya10');
  54 COMMIT;
  55 INSERT INTO anand VALUES(12, 'Lakshya1');
  56 INSERT INTO anand VALUES(23, 'raksha2');
  57 INSERT INTO anand VALUES(35, 'Lakshya3');
  58 INSERT INTO anand VALUES(48, 'Lakshya4');
  59 INSERT INTO anand VALUES(53, 'raksha5');
  60 INSERT INTO anand VALUES(66, 'Lakshya6');
  61 INSERT INTO anand VALUES(79, 'Lakshya7');
  62 INSERT INTO anand VALUES(81, 'raksha8');
  63 INSERT INTO anand VALUES(94, 'Lakshya9');
  64 INSERT INTO anand VALUES(105, 'Lakshya10');
  65 COMMIT;
  66 INSERT INTO vikas VALUES(1, 'Lakshya1');
  67 INSERT INTO vikas VALUES(2, 'Lakshya2');
  68 INSERT INTO vikas VALUES(3, 'raksha3');
  69 INSERT INTO vikas VALUES(4, 'Lakshya4');
  70 INSERT INTO vikas VALUES(5, 'Lakshya5');
  71 INSERT INTO vikas VALUES(6, 'Lakshya6');
  72 INSERT INTO vikas VALUES(7, 'Lakshya7');
  73 INSERT INTO vikas VALUES(8, 'Lakshya8');
  74 INSERT INTO vikas VALUES(9, 'raksha9');
  75 INSERT INTO vikas VALUES(10, 'Lakshya10');
  76 COMMIT;
  77 INSERT INTO vikram VALUES(1, 'Lakshya1');
  78 INSERT INTO vikram VALUES(2, 'raksha2');
  79 INSERT INTO vikram VALUES(3, 'Lakshya3');
  80 INSERT INTO vikram VALUES(4, 'raksha4');
  81 INSERT INTO vikram VALUES(5, 'Lakshya5');
  82 INSERT INTO vikram VALUES(6, 'Lakshya6');
  83 INSERT INTO vikram VALUES(7, 'raksha7');
  84 INSERT INTO vikram VALUES(8, 'Lakshya8');
  85 INSERT INTO vikram VALUES(9, 'Lakshya9');
  86 INSERT INTO vikram VALUES(10, 'Lakshya10');
  87 COMMIT;
  88 INSERT INTO vinod VALUES(1, 'Lakshya1');
  89 INSERT INTO vinod VALUES(2, 'raksha2');
  90 INSERT INTO vinod VALUES(3, 'Lakshya3');
  91 INSERT INTO vinod VALUES(4, 'Lakshya4');
  92 INSERT INTO vinod VALUES(5, 'raksha5');
  93 INSERT INTO vinod VALUES(6, 'Lakshya6');
  94 INSERT INTO vinod VALUES(7, 'Lakshya7');
  95 INSERT INTO vinod VALUES(8, 'raksha8');
  96 INSERT INTO vinod VALUES(9, 'Lakshya9');
  97 INSERT INTO vinod VALUES(10, 'Lakshya10');
  98 COMMIT;
  99 INSERT INTO jayant VALUES(1, 'Lakshya1');
 100 INSERT INTO jayant VALUES(2, 'raksha2');
 101 INSERT INTO jayant VALUES(3, 'Lakshya3');
 102 INSERT INTO jayant VALUES(4, 'Lakshya4');
 103 INSERT INTO jayant VALUES(5, 'raksha5');
 104 INSERT INTO jayant VALUES(6, 'Lakshya6');
 105 INSERT INTO jayant VALUES(7, 'Lakshya7');
 106 INSERT INTO jayant VALUES(8, 'raksha8');
 107 INSERT INTO jayant VALUES(9, 'Lakshya9');
 108 INSERT INTO jayant VALUES(10, 'Lakshya10');
 109 COMMIT;
 110 INSERT INTO rahul VALUES(1, 'Lakshya1');
 111 INSERT INTO rahul VALUES(2, 'Lakshya2');
 112 INSERT INTO rahul VALUES(3, 'raksha3');
 113 INSERT INTO rahul VALUES(4, 'Lakshya4');
 114 INSERT INTO rahul VALUES(5, 'Lakshya5');
 115 INSERT INTO rahul VALUES(6, 'raksha6');
 116 INSERT INTO rahul VALUES(7, 'Lakshya7');
 117 INSERT INTO rahul VALUES(8, 'Lakshya8');
 118 INSERT INTO rahul VALUES(9, 'Lakshya9');
 119 INSERT INTO rahul VALUES(10, 'Lakshya10');
 120 COMMIT;
 121 INSERT INTO ramesh VALUES(1, 'Lakshya1');
 122 INSERT INTO ramesh VALUES(2, 'Lakshya2');
 123 INSERT INTO ramesh VALUES(3, 'Lakshya3');
 124 INSERT INTO ramesh VALUES(4, 'Lakshya4');
 125 INSERT INTO ramesh VALUES(5, 'Lakshya5');
 126 INSERT INTO ramesh VALUES(6, 'raksha6');
 127 INSERT INTO ramesh VALUES(7, 'raksha7');
 128 INSERT INTO ramesh VALUES(8, 'raksha8');
 129 INSERT INTO ramesh VALUES(9, 'raksha9');
 130 INSERT INTO ramesh VALUES(10, 'Lakshya10');
 131 COMMIT;