LOG aqatddl09 Clear;
---------------------------------------------------------------------
-- File: SQLQAT09                Formerly $cats.testest.qat009
-- Component: NonStop SQL Regression Test Suite
-- Description: Populate data base with values of special use to the
--              SELECT tests.
---------------------------------------------------------------------
---------------------------------------------------------------------
insert into btsel01 values ('A','steven','C','walter','bob',
                                     'B',50,50,200,50,0.12,100.9,
                                     10,10000,1000000000,4,.5,90,
                                     1.1,0.1,1);

insert into btsel01 values ('A','bobby','A','bobby','bop',
                                     'B',60,60,1200,60,0.79,100.99,
                                     1000,8000,-1000,5,.6,100,
                                     2.1,0.2,2);

insert into btsel01 values
                                     ('D','steven','B','9','bat','thomas',
                                     8000,70,2000,500,0.10,100.999,
                                     90,10000,1000,7,.7,110,
                                     3.1,0.3,3);

insert into btsel01 values
                                     ('D','melissa','C','7','pop','jimmy',
                                     1000,80,1500,500,0.20,100.9999,
                                     80,9000,999,5,.8,120,
                                     4.1,0.4,4);

insert into btsel01 values ('E','monica','Q','sue','pat',
                                     'christopher',
                                     2000,90,1200,3000,0.30,100.99999,
                                     2000,8000,-1000000,1,.9,80,
                                     5.1,0.5,5);

insert into btsel01 values
                                     ('D','michelle','D','michael','rat',
                                     'thomas',
                                     -5000,90,2000,500,0.40,100.8,
                                     90,8000,200,7,.93,140,
                                     6.1,0.6,6);

insert into btsel01 values ('C','maureen','E','jimmy','rum',
                                     'marilyn',
                                     3000,80,2000,500,0.50,100.7,
                                     9000,1000,2000,8,.97,150,
                                     7.1, 0.7,7);

insert into btsel01 values ('C','marcia','Z','johnny','dum',
                                     'thomas',
                                     4000,40,2000,50,0.60,100.6,
                                     8000,5000,0,9,.99,110,
                                     8.1,0.8,8);
-- ------------------------------------------------------------------
-- update statistics for table btsel01 on every column;
-- ------------------------------------------------------------------

insert into btsel02 values ('B');
insert into btsel02 values ('C');
insert into btsel02 values ('B');
insert into btsel02 values ('Q');
insert into btsel02 values ('B');
insert into btsel02 values ('C');
insert into btsel02 values ('Q');
insert into btsel02 values ('Q');
-- ------------------------------------------------------------------
-- update statistics for table btsel02 on every column;
-- ------------------------------------------------------------------

insert into btsel03 values ('A',5,'make',90,200);
insert into btsel03 values ('7',6,'joe',80,1200);
insert into btsel03 values ('8',6,'joe',80,1200);
insert into btsel03 values ('5',1000,'5',100,1000);
insert into btsel03 values ('michael',50,'dave',50,1500);
insert into btsel03 values ('7',6,'john',80,2000);
insert into btsel03 values ('B',6,'mark',80,3000);
insert into btsel03 values ('michael',70,'joan',50,4000);
-- ------------------------------------------------------------------
-- update statistics for table btsel03 on every column;
-- ------------------------------------------------------------------

insert into btsel04 values ('tom',1000,'7',200);
insert into btsel04 values ('bob',999,'A',300);
insert into btsel04 values ('sue',200,'sue',100);
insert into btsel04 values ('bobby',200,'sue',100);
insert into btsel04 values ('bill',2000,'B',500);
insert into btsel04 values ('christopher',1000,'white',1000);
insert into btsel04 values ('william',1000,'black',2000);
insert into btsel04 values ('marilyn',2000,'green',3000);
-- ------------------------------------------------------------------
-- update statistics for table btsel04 on every column;
-- ------------------------------------------------------------------

insert into btsel05 values ('joe','A','al','pablo','david',
                                     'amy','amy','steve','steve','walt',
                                     'mojo','joe','percy');
insert into btsel05 values ('sue','A','in','peggy','diane',
                                     'zora','cathy','mary','mary',
                                     'rhoda','debra','sue','madge');
insert into btsel05 values ('deb','D','jo','lowry','mary',
                                     'sunny','debra','junk','junk',
                                     'junk','junk','junk','junk');
insert into btsel05 values ('can','D','by','lowry','steve',
                                     'slope','debby','junk','junk',
                                     'junk','junk','junk','junk');
