Hi folks, We currently return incorrect query results for predicates like `int_col < '123'`, because the integer column gets cast to a string and the comparison is done lexicographically:
https://github.com/apache/datafusion/issues/15161 There's a few possible approaches we could take here, which are described in the issue. It basically depends on how much (if at all) we'd like to tighten up the type coercion rules (for example, we currently allow `text_col = int_col` at planning-time; should we reject such an expression?) -- we could choose to be more aggressive about rejecting such queries at planning-time, at the expense of breaking more users. It would be great to reach a consensus on what we want to do here, so if anyone has an opinion on the best path forward, please share it! Thanks, Neil
