Ignored tests #26
Description
In this issue we will document why tests are ignored, this is a necessary step for Tableau connector submissions.
date.datename.month
| actual | expected |
|---|---|
| "April " | "April" |
Query: SELECT TO_CHAR("Calcs"."date2", 'Month') AS "TEMP(Test)(477986140)(0)" FROM "doc"."Calcs" "Calcs" GROUP BY 1
Reason: CrateDB pads months up to 8 characters.
math.round.extended
| actual | expected |
|---|---|
| 1.28901 | 1.28902 |
Query: --
Reason: precision tableau/connector-plugin-sdk#1178
date.datename.sow.month
Reason: Same as date.datename.month
date.dateadd.nulls
Query: SELECT (NULL :: DATE + 1 * INTERVAL '1 day')
Reason: CrateDB does not support certain operations on intervals crate/crate#15634
date.B639952
Query: SELECT SUM(((EXTRACT(EPOCH FROM (CAST(("Calcs"."date3" - 1 * INTERVAL '1 DAY') AS TIMESTAMP) - CAST(((DATE '2004-04-15') + 3 * INTERVAL '1 month') AS DATE))) / (60.0 * 60 * 24)) + 1)) AS "TEMP(Test)(3637530074)(0)", 1.1000000000000001 AS "$__alias__0" FROM "doc"."Calcs" "Calcs" GROUP BY 2
Reason: Same as date.dateadd.nulls