ClickHouse / metabase-clickhouse-driver

ClickHouse database driver for the Metabase business intelligence front-end
Apache License 2.0
476 stars 92 forks source link

Prepare 1.2.2 #194

Closed slvrtrn closed 1 year ago

slvrtrn commented 1 year ago

For example, now toStartOfHour and similar functions will not be forced to call CAST:

SELECT
  ` toStartOfHour ` (` default `.` wares `.` createdAt `) AS ` createdAt `,
  COUNT(*) AS ` count `
FROM
  ` default `.` wares `
WHERE
  ` default `.` wares `.` createdAt ` < ` parseDateTimeBestEffort ` ('2023-09-28 00:00:00.000Z')
GROUP BY
  ` toStartOfHour ` (` default `.` wares `.` createdAt `)
ORDER BY
  ` toStartOfHour ` (` default `.` wares `.` createdAt `) ASC

NB1: parseDateTimeBestEffort here still relies on the server timezone. NB2: odd backtick spacing is due to a bug in Metabase itself.

NB: IPv4/IPv6 columns are temporarily resolved as type/TextLike instead of type/IPAddress base type due to an unexpected result in Metabase 0.47 type check, which leads to crashes in specific queries (at least in the tests). It was fixed on the main branch, but it is not part of any 0.47.x released yet.

Checklist