Re: horology and time failures on freebsd/alpha

Oops - just to clarify I accidentally copied too many INSERTs into the
email. The result of the first SELECT is correct compared to the INSERTs
that I did. I copied the INSERTs and CREATE TABLE as-is from timetz.sql

Chris

> -----Original Message-----
> From: Christopher Kings-Lynne [mailto:chriskl(at)familyhealth(dot)com(dot)au]
> Sent: Thursday, 13 February 2003 11:08 AM
> To: Hackers
> Cc: Tom Lane
> Subject: horology and time failures on freebsd/alpha
>
>
> I'm still getting failure, but it gets weirder:
>
> regression=# drop table timetz_tbl;
> DROP TABLE
> regression=# CREATE TABLE TIMETZ_TBL (f1 time(2) with time zone);
>
> INSERT INTO TIMETZ_TBL VALUES ('00:01 PDT');
> CREATE TABLE
> regression=#
> regression=# INSERT INTO TIMETZ_TBL VALUES ('00:01 PDT');
> INSERT INTO TIMETZ_TBL VALUES ('01:00 PDT');
> INSERT INTO TIMETZ_TBL VALUES ('02:03 PDT');
> INSERT INTO TIMETZ_TBL VALUES ('07:07 PST');
> INSERT 154307 1
> regression=# INSERT INTO TIMETZ_TBL VALUES ('01:00 PDT');
> INSERT INTO TIMETZ_TBL VALUES ('02:03 PDT');
> INSERT INTO TIMETZ_TBL VALUES ('07:07 PST');
> INSERT INTO TIMETZ_TBL VALUES ('08:08 EDT');
> INSERT INTO TIMETZ_TBL VALUES ('11:59 PDT');
> INSERT 154308 1
> regression=# INSERT INTO TIMETZ_TBL VALUES ('02:03 PDT');
> INSERT INTO TIMETZ_TBL VALUES ('07:07 PST');
> INSERT INTO TIMETZ_TBL VALUES ('08:08 EDT');
> INSERT INTO TIMETZ_TBL VALUES ('11:59 PDT');
> INSERT INTO TIMETZ_TBL VALUES ('12:00 PDT');
> INSERT INTO TIMETZ_TBL VALUES ('12:01 PDT');
> INSERT 154309 1
> regression=# INSERT INTO TIMETZ_TBL VALUES ('07:07 PST');
> INSERT INTO TIMETZ_TBL VALUES ('08:08 EDT');
> INSERT INTO TIMETZ_TBL VALUES ('11:59 PDT');
> INSERT INTO TIMETZ_TBL VALUES ('12:00 PDT');
> INSERT INTO TIMETZ_TBL VALUES ('12:01 PDT');
> INSERT INTO TIMETZ_TBL VALUES ('23:59 PDT');
> INSERT INTO TIMETZ_TBL VALUES ('11:59:59.99 PM PDT');
> INSERT 154310 1
> regression=# INSERT INTO TIMETZ_TBL VALUES ('08:08 EDT');
> INSERT 154311 1
> regression=# INSERT INTO TIMETZ_TBL VALUES ('11:59 PDT');
> INSERT 154312 1
> regression=# INSERT INTO TIMETZ_TBL VALUES ('12:00 PDT');
> INSERT 154313 1
> regression=# INSERT INTO TIMETZ_TBL VALUES ('12:01 PDT');
> INSERT 154314 1
> regression=# INSERT INTO TIMETZ_TBL VALUES ('23:59 PDT');
> INSERT 154315 1
> regression=# INSERT INTO TIMETZ_TBL VALUES ('11:59:59.99 PM PDT');
> INSERT 154316 1
> regression=# SELECT f1 AS "Time TZ" FROM TIMETZ_TBL;
> Time TZ
> ----------------
> 00:01:00-07
> 01:00:00-07
> 02:03:00-07
> 07:07:00-08
> 08:08:00-04
> 11:59:00-07
> 12:00:00-07
> 12:01:00-07
> 23:59:00-07
> 23:59:59.99-07
> (10 rows)
>
> -- Now run EXACTLY the same query again...
>
> regression=# SELECT f1 AS "Time TZ" FROM TIMETZ_TBL;
> Time TZ
> ----------------
> 00:00:00-07
> 00:00:00-07
> 00:00:00-07
> 00:00:00-08
> 00:00:00-04
> 00:00:00-07
> 00:00:00-07
> 00:00:00-07
> 00:00:00-07
> 00:00:59.99-07
>
> What the heck!!?!?!?! The SELECT statement has somehow edited
> the data in the table or something??? From this point forward,
> the table is all stuffed...
>
> Chris
>