~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_time.result

  • Committer: Lee Bieber
  • Date: 2010-08-21 22:42:44 UTC
  • mto: (1727.1.1 build)
  • mto: This revision was merged to the branch mainline in revision 1728.
  • Revision ID: lbieber@kalebral-2.local-20100821224244-kh3gmsvi45dlbuu1
For the feature request (https://blueprints.launchpad.net/drizzle/+spec/limit-maximum-sort-size) 
that is requesting the ability to cap various buffers, we first tried setting the join buffer to 
1 to see how that would affect the test results and expose test results that need to 
sorted (by adding --sorted_result). 

Show diffs side-by-side

added added

removed removed

Lines of Context:
805
805
'2005.09.01' - INTERVAL 6 MONTH AND t2.day;
806
806
id      day     id      day
807
807
1       2005-06-01      1       2005-08-01
808
 
3       2005-07-01      1       2005-08-01
809
808
1       2005-06-01      2       2005-06-15
810
809
1       2005-06-01      3       2005-07-15
 
810
3       2005-07-01      1       2005-08-01
811
811
3       2005-07-01      3       2005-07-15
812
812
SELECT * FROM t1, t2 
813
813
WHERE CAST(t1.day AS DATE) BETWEEN 
814
814
'2005.09.01' - INTERVAL 6 MONTH AND t2.day;
815
815
id      day     id      day
816
816
1       2005-06-01      1       2005-08-01
817
 
3       2005-07-01      1       2005-08-01
818
817
1       2005-06-01      2       2005-06-15
819
818
1       2005-06-01      3       2005-07-15
 
819
3       2005-07-01      1       2005-08-01
820
820
3       2005-07-01      3       2005-07-15
821
821
DROP TABLE t1,t2;
822
822
create table t1 (field DATE);