insert into btsel05 values ('box','C','to','howie','debra',
                                     'snow','debbi','junk','junk',
                                     'junk','junk','junk','junk');
insert into btsel05 values ('red','B','go','lowry','sue',
                                     'ski','cammy','junk','junk',
                                     'junk','junk','junk','junk');
insert into btsel05 values ('why','B','so','lowry','amy',
                                     'squaw','tammy','junk','junk',
                                     'junk','junk','junk','junk');
insert into btsel05 values ('not','B','on','lowry','mary',
                                     'mogul','pammy','junk','junk',
                                     'junk','junk','junk','junk');
-- ------------------------------------------------------------------
-- update statistics for table btsel05 on every column;
-- ------------------------------------------------------------------

insert into btsel06 values  ('joe','Z','in',100,200,100,200,
                                      200,100,100,100,50,100,100,200,
                                      100,200,200,100,100,100,50,100,
                                      100,200,100,200,200,100,100,100,
                                      100,200,100,200,200,100,100,100,
                                      50,100);
insert into btsel06 values
                                      ('sue','Q','on',200,400,100,100,400,
                                      100,100,50,100,200,200,400,100,100,
                                      400,100,100,50,100,200,200,400,100,
                                      100,400,100,100,50,200,400,100,100,
                                      400,100,100,50,100,200);
insert into btsel06 values
                                     ('pam','D','al',900,1000,900,1000,1000,
                                     50,1000,1000,1000,1000,1000,1000,1000,
                                     1000,1000,1000,1000,1000,1000,1000,1000,
                                     1000,1000,1000,1000,1000,1000,1000,1000,
                                     1000,1000,1000,1000,1000,1000,1000,1000,
                                     1000);
insert into btsel06 values
                                     ('sue','C','by',300,1000,500,1000,1000,
                                     50,1000,1000,1000,1000,1000,1000,1000,
                                     1000,1000,1000,1000,1000,1000,1000,1000,
                                     1000,1000,1000,1000,1000,1000,1000,1000,
                                     1000,1000,1000,1000,1000,1000,1000,1000,
                                     1000);
insert into btsel06 values
                                     ('joe','A','jo',100,1000,200,1000,1000,
                                     50,1000,1000,1000,1000,1000,1000,1000,
                                     1000,1000,1000,1000,1000,1000,1000,1000,
                                     1000,1000,1000,1000,1000,1000,1000,1000,
                                     1000,1000,1000,1000,1000,1000,1000,1000,
                                     1000);
insert into btsel06 values
                                     ('joe','B','to',300,1000,400,1000,1000,
                                     50,1000,1000,1000,1000,1000,1000,1000,
                                     1000,1000,1000,1000,1000,1000,1000,1000,
                                     1000,1000,1000,1000,1000,1000,1000,1000,
                                     1000,1000,1000,1000,1000,1000,1000,1000,
                                     1000);
insert into btsel06 values
                                     ('joe','C','go',100,1000,200,1000,1000,
                                     50,1000,1000,1000,1000,1000,1000,1000,
                                     1000,1000,1000,1000,1000,1000,1000,1000,
                                     1000,1000,1000,1000,1000,1000,1000,1000,
                                     1000,1000,1000,1000,1000,1000,1000,1000,
                                     1000);
insert into btsel06 values
                                     ('sue','D','so',200,1000,300,1000,1000,
                                     50,1000,1000,1000,1000,1000,1000,1000,
                                     1000,1000,1000,1000,1000,1000,1000,1000,
                                     1000,1000,1000,1000,1000,1000,1000,1000,
                                     1000,1000,1000,1000,1000,1000,1000,1000,
                                     1000);
-- ------------------------------------------------------------------
-- update statistics for table btsel06 on every column;
-- ------------------------------------------------------------------
insert into btsel07 values  ('jo','Z','jo');
insert into btsel07 values  ('al','Q','al');
insert into btsel07 values  ('P','P','P');
insert into btsel07 values  ('B','A','ed');
insert into btsel07 values  ('jo','C','ek');
insert into btsel07 values  ('JO','D','em');
insert into btsel07 values  ('al','E','bo');
insert into btsel07 values  (' al','F','di');
insert into btsel07 values  ('al ','F','al');
insert into btsel07 values  (' al','F','al');
-- ------------------------------------------------------------------
-- update statistics for table btsel07 on every column;
-- ------------------------------------------------------------------

