Sorry for the unrelated content below my last message; I responded to a prior post to make sure I got the address right and forgot to clear it.
On 9/18/2015 12:32 AM, Philip Bennefall wrote: > Hi all, > > I have found what I believe is a mistake in the SqLite documentation. > On the page listing the supported pragmas, in the section called > recursive_triggers, it says: > > Support for recursive triggers was added in version 3.6.18 but was > initially turned OFF by default, for compatibility. Recursive triggers > may be turned on by default in future versions of SQLite. > > However, in sqlite.org/limits.html it says: > > Beginning with version 3.7.0, recursive triggers are enabled by > default but can be manually disabled using PRAGMA recursive_triggers. > > Kind regards, > > Philip Bennefall > > On 9/17/2015 10:49 PM, Scott Hess wrote: >> On Thu, Sep 17, 2015 at 1:24 PM, Ralf Junker <ralfjunker at gmx.de> wrote: >> >>> On 17.09.2015 20:14, Scott Hess wrote: >>> >>>> The problem is that there are LOCALE settings where tolower() does >>>> things >>>> C >>>> programmers don't expect. I think tr_TR was one case, the handling >>>> of 'I' >>>> (Google "tr_tr locale bug" and you'll see lots of people hitting >>>> the same >>>> general problem). It isn't a problem of type safety, it's a >>>> problem that >>>> the same inputs might have different outputs for certain library >>>> functions >>>> when you change environment variables. I don't remember whether there >>>> were >>>> specific problems with other ctype functions, or if I just thought >>>> it was >>>> a >>>> good idea to be careful, once I realized the class of problem. >>>> >>> And this check-in therefore misses the point as it does not address >>> this >>> LOCALE problem IMHO: >>> >>> http://www.sqlite.org/src/info/6713e35b8a8c997a >> >> Hmm. Well, it might miss _a_ point, while solidly landing some other >> point >> :-). >> >> Current fts3 seems to spread this code differently, under fts2.c it was >> like: >> >> https://code.google.com/p/chromium/codesearch#chromium/src/third_party/sqlite/src/ext/fts2/fts2.c&l=336 >> >> >> where it's not a wrapper around the library, instead it was a direct >> implementation of the functions which only acted on 7-bit values in the >> ASCII set. >> >> I think these should really be in terms of sqlite3UpperToLower >> and sqlite3CtypeMap. That might be an issue to expose to an extension >> sensibly. >> >> -scott >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> . >> >