~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/select.result

  • Committer: Brian Aker
  • Date: 2009-08-17 06:21:44 UTC
  • mto: This revision was merged to the branch mainline in revision 1118.
  • Revision ID: brian@gaz-20090817062144-8lxn1sg93pd8nhev
Remove PACK_KEYS

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 PACK_KEYS=1 COMMENT='companynames';
 
1240
) ENGINE=MyISAM MAX_ROWS=50 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