search

risingwavelabs / risingwave

Best-in-class stream processing, analytics, and management. Perform continuous analytics, or build event-driven applications, real-time ETL pipelines, and feature stores in minutes. Unified streaming and batch. PostgreSQL compatible.
https://go.risingwave.com/slack
Apache License 2.0
6.78k stars 561 forks source link

bug: confusing err when parsing ancient timestamptz #13611

Open xiangjinwu opened 9 months ago

xiangjinwu commented 9 months ago 
create table test (
  tz timestamptz
);

insert into test values ('0001-01-01 00:00:00Z');

will cause Parse error: Can't cast string to timestamp (expected format is YYYY-MM-DD HH:MM:SS[.D+{up to 6 digits}] or YYYY-MM-DD HH:MM or YYYY-MM-DD or ISO 8601 format). '1969-01-01 00:00:00Z' is ok.

_Originally posted by @xuefengze in https://github.com/risingwavelabs/risingwave/pull/13496#discussion_r1402886878_

xiangjinwu commented 9 months ago

Not useful in practice, but common when people tries to test edge cases.