~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/timezone.result

  • Committer: Lee
  • Date: 2008-12-19 21:59:48 UTC
  • mto: (754.1.1 devel) (758.1.3 devel)
  • mto: This revision was merged to the branch mainline in revision 725.
  • Revision ID: lbieber@lbieber-desktop-20081219215948-bd6sytqfkxzd0v64
enable warnings test and fix timezone test to comment out the failing test

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
FROM_UNIXTIME(24*3600)
 
2
1970-01-02 01:00:00
1
3
DROP TABLE IF EXISTS t1;
2
4
show variables like "system_time_zone";
3
5
Variable_name   Value
34
36
DROP TABLE t1;
35
37
CREATE TABLE t1 (ts timestamp);
36
38
INSERT INTO t1 (ts) VALUES ('2003-03-30 01:59:59'),
37
 
('2003-03-30 02:59:59'),
38
39
('2003-03-30 03:00:00');
39
 
Warnings:
40
 
Warning 1299    Invalid TIMESTAMP value in column 'ts' at row 2
41
40
DROP TABLE t1;
42
41
select unix_timestamp('1970-01-01 01:00:00'), 
43
42
unix_timestamp('1970-01-01 01:00:01'),