SQLite Android Bindings
Ticket Change Details
Not logged in
Overview

Artifact ID: 52ac211279956179610c64f1719106fb83a1898d
Ticket: aed11eb1c8168ce6e0a18208c860609b9866e4ff
LIMIT with OFFSET in select statement is not working properly in android platform
User & Date: anonymous 2018-05-15 16:59:11
Changes

  1. Change foundin to "3.23.1"
  2. Change icomment to:
    select * from <table_name> limit 100 offset 200; 
    
    Expected result is it should return rows from 201 to 300. But in android it is returning rows from 2 to 101. 
    
    But the above query return expected result in Mac os.
    
    Do we need to enable any flags while compiling sqlite3 for android ? Below are the flags i used while compiling sqlite3 for android.
    
    # If using SEE, uncomment the following:
    # LOCAL_CFLAGS += -DSQLITE_HAS_CODEC
    
    #Define HAVE_USLEEP, otherwise ALL sleep() calls take at least 1000ms
    LOCAL_CFLAGS += -DHAVE_USLEEP=1
    
    # Enable SQLite extensions.
    LOCAL_CFLAGS += -DSQLITE_ENABLE_FTS5 
    LOCAL_CFLAGS += -DSQLITE_ENABLE_RTREE
    LOCAL_CFLAGS += -DSQLITE_ENABLE_JSON1
    LOCAL_CFLAGS += -DSQLITE_ENABLE_FTS3
    
    # This is important - it causes SQLite to use memory for temp files. Since 
    # Android has no globally writable temp directory, if this is not defined the
    # application throws an exception when it tries to create a temp file.
    #
    LOCAL_CFLAGS += -DSQLITE_TEMP_STORE=3
    
    LOCAL_CFLAGS += -U__APPLE__
    LOCAL_CFLAGS += -DHAVE_STRCHRNUL=0
    LOCAL_CFLAGS += -DSQLITE_USE_URI=1
    
  3. Change login to "anonymous"
  4. Change mimetype to "text/x-fossil-plain"
  5. Change private_contact to "28ca2da466c13be59faa829b622a4c825739e4d6"
  6. Change severity to "Critical"
  7. Change status to "Open"
  8. Change title to:
    LIMIT with OFFSET in select statement is not working properly in android platform
    
  9. Change type to "Code_Defect"