Yes, I didn't think there was a bug in SQLite here, but just wanted some confirmation. Thanks for that. I suppose the only way to get to the bottom of this is to run sqlite3.dll, compiled with SQLITE_DEBUG and SQLITE_MEMDEBUG enabled and look at the log/trace.
RBS On Wed, Nov 4, 2015 at 7:42 PM, Richard Hipp <drh at sqlite.org> wrote: > 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 > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >