SET STORAGE_ENGINE = Falcon;
#
# Mantis bug #99:
#
--echo *** Bug #99 ***
--disable_warnings
DROP TABLE IF EXISTS t2;
--enable_warnings

CREATE TABLE t2 (
  a int,
  b int,
  c int,
  d int,
  PRIMARY KEY(a)
);
INSERT INTO t2 VALUES 
  (1,1,1,1),
  (2,2,2,2),
  (3,3,3,3),
  (4,4,4,4),
  (5,5,5,5),
  (6,6,6,6),
  (7,7,7,7),
  (8,8,8,8);
EXPLAIN SELECT distinct(a) FROM t2;

# Final cleanup
DROP TABLE t2;
