~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/year.test

  • Committer: Monty Taylor
  • Date: 2009-01-30 04:45:55 UTC
  • mfrom: (779.4.10 devel)
  • mto: (779.7.3 devel)
  • mto: This revision was merged to the branch mainline in revision 823.
  • Revision ID: mordred@inaugust.com-20090130044555-ntb3509c8o6e3sb5
MergedĀ fromĀ me.

Show diffs side-by-side

added added

removed removed

Lines of Context:
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"