COALESCE function is not implemented
Found while working on #314 (closed).
$ cat test0002.sql
-- Derived from https://github.com/shivarajugowda/jdbcSQLTest/tree/master/resources/sqllogictest
-- III rowsort
SELECT abs(b-c),
b,
a+b*2+c*3+d*4
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND (a>b-2 AND a<b+2)
;
$ octo -f test0002.sql
> Error with syntax near (line 7, column 8):
WHERE coalesce(a,b,c,d,e)<>0
^^^^^^^^
> [ERROR] /home/joshua/src/yottadb/octo/src/find_function.c:121 2020-06-26 15:11:33 : Unknown function: COALESCE
> [ERROR] /home/joshua/src/yottadb/octo/src/parse_line.c:41 2020-06-26 15:11:33 : Error parsing statement: -- Derived from https://github.com/shivarajugowda/jdbcSQLTest/tree/master/resources/sqllogictest
Requires the changes from !682 (merged) in order to be fixed (COALESCE
doesn't make sense unless you have a NULL
value to go with it).
Postgres documentation for COALESCE: https://www.postgresql.org/docs/current/functions-conditional.html#FUNCTIONS-COALESCE-NVL-IFNULL
Edited by Jynn Nelson