On Fri, Dec 14, 2007 at 04:20:15PM +0000, [EMAIL PROTECTED] wrote: > The EXPLAIN option generates human-readable assembly. We > use EXPLAIN extensively when debugging and enhancing.
Yes, but there's no assembler for EXPLAIN output, is there? Also, the only way to deal with EXPLAIN is to step through its results -- there's no way to directly insert its output rows into a temporary table and then use a select using group_concat() to generate a single string consisting of the VDBE assembly. It is, however, possible to use .mode insert and explain to generate INSERT statements that can then be used to insert the VDBE program into a table, and then one can do more interesting things (I suppose one could even write an assembler in SQL). > I should point out that while we work very hard to keep the > file format for SQLite stable, we make no such effort with > the VDBE. The opcodes can and do change significantly between > point releases. Hence the serializations generated by one > version of SQLite can only be interpreted by that exact same > version of SQLite. Right. Nico -- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
