clickhouse-tableau-connector-jdbc
clickhouse-tableau-connector-jdbc copied to clipboard
Date literal `yyyy-dd-MM ` is rendered by the dialect with wrong format
As part of our effort to improve the connector's test coverage, we tested it with TDVT and found the following issue for the following test:
- Test Name - logical
- Test Case - IFNULL([date0], # 4/12/2010#) [the space is redundant, added it so Github won't interpret it as a reference\
- Generated query -
SELECT ifNull(""Calcs"".""date0"", DATE '2010-12-04') AS ""TEMP(Test)(2677874078)(0)""
FROM ""public"".""Calcs"" ""Calcs""
GROUP BY ""TEMP(Test)(2677874078)(0)""
The test case includes this date #4/12/2010#
with the format of MM/dd/yyyy
, but the generated SQL creates the date 2010-12-04
with the format of yyyy-dd-MM
even though format-date-literal
formula is set to 'yyyy-MM-dd'
.
A discussion is being held in TDVT's repo: tableau/connector-plugin-sdk#1222