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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
