← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_time.result

  • Committer: lbieber
  • Date: 2010-08-23 22:45:16 UTC
  • mfrom: (1727.2.1 staging)
  • Revision ID: lbieber@orisndriz03-20100823224516-k12j5r4znqnznr9d
Merge Vijay - bug 621866 - Changed --transaction-log.sync-method to --transaction-log.flush-frequency
Merge Lee - bug 622005 updateing test results that need to sorted by adding --sorted_result - 
Merge Andrew - bug #617537 re-connect connectionID is wrong 
Merge Andrew - bug #617534 incorrect error when reconnecting

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/func_time.result
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);