Thanks for the report. This problem is fixed on trunk. To be clear, this is an issue in the "sqlite3" shell command, not in the SQLite core.
Also, it is an issue in the deprecated and undocumented ".explain on" command of the shell. Years ago, it used to be necessary to run ".explain on" prior to running an EXPLAIN query in order to set up the output formatting correctly so that the EXPLAIN output was readable. But that setup is now done automatically. There is no need to run ".explain on" any more and that dot-command is now deprecated and undocumented. It exists only to prevent legacy scripts from blowing up. Perhaps I should make the ".explain" command into a no-op? -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users