On 12/20/2012 5:20 PM, Simon Slavin wrote:
I've understood that the optimizer can be usefully used on prepared statements before the parameters are known. An implication from this is that table names cannot be parameterized.
Table names cannot be parameterized for the simple reason that, syntactically, they are not literals. The syntax only allows parameter placeholders where a literal (like 123 or 'xyz') may legitimately appear. That is not at all in contention.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
