~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/select.test

  • Committer: Brian Aker
  • Date: 2008-08-01 22:38:22 UTC
  • Revision ID: brian@tangent.org-20080801223822-0hh22boeev5xa8p5
Removed ALTER TABLE UPGRADE.

We have nothing to upgrade from :)

Show diffs side-by-side

added added

removed removed

Lines of Context:
1642
1642
# Group with extra not group fields.
1643
1643
#
1644
1644
 
1645
 
select companynr|0,companyname from t4 group by 1;
 
1645
select companynr,companyname from t4 group by 1;
1646
1646
select t2.companynr,companyname,count(*) from t2,t4 where t2.companynr=t4.companynr group by t2.companynr order by companyname;
1647
1647
select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name;
1648
1648