search

MaterializeInc / materialize

The Cloud Operational Data Store: use SQL to transform, deliver, and act on fast-changing data.
https://materialize.com
Other
5.71k stars 466 forks source link

`BC` suffix for timestamps not recognized #27928

Open antiguru opened 2 months ago

antiguru commented 2 months ago

What version of Materialize are you using?

v0.105.0

What is the issue?

This works in Postgres:

SELECT '0001-12-31 19:03:58 BC'::timestamp;
       timestamp        
------------------------
 0001-12-31 19:03:58 BC

Fails in Materialize:

failed to cast raw column: invalid input syntax for type timestamp: Invalid timezone string (BC): 'BC' is not a valid timezone. Failed to parse BC at token index 0: "0001-12-31 10:00:00 BC"
maddyblue commented 1 month ago

wip branch at https://github.com/maddyblue/materialize/tree/parse-bc

this is much harder than i had hoped (reasons in the commit message) and i'm not working on it more at the moment.