2010YOUY01 commented on issue #11313: URL: https://github.com/apache/datafusion/issues/11313#issuecomment-2212372720
> We not only follow Postgres but also DuckDB or others. We usually follow the majority, otherwise we choose either of them (usually Postgres, but not restricted to) > > We have the same result as DuckDB in this case, so I think we don't need to convert it to error. So many SQL dialects 🤣 It's just my preference to not use number in boolean expressions: treating non-zero as true seems like a historical and C-specific convention, using this rule in SQL can cause confusion (like WHERE in SQL doesn't allow numeric expression too) Since I'm not planning to implement it, so close this issue, feel free to reopen it when necessary -- 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
