~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/order_by.test

• browse files at revision 1638.10.109
• compare with another revision
• download diff
• download tarball
• view history from revision 1638.10.109

• reverse the comparison (1638.10.109 to 1441)
• stop comparing with revision 1441

Show diffs side-by-side

added

removed

tests/t/order_by.test

742

742

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

743

743

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

744

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

 

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1