Skip to content

An error may occur when reading the timestamptz type. #1176

@johnwiichang

Description

@johnwiichang

Encountered an issue in production: When using timestamptz to store time, during the execution of a SELECT query, performing Next() or Scan() operations on the sql.Rows object may report: expected end of input, got+00:00. After debugging the code, it was found that the data format might be "2022-11-16 05:49:05.517000 +00:00" or "2022-11-16 05:49:05 +00:00", meaning there may be a space before the timezone segment. In the database parameters, the DateStyle is confirmed to be ISO, YMD.

This issue was discovered on the TBase implementation of the PostgreSQL-like database.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions