Re: [sqlite] Database file with a nonstandard sqlite_seuence schema causes crash.

This crash (bus error) also occurs when the experiment is done the other way around. A standard sqlite3_sequence table is then renamed and no longer exists as such. And it will not reappear.. It is generous that a pragma writable_schema lets us do these experiments. $ rm test.db; sqlite3

Re: [sqlite] LIMIT with OFFSET is not working in android platform

On Mon, May 21, 2018 at 6:04 PM Richard Hipp wrote: > > LOCAL_CFLAGS += -O0 > > > > LOCAL_CPPFLAGS += -O0 > Looks like you have found a bug in clang. I recommend updating to the > latest version of the compiler that you can get your hands on, and see > if that doesn't fix the

Re: [sqlite] LIMIT with OFFSET is not working in android platform

Thanks, I will do that. Thanks, Sathish On Mon 21 May, 2018, 9:34 PM Richard Hipp, wrote: > On 5/21/18, Sathish Kumar wrote: > > Hi Richard, > > Yes, it works if i disable the compiler optimization. Below is what > i > > used in my Android.mk

Re: [sqlite] LIMIT with OFFSET is not working in android platform

On 5/21/18, Sathish Kumar wrote: > Hi Richard, > Yes, it works if i disable the compiler optimization. Below is what i > used in my Android.mk file. Will it create any side effects if we disable > compiler optimization ? > > LOCAL_CFLAGS += -O0 > > LOCAL_CPPFLAGS +=

Re: [sqlite] LIMIT with OFFSET is not working in android platform

Hi Richard, Yes, it works if i disable the compiler optimization. Below is what i used in my Android.mk file. Will it create any side effects if we disable compiler optimization ? LOCAL_CFLAGS += -O0 LOCAL_CPPFLAGS += -O0 Thanks, Sathish On Fri, May 18, 2018 at 7:28 PM, Sathish Kumar

[sqlite] Feature request: more robust handling of invalid UTF-16 data

*Background: *UTF-16 is an encoding which allows most characters to be encoded in a single 16-bit code unit. Characters outside the basic multilingual plane (i.e. code points between 0x1 and 0x10), require two code units: a high surrogate between 0xD800 and 0xDBFF, followed by a low