~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/select.result

  • Committer: lbieber
  • Date: 2010-09-22 17:19:07 UTC
  • mfrom: (1782.4.1 refactor)
  • mto: This revision was merged to the branch mainline in revision 1786.
  • Revision ID: lbieber@orisndriz08-20100922171907-b0gsni6pkeg254v6
Merge Brian - Fix for 64bit issue around timestamp so we don't run into problems in 2027!

Show diffs side-by-side

added added

removed removed

Lines of Context:
3225
3225
AND t1.ts BETWEEN "2006-01-01" AND "2006-12-31";
3226
3226
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
3227
3227
1       SIMPLE  t2      const   PRIMARY PRIMARY 4       const   1       
3228
 
1       SIMPLE  t1      range   ts      ts      5       NULL    1       Using where
 
3228
1       SIMPLE  t1      range   ts      ts      9       NULL    1       Using where
3229
3229
SELECT * FROM t1 LEFT JOIN t2 ON (t1.a=t2.a) WHERE t1.a=30
3230
3230
AND t1.ts BETWEEN t2.dt1 AND t2.dt2
3231
3231
AND t1.ts BETWEEN "2006-01-01" AND "2006-12-31";