On 11/4/15, Bart Smissaert <bart.smissaert at gmail.com> wrote: > Been trying to get to the bottom of this, but no success. > Note that with one UDF in the statement all runs perfectly fine. > Could somebody confirm that they can run 2 UDF's (I have mainly tried with > the 2 the same UDF's) in the same SQL and that all > runs as how it should? Just to make sure there is nothing wrong here with > SQLite itself. >
SQLite does not really distinguish between application-defined functions and built-in functions. They both work by exactly the same mechanism. There are probably millions of SQLite queries with multiple functions running at any given moment in time. There are probably thousands of test cases in the SQLite test suite of queries that use two or more application-defined functions - real application-defined functions, not built-ins. In particular, there are many many test cases of application-defined functions doing hard things like invoking SQLite recursively. -- D. Richard Hipp drh at sqlite.org
