Can't filter by a transformed time column

[devbrian]

influxdb3 query \
  --database sports\
  "SELECT \
fanduel_pending, \
date_trunc('day', tz(time, 'America/Detroit')) as time \
FROM sportsbook_wallet \
WHERE date_trunc('day', tz(time, 'America/Detroit')) >= cast('2025-03-12T04:00:00Z' as timestamp)"

This query fails with error:

Query command failed: server responded with error [500 Internal Server Error]: query error: error while planning query: External error: unable to analyze provided filters for a boundary on the time column

This query works as expected:

influxdb3 query \
  --database sports\
  "SELECT \
fanduel_pending, \
date_trunc('day', tz(time, 'America/Detroit')) as time \
FROM sportsbook_wallet \
WHERE time >= cast('2025-03-12T04:00:00Z' as timestamp)"

Anytime a transformation is applied to the time column, you are not able to filter your query by it.

I am on influxdb3 beta using -
quay.io/influxdb/influxdb3-core:latest@sha256:506d47004afa9bec39aec2a401af74d171f8ba39bc66e5d9a29f1a9661a3e5d0

[hiltontj]

I created a reproducer for this here: #26322

It looks like the time boundary analyzer in DataFusion is not handling the date_trunc on the left-hand side of the filter. I think that this part of the error:

Only intervals with the same data type are comparable, lhs:Null, rhs:Timestamp(Nanosecond, None)

indicates that the inferred type of the date_trunc is Null, i.e., it isn't inferring the type.

[hiltontj]

The error is originating from this line:

influxdb/influxdb3_write/src/lib.rs

Line 390 in 8507bdc

.context("unable to analyze provided filters for a boundary on the time column")?;