~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/group_by.test

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

• reverse the comparison (2060 to 2165.1.3)
• stop comparing with revision 2165.1.3

Show diffs side-by-side

added

removed

tests/t/group_by.test

7

7

#

8

8

# Simple test without tables

9

9

 

10

 

--error ER_INVALID_GROUP_FUNC_USE

 

10

-- error 1111

11

11

SELECT 1 FROM (SELECT 1) as a  GROUP BY SUM(1);

12

12

 

13

13

#

750

750

select * from t1 group by f1;

751

751

select * from t1 group by f2;

752

752

select * from t1 group by f1, f2;

753

 

select t1.f1,t.* from t1, t1 t where t1.f1 >= 0 group by 1;

 

753

select t1.f1,t.* from t1, t1 t group by 1;

754

754

drop table t1;

755

755

 

756

756

#

• Older »

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