insert into btsel08 values (3000,'george','D');
insert into btsel08 values (100,'carltons','E');
insert into btsel08 values (1000,'harveys','B');
insert into btsel08 values (300,'Q','X');
insert into btsel08 values (2000,'alexander','B');
insert into btsel08 values (400,'joseph','X');
insert into btsel08 values (200,'squaw','X');
insert into btsel08 values (4000,'valley','D');
-- ------------------------------------------------------------------
-- update statistics for table btsel08 on every column;
-- ------------------------------------------------------------------

insert into btsel09 values
   ('sue','mary','Z','MARY',3,10,20);
insert into btsel09 values
   ('deb','bill','Y','BILL',4,10,30);
insert into btsel09 values
   ('can','come','X','TED',7,77,77);
insert into btsel09 values
   ('joe','over','W','maria',7,90,100);
insert into btsel09 values
   ('box','here','R','debby',5,11,50);
insert into btsel09 values
   ('red','long','S','tommy',5,15,70);
insert into btsel09 values
   ('not','time','P','diane',7,20,40);
insert into btsel09 values
   ('why','gone','R','billy',7,15,30);
insert into btsel09 values
   ('\ts','t_go','j','to%go',0,0,0);
insert into btsel09 values
   ('\t_','junk','j','\%',0,0,0);
insert into btsel09 values
   ('_t%','junk','j','_%',0,0,0);
insert into btsel09 values
   ('%t_','junk','j','%_',0,0,0);
-- ------------------------------------------------------------------
-- update statistics for table btsel09 on every column;
-- ------------------------------------------------------------------

insert into btsel10 values
   ('tom','tom',3,'abadefih',100,100,-100);
insert into btsel10 values
   ('bob','bobby',2,'ebediih',90,100,-1000);
insert into btsel10 values
   ('sue','sue',1,'ebedafiih',110,80,100);
insert into btsel10 values
   ('rod','for',400,'inside',25,60,0);
insert into btsel10 values
   ('don','who',50,'outside',10000,100,-100);
insert into btsel10 values
   ('jon','does',1000,'offsides',50000, 500,100);
insert into btsel10 values
   ('ron','they',2000,'onsides',10000,100, -100);
insert into btsel10 values
   ('rob','bobby',2,'ebediih',90,100,-1000);
-- ------------------------------------------------------------------
-- update statistics for table btsel10 on every column;
-- ------------------------------------------------------------------
insert into btsel11 values
   ('bob','bob', 100,'abadefih', 160,200,200);
insert into btsel11 values
   ('dan','sue', 100,'ebediih', 100,100,60);
insert into btsel11 values
   ('boe','tommy', 200,'ebedafiih', 200,50,50);
insert into btsel11 values
   ('bar','where', 300,'gone', 200,9999,-100);
insert into btsel11 values
   ('car','who', 400,'done', 160,500,500);
insert into btsel11 values
   ('tar','what', 500,'none', 100,8888,0);
insert into btsel11 values
   ('jar','how', 600,'inside', 160,500,500);
insert into btsel11
   values ('mar','why', 50,'house', 50,7777,0);
-- ------------------------------------------------------------------
-- update statistics for table btsel11 on every column;
-- ------------------------------------------------------------------

insert into btsel12 values ('tom',100);
insert into btsel12 values ('bob',200);
insert into btsel12 values ('run',300);
insert into btsel12 values ('sun',400);
insert into btsel12 values ('fun',500);
insert into btsel12 values ('gun',600);
insert into btsel12 values ('nun',700);
insert into btsel12 values ('pun',800);
-- ------------------------------------------------------------------
-- update statistics for table btsel12 on every column;
-- ------------------------------------------------------------------

insert into btsel13 values (100);
insert into btsel13 values (200);
insert into btsel13 values (250);
insert into btsel13 values (350);
insert into btsel13 values (450);
insert into btsel13 values (550);
insert into btsel13 values (650);
insert into btsel13 values (750);
-- ------------------------------------------------------------------
-- update statistics for table btsel13 on every column;
-- ------------------------------------------------------------------

insert into btsel14 values (100);
insert into btsel14 values (200);
insert into btsel14 values (125);
insert into btsel14 values (150);
insert into btsel14 values (175);
insert into btsel14 values (225);
insert into btsel14 values (275);
insert into btsel14 values (325);
-- ------------------------------------------------------------------
-- update statistics for table btsel14 on every column;
-- ------------------------------------------------------------------

