Please send: (1) The version number of SQLite that you are using. The output of "SELECT sqlite_source_id();"
(2) Did you compile SQLite yourself? Have you made any modifications to the code? What platform are you running on? (3) Please send the complete schema of the database - the output of ".schema" On 6/22/18, Nick <haveagoodtime2...@gmail.com> wrote: > My query is > "SELECT x,y FROM t1 WHERE z=? COLLATE NOCASE". > > sqlite3Select-> sqlite3WhereBegin-> sqlite3WhereCodeOneLoopStart-> > codeAllEqualityTerms-> sqlite3IndexAffinityStr > > And I found "Cannot access memory at address" when running > pTab->aCol[x].affinity //in sqlite3IndexAffinityStr() > > x = 29043 while in fact it has only 8394 records. > > I am wondering if there is something wrong with my DISK file? Or is it > possible that the aCol[x] is in MEMORY? > Is there any way to know what happened? > > Thanks. > > > > -- > Sent from: http://sqlite.1065341.n5.nabble.com/ > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users