You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm not sure this is a bug. I see the following on Mysql:
SELECT ['abc'].ifnull(['def'])
ERROR 1064 (42000) at line 17: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '['abc'].ifnull(['def'])' at line 1
Postgres is also similar:
psql:commands.sql:30: ERROR: syntax error at or near "["
LINE 1: SELECT ['abc'].ifnull(['def'])
What happens?
Function chaining works correctly for the nullif function, but returns an error for the ifnull function.
To Reproduce
nullif:
SELECT ['abc'].nullif(['def'])
correctly returns ['abc']ifnull without chaining:
SELECT ifnull(['abc'], ['def'])
correctly returns ['abc'].ifnull with function chaining:
SELECT ['abc'].ifnull(['def'])
returns an error of "Parser Error: Wrong number of arguments to IFNULL."OS:
Mac M1
DuckDB Version:
0.10.1
DuckDB Client:
Python
Full Name:
Dan Gottlieb
Affiliation:
Central Square Solutions
What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.
I have tested with a stable release
Did you include all relevant data sets for reproducing the issue?
Yes
Did you include all code required to reproduce the issue?
Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?
The text was updated successfully, but these errors were encountered: