Hi All,
OFFSET clause is not working as expected in android platform.
[ ISSUE ] : eg. select * from test limit 2 offset 5;
[ Expected Result ] : This query should return two rows starting from index
6.
[ Actual Result ] : It always returns rows starting from index 2, even
though it had enou
teger|0||1
1|name|text|0||0
sqlite>
Thanks,
Sathish
On Wed, May 16, 2018 at 3:43 PM, Richard Hipp wrote:
> On 5/16/18, Sathish Kumar wrote:
> > Hi All,
> > OFFSET clause is not working as expected in android platform.
> >
> > [ ISSUE ] : eg. select * from
I just skipped those statements in mail, but i inserted 7 rows.
On Wed 16 May, 2018, 4:06 PM Richard Hipp, wrote:
> On 5/16/18, Sathish Kumar wrote:
> > Hi,
> > Please find the below example.
> >
> > sqlite> create table test (id integer primary ke
0 000
14Transaction0 0 440 01
15Goto 0 1 000
sqlite> .schema test
CREATE TABLE test (id integer primary key autoincrement, name text);
sqlite> PRAGMA table_info(test);
0|id|integer|0||1
1|name|text|0||0
Th
Samsung S9 device with Android 8.0
On Wed, May 16, 2018 at 4:50 PM, Sathish Kumar
wrote:
> Hi,
> Sorry, Please find the full sequence below, it is taken from S9 device
> running with Android 8.0.
>
> sqlite> create table test (id integer primary key autoincrement, name
&
_RTREE
SYSTEM_MALLOC
TEMP_STORE=3
THREADSAFE=1
sqlite>
On Wed, May 16, 2018 at 5:29 PM, Richard Hipp wrote:
> On 5/16/18, Sathish Kumar wrote:
> > Samsung S9 device with Android 8.0
>
> What output do you see from the following commands:
>
> SELECT sqlite_source_id();
> P
Hi Richard,
Is there any issue with this compile option ?
Thanks,
Sathish
On Wed 16 May, 2018, 5:30 PM Sathish Kumar, wrote:
> sqlite> SELECT sqlite_source_id();
>
> 2017-06-08 14:26:16
> 0ee482a1e0eae22e08edc8978c9733a96603d4509645f348ebf55b579e89636b
>
,
Sathish
On Thu, May 17, 2018 at 8:07 AM, Sathish Kumar
wrote:
> Hi Richard,
> Is there any issue with this compile option ?
>
>
> Thanks,
> Sathish
>
>
> On Wed 16 May, 2018, 5:30 PM Sathish Kumar,
> wrote:
>
>> sqlite> SELECT sql
Ok, I will try.
On Fri 18 May, 2018, 7:15 PM Richard Hipp, wrote:
> On 5/18/18, Sathish Kumar wrote:
> > Hi Richard,
> > Further update on this issue.
> >
> > I am observing this issue only with the library build using ndk-build
> > via terminal and the
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
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 file. Will it creat
Hi Richard,
Today, i verified with android NDK 17 and It is working fine without
disabling compiler optimization.
Thanks,
Sathish
On Mon, May 21, 2018 at 9:41 PM, Sathish Kumar
wrote:
> Thanks, I will do that.
>
> Thanks,
> Sathish
>
>
> On Mon 21 May, 2018, 9:34 PM
12 matches
Mail list logo
