Jeffrey Vo

> Off-topic warning: the below behavior is not related to this PR > > It seems that if prune is disabled, then filter pushdown will also be disabled as the...

Actually, does the datafusion pypi package even include datafusion-cli in the first place? :thinking: I did a quick search through https://github.com/apache/arrow-datafusion-python and found no actual mention of datafusion-cli (though in...

Datafusion does actually support this it seems: ```sql ❯ select log(arrow_cast('+Infinity', 'Float32')); +------------------------+ | log(Utf8("+Infinity")) | +------------------------+ | inf | +------------------------+ 1 row in set. Query took 0.002 seconds. ❯...

Yeah that would seem reasonable. I guess it would involve changing the signatures of the math functions to also accept Utf8 data type, then try parse into float (or something...

I've updated the issue title to better reflect this :+1: (Since less of an issue with infinity, and more just a general data type issue with math functions)

> @Jefffrey But I think this cast should be an implicit conversion. If not, maybe we should indicate this in the tests and documentation. Yes, I think this is what...

Another case: ```sql DataFusion CLI v37.0.0 ❯ create external table test123(a string, ```a=b``` string) stored as parquet location '/tmp/test123/' partitioned by (`a=b`); 0 row(s) fetched. Elapsed 0.002 seconds. ❯ insert...

~~There's `nullif` already: https://arrow.apache.org/datafusion/user-guide/sql/scalar_functions.html#nullif~~ ~~Could add `ifnull` as an alias if there's need for it I suppose~~ :thinking: Edit: ah my mistake, seems `nullif` does something different than `ifnull`

Looks like duplicate of https://github.com/Alexhuszagh/rust-lexical/issues/91

arrow-rs pyo3 upgrade for tracking: https://github.com/apache/arrow-rs/pull/5566