clickhouse-tableau-connector-jdbc icon indicating copy to clipboard operation
clickhouse-tableau-connector-jdbc copied to clipboard

Date literal `yyyy-dd-MM ` is rendered by the dialect with wrong format

Open BentsiLeviav opened this issue 9 months ago • 0 comments

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

BentsiLeviav avatar May 07 '24 06:05 BentsiLeviav