D 2018-05-15T16:59:11.764
J foundin 3.23.1
J icomment select\s*\sfrom\s<table_name>\slimit\s100\soffset\s200;\s\r\n\r\nExpected\sresult\sis\sit\sshould\sreturn\srows\sfrom\s201\sto\s300.\sBut\sin\sandroid\sit\sis\sreturning\srows\sfrom\s2\sto\s101.\s\r\n\r\nBut\sthe\sabove\squery\sreturn\sexpected\sresult\sin\sMac\sos.\r\n\r\nDo\swe\sneed\sto\senable\sany\sflags\swhile\scompiling\ssqlite3\sfor\sandroid\s?\sBelow\sare\sthe\sflags\si\sused\swhile\scompiling\ssqlite3\sfor\sandroid.\r\n\r\n#\sIf\susing\sSEE,\suncomment\sthe\sfollowing:\r\n#\sLOCAL_CFLAGS\s+=\s-DSQLITE_HAS_CODEC\r\n\r\n#Define\sHAVE_USLEEP,\sotherwise\sALL\ssleep()\scalls\stake\sat\sleast\s1000ms\r\nLOCAL_CFLAGS\s+=\s-DHAVE_USLEEP=1\r\n\r\n#\sEnable\sSQLite\sextensions.\r\nLOCAL_CFLAGS\s+=\s-DSQLITE_ENABLE_FTS5\s\r\nLOCAL_CFLAGS\s+=\s-DSQLITE_ENABLE_RTREE\r\nLOCAL_CFLAGS\s+=\s-DSQLITE_ENABLE_JSON1\r\nLOCAL_CFLAGS\s+=\s-DSQLITE_ENABLE_FTS3\r\n\r\n#\sThis\sis\simportant\s-\sit\scauses\sSQLite\sto\suse\smemory\sfor\stemp\sfiles.\sSince\s\r\n#\sAndroid\shas\sno\sglobally\swritable\stemp\sdirectory,\sif\sthis\sis\snot\sdefined\sthe\r\n#\sapplication\sthrows\san\sexception\swhen\sit\stries\sto\screate\sa\stemp\sfile.\r\n#\r\nLOCAL_CFLAGS\s+=\s-DSQLITE_TEMP_STORE=3\r\n\r\nLOCAL_CFLAGS\s+=\s-U__APPLE__\r\nLOCAL_CFLAGS\s+=\s-DHAVE_STRCHRNUL=0\r\nLOCAL_CFLAGS\s+=\s-DSQLITE_USE_URI=1
J login anonymous
J mimetype text/x-fossil-plain
J private_contact 28ca2da466c13be59faa829b622a4c825739e4d6
J severity Critical
J status Open
J title LIMIT\swith\sOFFSET\sin\sselect\sstatement\sis\snot\sworking\sproperly\sin\sandroid\splatform
J type Code_Defect
K aed11eb1c8168ce6e0a18208c860609b9866e4ff
U anonymous
Z 846a3fedd6e6fb04927720d7ac49fe5c