Skip to content

[YSQL] Bug: Connection Manager passes TimeZone in wrong case #28537

@donBizzell

Description

@donBizzell

Jira Link: DB-18236

Description

The timezone parameter is passed in all lowercase causing it not to be set.
Discovered by Bringq here are their notes:

Debugging this problem, I noticed that the QueryExecutorImpl class is receiving time zone parameters in lowercase - timezone - instead of TimeZone. That is causing the time zone not to be set.

Image

when NOT using YSQL connection manager, the parameter is received in correct case

Image

Tried setting the following, but did not help.
alter database dev01db set TimeZone=UTC;

alter user dev01 set TimeZone=UTC;

Steps to Reproduce:

  1. [Provide steps to reproduce the bug]
  2. [Describe actual vs expected behavior]e s

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

  • I confirm this issue does not contain any sensitive information.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions