~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/join.result

  • Committer: Andy Lester
  • Date: 2008-08-10 02:15:48 UTC
  • mto: (266.1.31 use-replace-funcs)
  • mto: This revision was merged to the branch mainline in revision 295.
  • Revision ID: andy@petdance.com-20080810021548-0zx8nhzva6al10k3
Added a proper const qualifer.

Show diffs side-by-side

added added

removed removed

Lines of Context:
165
165
d
166
166
2001-08-01
167
167
0000-00-00
168
 
Warnings:
169
 
Error   1365    Division by 0
170
 
Error   1365    Division by 0
171
 
Error   1365    Division by 0
172
168
DROP TABLE t1,t2;
173
169
CREATE TABLE t1 (
174
170
Document_ID varchar(50) NOT NULL default '',
252
248
) ENGINE=MyISAM;
253
249
INSERT INTO t1 VALUES (12,5,'Percent','Cost',-1,0,-1,-1),(14,4,'Percent','Cost',-1,0,-1,-1),(18,5,'Percent','Cost',-1,0,-1,-1),(19,4,'Percent','Cost',-1,0,-1,-1),(20,5,'Percent','Cost',100,-1,22,291),(21,5,'Percent','Cost',100,-1,18,291),(22,1,'Percent','Cost',100,-1,6,291),(23,1,'Percent','Cost',100,-1,21,291),(24,1,'Percent','Cost',100,-1,9,291),(25,1,'Percent','Cost',100,-1,4,291),(26,1,'Percent','Cost',100,-1,20,291),(27,4,'Percent','Cost',100,-1,7,202),(28,1,'Percent','Cost',50,-1,-1,137),(29,2,'Percent','Cost',100,-1,4,354),(30,2,'Percent','Cost',100,-1,9,137),(93,2,'Cost','Cost',-1,10000000,-1,-1);
254
250
CREATE TABLE t2 (
255
 
id int NOT NULL auto_increment,
 
251
id int unsigned NOT NULL auto_increment,
256
252
name varchar(255) default NULL,
257
253
PRIMARY KEY  (id)
258
254
) ENGINE=MyISAM;