~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/timezone.test

  • Committer: Monty Taylor
  • Date: 2009-03-02 23:14:32 UTC
  • mto: This revision was merged to the branch mainline in revision 910.
  • Revision ID: mordred@inaugust.com-20090302231432-i35xehp7uzo6hjjw
Updated build system to use new version numbering. Just remember to run ./config/autorun.sh before running make distcheck for release and all should be peachy.

Show diffs side-by-side

added added

removed removed

Lines of Context:
13
13
DROP TABLE IF EXISTS t1;
14
14
--enable_warnings
15
15
 
 
16
# The following is because of daylight saving time
 
17
--replace_result MEST MET
 
18
show variables like "system_time_zone";
 
19
 
16
20
#
17
21
# Test unix timestamp
18
22
#
54
58
#
55
59
# Test for fix for Bug#2523 Check that boundary dates are processed
56
60
# correctly.
57
 
# -- scratch the above, Drizzle allows for longer dates.
58
61
#
59
 
select unix_timestamp('1970-01-01 00:00:00');
60
 
select unix_timestamp('1970-01-01 00:00:01');
61
 
select unix_timestamp('2038-01-19 03:14:07');
62
 
--error ER_INVALID_UNIX_TIMESTAMP_VALUE # Bad timestamp
63
 
select unix_timestamp('2038-01-19 03:14:08');
 
62
select unix_timestamp('1970-01-01 01:00:00'), 
 
63
       unix_timestamp('1970-01-01 01:00:01'),
 
64
       unix_timestamp('2038-01-19 04:14:07'),
 
65
       unix_timestamp('2038-01-19 04:14:08');
64
66
 
65
67
# End of 4.1 tests