Skip to content

sql: 'infinity' returned as timestamp rather than 'infinity' #41564

@asubiotto

Description

@asubiotto

Ran into this while running the lib/pq test suite:
Postgres:

asubiotto=# SELECT 'infinity'::timestamp;                                        
 timestamp 
-----------
 infinity

Cockroach:

root@:26257/defaultdb> SELECT 'infinity'::timestamp;
                  timestamp
+-------------------------------------------+
  -292277022365-05-08 08:17:07.854776+00:00
(1 row)

Jira issue: CRDB-5433

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-sql-builtinsSQL built-in functions and semantics thereof.A-tools-efcoreC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)E-starterMight be suitable for a starter project for new employees or team members.T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions