~drizzle-trunk/drizzle/development

This is:
1) First pass to have Share use something other then mem_root allocated bits.
2) A bug fix on how keys are matched for with USE INDEX, etc.

added added

removed removed

742

INSERT INTO t1 SELECT a +32, b +32 FROM t1;

743

INSERT INTO t1 SELECT a +64, b +64 FROM t1;

744

745

--error 1176

745

746

SELECT a FROM t1 IGNORE INDEX FOR GROUP BY (a, ab) GROUP BY a;

746

747

748

SELECT a FROM t1 IGNORE INDEX FOR GROUP BY (primary, ab) GROUP BY a;

749

747

750

SELECT @tmp_tables_after = @tmp_tables_before ;

748

751

752

--error 1176

749

753

SELECT a FROM t1 IGNORE INDEX FOR ORDER BY (a, ab) ORDER BY a;

754

SELECT a FROM t1 IGNORE INDEX FOR ORDER BY (primary, ab) ORDER BY a;

750

755

751

756

SELECT @tmp_tables_after = @tmp_tables_before;

752

757