My thanks to everyone who responded to my read blocking transaction isolation question.
Further to my other question/proposal with no responses, what would be the impact on sqlite3_prepare to introduce a new branch called table-naming-expression into the syntax graph at: https://www.sqlite.org/syntax/table-or-subquery.html ? [I hope everybody had a chance to see my original narrower proposal called table-naming-function-name. I didn't see my message posted to the board that time but it was definitely sent.] The table-naming-expression, if normal expressions are allowed, would obviously require sqlite3_prepare to consult the database in situations where the name string expression depended on a SQL statement being evaluated. Is this the main problem with allowing dynamically named tables SQLite? Is there a design goal which states that sqlite3_prepare shall never return a lock related error message such as SQLITE_BUSY? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
