Re: [sqlite] [EXTERNAL] Ignore missing UDFs for command-line EXPLAIN?

2017-12-01 Thread nomad
On Wed Nov 29, 2017 at 01:57:29PM +, David Raymond wrote: > http://www.sqlite.org/compile.html > > SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION Exactly what I was looking for, just in the wrong places. Thanks David. -- Mark Lawrence ___ sqlite-users

Re: [sqlite] [EXTERNAL] Ignore missing UDFs for command-line EXPLAIN?

2017-11-29 Thread David Raymond
oun...@mailinglists.sqlite.org] On Behalf Of Hick Gunter Sent: Wednesday, November 29, 2017 5:38 AM To: 'SQLite mailing list' Subject: Re: [sqlite] [EXTERNAL] Ignore missing UDFs for command-line EXPLAIN? You need to duplicate whatever method you use to load your UDFs in your application

Re: [sqlite] [EXTERNAL] Ignore missing UDFs for command-line EXPLAIN?

2017-11-29 Thread Hick Gunter
29. November 2017 11:10 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] [EXTERNAL] Ignore missing UDFs for command-line EXPLAIN? On Wed Nov 29, 2017 at 09:21:47AM +, Hick Gunter wrote: > What about loading your UDF in the CLI? Do you mean wit

Re: [sqlite] [EXTERNAL] Ignore missing UDFs for command-line EXPLAIN?

2017-11-29 Thread nomad
On Wed Nov 29, 2017 at 09:21:47AM +, Hick Gunter wrote: > What about loading your UDF in the CLI? Do you mean with a .so/.dll? Most of my UDFs are written in Perl, as is much of the rest of my code, and are not standalone compiled objects. It would be sufficent if there was a way to write

Re: [sqlite] [EXTERNAL] Ignore missing UDFs for command-line EXPLAIN?

2017-11-29 Thread Hick Gunter
etreff: [EXTERNAL] [sqlite] Ignore missing UDFs for command-line EXPLAIN? The SQLite CLI is a handy tool for explaining query plans and virtual machine opcodes. Unfortunately it mostly doesn't do me any good because of user-defined functions in triggers: sqlite> explain insert into change