~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/func_time.test

  • Committer: Brian Aker
  • Date: 2011-01-19 18:03:32 UTC
  • mfrom: (2088.8.12 timestamp)
  • mto: This revision was merged to the branch mainline in revision 2098.
  • Revision ID: brian@tangent.org-20110119180332-acfk5i8oofp63s40
Merge in time code.

Show diffs side-by-side

added added

removed removed

Lines of Context:
242
242
 
243
243
# check for invalid dates
244
244
 
245
 
# bad year
246
 
--error ER_INVALID_UNIX_TIMESTAMP_VALUE # Bad timestamp
 
245
# Legal, Drizzle has 64bit timestamp
247
246
select unix_timestamp('2039-01-20 01:00:00');
 
247
 
248
248
--error ER_INVALID_UNIX_TIMESTAMP_VALUE # Bad timestamp
249
249
select unix_timestamp('1968-01-20 01:00:00');
250
 
# bad month
251
 
--error ER_INVALID_UNIX_TIMESTAMP_VALUE # Bad timestamp
 
250
 
252
251
select unix_timestamp('2038-02-10 01:00:00');
 
252
 
253
253
--error ER_INVALID_UNIX_TIMESTAMP_VALUE # Bad timestamp
254
254
select unix_timestamp('1969-11-20 01:00:00');
255
 
# bad day
256
 
--error ER_INVALID_UNIX_TIMESTAMP_VALUE # Bad timestamp
 
255
 
257
256
select unix_timestamp('2038-01-20 01:00:00');
 
257
 
258
258
--error ER_INVALID_UNIX_TIMESTAMP_VALUE # Bad timestamp
259
259
select unix_timestamp('1969-12-30 01:00:00');
260
260