Skip to content

[BUG] MIN or MAX on a 'TIMESTAMP_NTZ' column returns a TIMESTAMP type instead of TIMESTAMP_NTZ #1495

Description

@ericcournarie

Describe the bug
The return of MIN and MAX (at least, did not test all functions) of a 'TIMESTAMP_NTZ' column returns a TIMESTAMP type instead of TIMESTAMP_NTZ

To Reproduce
Create a table like
CREATE TABLE bug_min (
TIMESTAMP_NTZ timestamp_ntz
)
and run
SELECT
MIN(TIMESTAMP_NTZ) AS MIN_TIMESTAMP_NTZ_0,
MAX(TIMESTAMP_NTZ) AS MAX_TIMESTAMP_NTZ_0
FROM bug_min

Check the type of returned column, they are of type TIMESTAMP

Expected behavior
Both column returned should be of type TIMESTAMP_NTZ, but they are of type TIMESTAMP

Screenshots

Client side logs

Client Environment (please complete the following information):

  • OS: [Mac
  • Java version 17
  • Java vendor OpenJDK
  • Driver Version 3.4.1
  • BI Tool
  • BI Tool version

Additional context

This was working with version 3.0.7

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions