-
Notifications
You must be signed in to change notification settings - Fork 4.1k
Inconsistency with negative intervals #81577
Copy link
Copy link
Open
Labels
A-tools-psycopgC-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.O-communityOriginated from the communityOriginated from the communityT-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Metadata
Metadata
Assignees
Labels
A-tools-psycopgC-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.O-communityOriginated from the communityOriginated from the communityT-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Type
Projects
Status
Bugs to Fix
In PostgreSQL, these two values are considered equal, the expression returns True:
In crdb they are considered different, the expression returns False, even if
extract('epoch' from x)returns -1 for both.Tested with CockroachDB CCL v21.2.10
Jira issue: CRDB-15091
Epic: CRDB-20062