~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 06:31:31 UTC
  • mto: This revision was merged to the branch mainline in revision 2098.
  • Revision ID: brian@tangent.org-20110120063131-zxb0w5iwfhxn37zb
Place limits on timestamp (unforunatly)

Show diffs side-by-side

added added

removed removed

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