For what it’s worth, the instructions generated in 3.19.2 (which don't crash) are slightly different: the OpenRead and Rewind instructions are at the top, not down at location 15 —
0 Init 0 24 0 00 Start at 24 1 OpenRead 0 4 0 5 00 root=4 iDb=0; kv_default 2 Rewind 0 23 0 00 3 Integer 0 2 0 00 r[2]=0; Init EXISTS result 4 Integer 1 3 0 00 r[3]=1; LIMIT counter 5 VOpen 1 0 0 vtab:10128F730 00 6 Column 0 4 6 00 r[6]=kv_default.body 7 String8 0 7 0 likes 00 r[7]='likes' 8 Integer 2 4 0 00 r[4]=2 9 Integer 2 5 0 00 r[5]=2 10 VFilter 1 16 4 00 iplan=r[4] zplan='' 11 VColumn 1 1 8 00 r[8]=vcolumn(1); fl_each.value 12 Ne 9 15 8 (BINARY) 51 if r[8]!=r[9] goto 15 13 Integer 1 2 0 00 r[2]=1 14 DecrJumpZero 3 16 0 00 if (--r[3])==0 goto 16 15 VNext 1 11 0 00 16 IfNot 2 22 1 00 17 Column 0 1 11 00 r[11]=kv_default.sequence 18 Column 0 0 12 00 r[12]=kv_default.key 19 Column 0 3 13 00 r[13]=kv_default.version 20 Column 0 2 14 0 00 r[14]=kv_default.flags 21 ResultRow 11 4 0 00 output=r[11..14] 22 Next 0 3 0 01 23 Halt 0 0 0 00 24 Transaction 0 0 4 0 01 usesStmtJournal=0 25 String8 0 9 0 climbing 00 r[9]='climbing' 26 Goto 0 1 0 00 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users