According to sqlite 3.7.14 code the equivalences are SorterInsert == IdxInsert,
SorterSort == Sort and SorterNext == Next
case OP_SorterInsert: /* in2 */
#ifdef SQLITE_OMIT_MERGE_SORT
pOp->opcode = OP_IdxInsert;
#endif
case OP_IdxInsert: { /* in2 */
case OP_SorterNext: /* jump */
#ifdef SQLITE_OMIT_MERGE_SORT
pOp->opcode = OP_Next;
#endif
case OP_Prev: /* jump */
case OP_Next: { /* jump */
case OP_SorterSort: /* jump */
#ifdef SQLITE_OMIT_MERGE_SORT
pOp->opcode = OP_Sort;
#endif
case OP_Sort: { /* jump */
-----Ursprüngliche Nachricht-----
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von David Raymond
Gesendet: Freitag, 23. Dezember 2016 16:33
An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
Betreff: [sqlite] Opcodes missing from documentation
I'm looking at some explain output and am looking for info at
http://www.sqlite.org/opcode.html but am not seeing a couple of the opcodes
listed there. Specifically I'm looking for "SorterInsert", "SorterSort" and
"SorterNext". I'm assuming they're gonna be like the similarly named entries,
but they're not there explicitly in the list. So I'm wondering if whatever
takes care of the "This table was generated automatically by scanning the
source code from the file vdbe.c." is missing them.
I'm using a 3.15.2 CLI with SQLITE_ENABLE_EXPLAIN_COMMENTS made from the
amalgamation. The version matches what's shown on the opcode page at the moment.
addr opcode p1 p2 p3 p4 p5 comment
---- ------------- ---- ---- ---- ------------- -- ------------- ...
1 SorterOpen 1 3 0 k(1,B) 00
...
8 SorterInsert 1 3 0 00
...
12 SorterSort 1 17 0 00
13 SorterData 1 5 2 00 r[5]=data
14 Column 2 1 2 00 r[2]=name
15 ResultRow 2 1 0 00 output=r[2]
16 SorterNext 1 13 0 00
...
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___________________________________________
Gunter Hick
Software Engineer
Scientific Games International GmbH
FN 157284 a, HG Wien
Klitschgasse 2-4, A-1130 Vienna, Austria
Tel: +43 1 80100 0
E-Mail: h...@scigames.at
This communication (including any attachments) is intended for the use of the
intended recipient(s) only and may contain information that is confidential,
privileged or legally protected. Any unauthorized use or dissemination of this
communication is strictly prohibited. If you have received this communication
in error, please immediately notify the sender by return e-mail message and
delete all copies of the original communication. Thank you for your cooperation.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
