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
Optional function arguments on computed columns are not accounted for when values are passed to the function. This means if you skip an optional parameter, the next parameter is passed in it's place and will be wrong.
Steps to reproduce
The function below accepts two ints and one float.
The last argument is in the wrong place and will error, in this case: ERROR: function public.image_src(image, integer, double precision) does not exist.
Possible Solution
Use named parameters when calling computed functions with parameters, so:
Summary
Optional function arguments on computed columns are not accounted for when values are passed to the function. This means if you skip an optional parameter, the next parameter is passed in it's place and will be wrong.
Steps to reproduce
The function below accepts two
int
s and onefloat
.When called from GraphQL the generated SQL looks like this:
The last argument is in the wrong place and will error, in this case:
ERROR: function public.image_src(image, integer, double precision) does not exist
.Possible Solution
Use named parameters when calling computed functions with parameters, so:
The text was updated successfully, but these errors were encountered: