~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/select.result

  • Committer: Brian Aker
  • Date: 2009-08-18 07:19:56 UTC
  • mfrom: (1116.1.3 stewart)
  • mto: This revision was merged to the branch mainline in revision 1118.
  • Revision ID: brian@gaz-20090818071956-nfpoe9rp3i7p50kx
Merge my branch from Stewart into one branch

Show diffs side-by-side

added added

removed removed

Lines of Context:
1237
1237
companyname char(30) NOT NULL default '',
1238
1238
PRIMARY KEY (companynr),
1239
1239
UNIQUE KEY companyname(companyname)
1240
 
) ENGINE=MyISAM MAX_ROWS=50 COMMENT='companynames';
 
1240
) ENGINE=MyISAM COMMENT='companynames';
1241
1241
select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t2.companynr;
1242
1242
companynr       companyname
1243
1243
0       Unknown