insert into btsel15 values (1000,100);
insert into btsel15 values (2000,200);
insert into btsel15 values (1111,90);
insert into btsel15 values (2222,80);
insert into btsel15 values (3333,70);
insert into btsel15 values (4444,60);
insert into btsel15 values (5555,50);
insert into btsel15 values (6666,40);
-- ------------------------------------------------------------------
-- update statistics for table btsel15 on every column;
-- ------------------------------------------------------------------

insert into btsel16 values (1000,167);
insert into btsel16 values (2000,168);
insert into btsel16 values (8500,169);
insert into btsel16 values (8501,170);
insert into btsel16 values (8502,171);
insert into btsel16 values (8503,172);
insert into btsel16 values (8504,173);
insert into btsel16 values (8505,174);
-- ------------------------------------------------------------------
-- update statistics for table btsel16 on every column;
-- ------------------------------------------------------------------

insert into btsel17 values (1000,248);
insert into btsel17 values (2000,249);
insert into btsel17 values (7500,250);
insert into btsel17 values (7501,251);
insert into btsel17 values (7502,252);
insert into btsel17 values (7503,253);
insert into btsel17 values (7504,254);
insert into btsel17 values (7505,255);
-- ------------------------------------------------------------------
-- update statistics for table btsel17 on every column;
-- ------------------------------------------------------------------

insert into btsel18 values (-5000,1000,401);
insert into btsel18 values (8000,2000,402);
insert into btsel18 values (2001,6001,403);
insert into btsel18 values (2002,6002,404);
insert into btsel18 values (2003,6003,405);
insert into btsel18 values (2004,6004,406);
insert into btsel18 values (2005,6005,407);
insert into btsel18 values (2006,6006,408);
-- ------------------------------------------------------------------
-- update statistics for table btsel18 on every column;
-- ------------------------------------------------------------------

insert into btsel19 values (-5000,409);
insert into btsel19 values (8000,410);
insert into btsel19 values (2007,411);
insert into btsel19 values (2008,412);
insert into btsel19 values (2009,413);
insert into btsel19 values (2010,414);
insert into btsel19 values (2011,415);
insert into btsel19 values (2012,416);
-- ------------------------------------------------------------------
-- update statistics for table btsel19 on every column;
-- ------------------------------------------------------------------

insert into btsel20 values (-5000,417);
insert into btsel20 values (8000,418);
insert into btsel20 values (2013,419);
insert into btsel20 values (2014,420);
insert into btsel20 values (2015,421);
insert into btsel20 values (2016,422);
insert into btsel20 values (2017,423);
insert into btsel20 values (2018,424);
-- ------------------------------------------------------------------
-- update statistics for table btsel20 on every column;
-- ------------------------------------------------------------------

insert into btsel21 values (0.12,-5000,425);
insert into btsel21 values (-0.25,8000,426);
insert into btsel21 values (0.01,5000,427);
insert into btsel21 values (0.02,5001,428);
insert into btsel21 values (0.03,5002,429);
insert into btsel21 values (0.04,5003,430);
insert into btsel21 values (0.05,5004,431);
insert into btsel21 values (0.06,5005,432);
-- ------------------------------------------------------------------
-- update statistics for table btsel21 on every column;
-- -----------------------------------------------------------------

insert into btsel22 values (0.12,433);
insert into btsel22 values (-0.25,434);
insert into btsel22 values (0.07,435);
insert into btsel22 values (0.08,436);
insert into btsel22 values (0.09,437);
insert into btsel22 values (0.10,438);
insert into btsel22 values (0.11,439);
insert into btsel22 values (0.92,440);
-- ------------------------------------------------------------------
-- update statistics for table btsel22 on every column;
-- ------------------------------------------------------------------

insert into btsel23 values (0.12,441);
insert into btsel23 values (-0.25,442);
insert into btsel23 values (0.13,443);
insert into btsel23 values (0.14,444);
insert into btsel23 values (0.15,445);
insert into btsel23 values (0.16,446);
insert into btsel23 values (0.17,447);
insert into btsel23 values (0.18,448);
-- ------------------------------------------------------------------
-- update statistics for table btsel23 on every column;
-- ------------------------------------------------------------------

