Re: [sqlite] sqlite3ExprCodeIN() problems with SQLITE_OMIT_SUBQUERY
On Dec 1, 2009, at 12:17 PM, Ralf Junker wrote: > > always made me believe that all options to omit features are > supported. > Now I am not sure which ones I can really trust. > > Could you clear up my confusion? > There are several dozen individual compile-time options. We obviously cannot test every combination of compile-time option since there is an exponential explosion in the number of test cases. And so, our strategy is to test only those compile-time configurations that are in common use or which are used by companies that provide material support to SQLite. So, for example, SQLITE_SECURE_DELETE was unsupported for a long time. Then we discovered that SQLITE_SECURE_DELETE is used in Firefox. So now we are very careful to test SQLITE_SECURE_DELETE before each release. Actually, we know exactly which compile-time options Mozilla uses, and we test that exact combination of compile- time options. A different set of compile-time options are used by Symbian/Nokia, and by Bloomberg, and so forth. We test all of these configurations carefully. But those are only a handful of configurations out of the billions and billions of possible ways of configuring SQLite. As it happens, we are not aware of any major product using SQLITE_OMIT_SUBQUERY. Nor do any of our sponsors use or desire that option, as far as we are aware. Nor is it an especially useful option, in most peoples view. And so testing and maintaining SQLITE_OMIT_SUBQUERY is pretty low on our list of priorities. I'm sorry to disappoint, but the fact is that we do have to prioritize things. The SQLite developers do not have any idle cycles at the moment. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3ExprCodeIN() problems with SQLITE_OMIT_SUBQUERY
On 01.12.2009 18:35, Jay A. Kreibich wrote: > Important Note: The SQLITE_OMIT_* compile-time options are > unsupported. Oops! Thanks for focusing my eyes - they tend to skip introductions and move right to the details. Now having that read, let me point out that in spite of the statement the SQLITE_OMIT_... options have worked nearly flawlessly for me over the last few years. If there were little glitches, they were usually fixed very quickly. Thank you, SQLite team! Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3ExprCodeIN() problems with SQLITE_OMIT_SUBQUERY
On Tue, Dec 01, 2009 at 06:17:49PM +0100, Ralf Junker scratched on the wall: > Reading > >http://www.sqlite.org/compile.html > > always made me believe that all options to omit features are supported. Read closer: 1.6 Options To Omit Features ... Important Note: The SQLITE_OMIT_* compile-time options are unsupported. The SQLITE_OMIT_* compile-time options are usually untested and are almost certainly untested in combination. Any or all of these options may be removed from the code in future releases and without warning. For any particular release, some of these options may cause compile-time or run-time failures, particularly when used in combination with other options. The "Important Note" is in bold and italics. I suggest you re-read the whole intro to section 1.6. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3ExprCodeIN() problems with SQLITE_OMIT_SUBQUERY
On 01.12.2009 18:05, D. Richard Hipp wrote: > The key point to bare in mind here is that SQLITE_OMIT_SUBQUERY is > not a supported compile-time option. None of the major users of > SQLite make use of SQLITE_OMIT_SUBQUERY. We do not test it. And it > appears that it is broken in the current implementation. It is > unlikely to be fixed for 3.6.21. Thank you for pointing this out! I was not aware that there are supported and unsupported compile-time options. Reading http://www.sqlite.org/compile.html always made me believe that all options to omit features are supported. Now I am not sure which ones I can really trust. Could you clear up my confusion? Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3ExprCodeIN() problems with SQLITE_OMIT_SUBQUERY
On Dec 1, 2009, at 11:53 AM, Ralf Junker wrote: > Compiling with SQLITE_OMIT_SUBQUERY, sqlite3ExprCodeIN() is compiled > out > but at the same time still required at other places in expr.c. > > As such, expr.c does not link well with SQLITE_OMIT_SUBQUERY defined. > > After I wrapped the remaining references to sqlite3ExprCodeIN() by > #ifndef SQLITE_OMIT_SUBQUERY it compiles fine. Am I safe to do so or > are > there any caveats? It looks like adding the extra #ifndefs breaks other things - specifically the IN operator. The key point to bare in mind here is that SQLITE_OMIT_SUBQUERY is not a supported compile-time option. None of the major users of SQLite make use of SQLITE_OMIT_SUBQUERY. We do not test it. And it appears that it is broken in the current implementation. It is unlikely to be fixed for 3.6.21. > > Ralf > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] sqlite3ExprCodeIN() problems with SQLITE_OMIT_SUBQUERY
Compiling with SQLITE_OMIT_SUBQUERY, sqlite3ExprCodeIN() is compiled out but at the same time still required at other places in expr.c. As such, expr.c does not link well with SQLITE_OMIT_SUBQUERY defined. After I wrapped the remaining references to sqlite3ExprCodeIN() by #ifndef SQLITE_OMIT_SUBQUERY it compiles fine. Am I safe to do so or are there any caveats? Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users