Gunter posted this explain VDBE code: asql> explain update mytable set myfield=2 where myconst=7; addr opcode p1 p2 p3 p4 p5 comment ---- ------------- ---- ---- ---- ------------- -- ------------- 0 Trace 0 0 0 00 NULL 1 Goto 0 73 0 00 NULL ... 72 Halt 0 0 0 00 NULL 73 VBegin 0 0 0 vtab:1F77F958:2B834C233990 00 NULL 74 Goto 0 2 0 00 NULL
And the back and forth between the start and end looks intriguing. Why not just? asql> explain update mytable set myfield=2 where myconst=7; addr opcode p1 p2 p3 p4 p5 comment ---- ------------- ---- ---- ---- ------------- -- ------------- 0 Trace 0 0 0 00 NULL 1 VBegin 0 0 0 vtab:1F77F958:2B834C233990 00 NULL ... 72 Halt 0 0 0 00 NULL Is the Halt even required then? Just curious. --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
