B4BY.588

: / usr / share / mysql-test / include /
Filename : index_merge_single_col_setup.inc
back
#
# Creating table with single column index setup
#

--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

CREATE TABLE t1
(
  key1 INT NOT NULL,
  key2 INT NOT NULL,
  key3 INT NOT NULL,
  key4 INT NOT NULL,
  key5 INT,
  key6 INT,
  key7 INT NOT NULL,
  key8 INT NOT NULL,
  INDEX i1(key1),
  INDEX i2(key2),
  INDEX i3(key3),
  INDEX i4(key4),
  INDEX i5(key5),
  INDEX i6(key6)
);

--disable_query_log

# inserting values 

INSERT INTO t1 VALUES ( 1,1,1,1,1,1,1,1),(2,2,2,2,2,2,2,2);

let $i=10;
set @d=2;
while($i)
{
  INSERT INTO t1 SELECT key1+@d, key2+@d, key3+@d, key4+@d,
                            key5+@d, key6+@d, key7+@d, key8+@d FROM t1;
  set @d=@d*2;
  dec $i;
}


# inserting null values.

let $i=5;
set @d=5;
while($i)
{
  INSERT INTO t1 VALUES (key1+@d, key2+@d, key3+@d, key4+@d,
                                        key5+@d, NULL, key7+@d, key8+@d);
  set @d=@d*2;
  dec $i;
}

let $i=4;
set @d=6;
while($i)
{
  INSERT INTO t1 VALUES (key1+@d, key2+@d, key3+@d, key4+@d,
                                       NULL, key6+@d, key7+@d, key8+@d);
  set @d=@d*2;
  dec $i;
}

--enable_query_log

# The following statement analyzes and
# stores the key distribution for a table.

ANALYZE TABLE t1;