insert into btsel24 values (0.79,'tom');
insert into btsel24 values (0.19,'bob');
insert into btsel24 values (0.20,'toe');
insert into btsel24 values (0.21,'woe');
insert into btsel24 values (0.22,'pin');
insert into btsel24 values (0.23,'sin');
insert into btsel24 values (0.24,'win');
insert into btsel24 values (0.25,'kin');
-- ------------------------------------------------------------------
-- update statistics for table btsel24 on every column;
-- ------------------------------------------------------------------

insert into btsel25 values ('B', 'joe');
insert into btsel25 values ('C', 'why');
insert into btsel25 values ('D', 'not');
insert into btsel25 values ('E', ' al');
insert into btsel25 values ('Q', 'al ');
insert into btsel25 values ('B', 'bar');
insert into btsel25 values ('C', 'car');
insert into btsel25 values ('D', '   ');
insert into btsel25 values ('E', 'joe');
insert into btsel25 values ('Q', 'sue');
insert into btsel25 values (' ', 'sue');
-- ------------------------------------------------------------------
-- update statistics for table btsel25 on every column;
-- ------------------------------------------------------------------

insert into btsel26 values 
  ( 'A', 2, 2, 2, 2, .9, .2, .9, .2, 99999999999999999,
    99999999999999999, 99999999.9, 1.1, 999999999.1, 9.99999999, 2,
    .2, 2, .2, 0
  );
insert into btsel26 values
  ( 'B', 999999999999999999, 1, 999999999999999999, 1,
    .999999999999999999, .000000000000000001 , .999999999999999999,
    .00000000000001, -99999999999999999, 99999999999999999,
    -99999999.9, 1.899999999, 999999998.1, 9.99999999, 999999999,
    .999999999, 999999999, .999999999, 0
  );
insert into btsel26 values
  ( 'C', -999999999999999999, 1, -999999999999999999, 1,
    .999999999999999999, .000000000000000002, .999999999999999999,
    .00000000000002, 0, 99999999, 99999999.9, 9.999999999,
    -999999999.9, 9.99999999, 0, 0, 0, 0, .9
  );
insert into btsel26 values
  ( 'D', 100000000000000000, 899999999999999999, 100000000000000000,
    899999999999999999, .999999999999999999, .1, .999999999999999999,
    .000000000000000002, 0, 100, 9999999.9, 4.4, 0, 8, 0, 0, 0, 0, .1
  );
insert into btsel26 values
  ( 'E', 999999999999999999, 3, 999999999999999999,
    100000000000000000, .000000000000000001, .9, .999999999999999999,
    0, 10, 99999999999999999, 0, 3, 0, 0, 0, 0, 0, 0, 0
  );
insert into btsel26 values
  ( 'F', 999999999999999999, 2, 999999999999999999,
    -999999999999999999, .1, 0, .999999999999999999, 0,
    99999999999999999, 0, 0, 2.5, 0, 0, 0, 0, 0, 0, 0
  );
insert into btsel26 values
  ( 'G', 92233720368547758, 999999999999999999, 999999999999999999, 0,
    .08, .09, .999999999999999999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
    0
  );
insert into btsel26 values
  ( 'H', 999999999999999999, 999999999999999999, 999999999999999999,
    0, 0, 0, .999999999999999999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
  );
insert into btsel26 values
  ( 'I', 999999999999999999, 0, 999999999999999999, 0, 0, 0,
   .999999999999999999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
  );
insert into btsel26 values
  ( 'J', 999999999999999999, 0, 999999999999999999,
    0, 0, 0, .999999999999999999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
  );
insert into btsel26 values
  ( 'K', 999999999999999999, 0, 999999999999999999,
    0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
  );
insert into btsel26 values
  ( 'L', 999999999999999999, 0, 999999999999999999,
    0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
  );
insert into btsel26 values
  ( 'M', 999999999999999999, 0, 999999999999999999,
    0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
  );
insert into btsel26 values
  ( 'N', 999999999999999999, 0, 0,
    0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
  );
insert into btsel26 values
  ( 'O', -999999999999999999, 0, 0,
    0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
  );
insert into btsel26 values
  ('P', -999999999999999999, 0, 0,
   0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
  );
-- ------------------------------------------------------------------
-- update statistics for table btsel26 on every column;
-- ------------------------------------------------------------------

insert into btsel27 values
  ('A', 1.1001, 1.1);
insert into btsel27 values
  ('B', 1.0016, .1);
insert into btsel27 values
  ('C', .0001, 9.9);
-- ------------------------------------------------------------------
-- update statistics for table btsel27 on every column;
-- ------------------------------------------------------------------
LOG;
