← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/year.test

  • Committer: Jay Pipes
  • Date: 2009-01-28 18:31:33 UTC
  • mto: This revision was merged to the branch mainline in revision 817.
  • Revision ID: jpipes@serialcoder-20090128183133-3rlb2hpq5tdlgoyy
Fixes MONTH() function to use new Temporal system.  Errors
are now always reported on bad datetime values.

Adds new test case for MONTH() function.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/year.test
71
71
SELECT YEAR('07/31/2009');
72
72
 
73
73
# 
74
 
# The following tests should produce errors for YEAR().    
75
 
# 
76
 
 
77
 
#
78
 
# Test boundary dates for YEAR 
79
 
#
80
 
 
81
 
# 
82
74
# Tests for alternate DATETIME syntaxes 
83
75
# in string and numeric formats. All should
84
76
# return 2009.
113
105
, blob_fld BLOB NOT NULL
114
106
);
115
107
 
 
108
# Should all output 2007
116
109
INSERT INTO t1 VALUES (
117
110
20071130
118
111
, "2007-11-30"