Omega359 commented on issue #13782: URL: https://github.com/apache/datafusion/issues/13782#issuecomment-2569330925
It's not the nullif, it's the real datatype: ```sql > SELECT 1 - 213220800 * 1::REAL; +----------------------------------------+ | Int64(1) - Int64(213220800) * Int64(1) | +----------------------------------------+ | -213220800.0 | +----------------------------------------+ 1 row(s) fetched. Elapsed 0.001 seconds. > SELECT 1 - 213220800 * 1.0; +------------------------------------------+ | Int64(1) - Int64(213220800) * Float64(1) | +------------------------------------------+ | -213220799.0 | +------------------------------------------+ 1 row(s) fetched. Elapsed 0.001 seconds. > SELECT 1 - 213220800 * 1; +----------------------------------------+ | Int64(1) - Int64(213220800) * Int64(1) | +----------------------------------------+ | -213220799 | +----------------------------------------+ 1 row(s) fetched. Elapsed 0.001 seconds. ``` There is something with the 'real' datatype that is breaking things. I am unsure why `1::REAL` is showing as `Int64(1)` in the first select statement, I am pretty sure it should be a float. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org
