#---- Bug 229 ----
SET STORAGE_ENGINE='Falcon';
DROP TABLE IF EXISTS t2;
CREATE TABLE t2 (s1 int, key (s1));
INSERT INTO t2 (s1) VALUES (1),(2),(3),(4),(5),(6),(7),(8);
INSERT INTO t2 SELECT * FROM t2;
INSERT INTO t2 SELECT * FROM t2;
INSERT INTO t2 SELECT * FROM t2;
INSERT INTO t2 SELECT * FROM t2;
INSERT INTO t2 SELECT * FROM t2;
INSERT INTO t2 SELECT * FROM t2;
INSERT INTO t2 SELECT * FROM t2;
UPDATE t2 SET s1 = 99 WHERE s1 = 2;
SELECT s1,count(*) FROM t2 GROUP BY s1;
s1	count(*)
1	128
3	128
4	128
5	128
6	128
7	128
8	128
99	128
DROP TABLE t2;
