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
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_NTZtimestamp_ntz)
and run
SELECT
MIN(
TIMESTAMP_NTZ) ASMIN_TIMESTAMP_NTZ_0,MAX(
TIMESTAMP_NTZ) ASMAX_TIMESTAMP_NTZ_0FROM 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):
Additional context
This was working with version 3.0.7