~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-20 15:27:43 UTC
  • mfrom: (2097.1.7 drizzle-build)
  • Revision ID: brian@tangent.org-20110120152743-x88aq1sj1k9andwm
Merge of all of the time fixes.

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
 
245
# Legal, Drizzle has 64bit timestamp
246
246
--error ER_INVALID_UNIX_TIMESTAMP_VALUE # Bad timestamp
247
247
select unix_timestamp('2039-01-20 01:00:00');
 
248
 
248
249
--error ER_INVALID_UNIX_TIMESTAMP_VALUE # Bad timestamp
249
250
select unix_timestamp('1968-01-20 01:00:00');
250
 
# bad month
 
251
 
251
252
--error ER_INVALID_UNIX_TIMESTAMP_VALUE # Bad timestamp
252
253
select unix_timestamp('2038-02-10 01:00:00');
 
254
 
253
255
--error ER_INVALID_UNIX_TIMESTAMP_VALUE # Bad timestamp
254
256
select unix_timestamp('1969-11-20 01:00:00');
255
 
# bad day
 
257
 
256
258
--error ER_INVALID_UNIX_TIMESTAMP_VALUE # Bad timestamp
257
259
select unix_timestamp('2038-01-20 01:00:00');
 
260
 
258
261
--error ER_INVALID_UNIX_TIMESTAMP_VALUE # Bad timestamp
259
262
select unix_timestamp('1969-12-30 01:00:00');
260
263