On 09.03.2012 02:22, Nico Williams wrote:
On Thu, Mar 8, 2012 at 5:57 PM, Alek Paunov<a...@declera.com>  wrote:
Let suppose hypothetical function:

asm(sql): returns VDBE assembler code for the sql parameter (like 'explain'
but with full instruction attributes)

I am curious, Is it evaluable (to proper VDBE code):

asm(update with complex join)
        as Transformation(
                asm(select with the same join),
                asm(same update without join)
        )

?

What the "internals" gurus think? :-)

It most definitely is.  (I'm not a SQLite3 internals guru, but I've
played enough with the internals to believe that I can make that
assertion with high confidence.  I could be wrong however.  Caveat
emptor.)

So maybe it's worth to give it a try ... Is there someone else, which is interested to work on VDBE dump/load to assembler representation? Once these base tools are available, maybe other people would reuse bytecode instrumentation for other purposes also ;-)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to