You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When selecting a timestamp or timestamptz column directly from PG, the output will look like: 0214-02-05 15:40:00+00 BC. When selecting the same data from a cached query, the output looks like this: -0213-02-05 15:40:00 +00:00. While the years appear to be an off-by-one error, they actually represent the same point in time, just expressed differently: 214-…. BC vs -213…. I believe this is an artifact of the way be must parse BC dates wrt the chrono crate, in readyset-data::TimestatmpTz::from_str().
Steps to reproduce
noria=> create table bc_testtz(t timestamptz);
CREATE TABLE
noria=> insert into bc_testtz values('214-02-05 15:40:00+00 BC');
INSERT 0 1
noria=> select * from bc_testtz;
t
---------------------------
0214-02-05 15:40:00+00 BC
(1 row)
noria=> create cache from select * from bc_testtz;
noria=> select * from bc_testtz;
t
-----------------------------
-0213-02-05 15:40:00 +00:00
(1 row)
Upstream DB type and version
Postgres, any version. This will probably apply to MySQL, as well, although I have not tried it out.
The text was updated successfully, but these errors were encountered:
Summary
When selecting a
timestamp
ortimestamptz
column directly from PG, the output will look like:0214-02-05 15:40:00+00 BC
. When selecting the same data from a cached query, the output looks like this:-0213-02-05 15:40:00 +00:00
. While the years appear to be an off-by-one error, they actually represent the same point in time, just expressed differently:214-…. BC
vs-213…
. I believe this is an artifact of the way be must parse BC dates wrt thechrono
crate, inreadyset-data::TimestatmpTz::from_str()
.Steps to reproduce
Upstream DB type and version
Postgres, any version. This will probably apply to MySQL, as well, although I have not tried it out.
The text was updated successfully, but these errors were encountered: