On 07/04/2012 03:30 AM, Jay A. Kreibich wrote:
On Tue, Jul 03, 2012 at 04:26:42PM -0400, Richard Hipp scratched on the wall:
Actually, you can bind on a DDL statement, but bindings are only valid for
the lifetime of the statement itself, not for the whole lifetime of the
object created by the CREATE statement.
Is that a side-effect of the fact that CREATE statements are copied
into the sqlite_master table as literals, and not re-written? (Is
that even true?)
Pretty much. SQLite messes around with the start of CREATE TABLE
statements to remove the "TEMP" keyword or fully qualified database
name if one is present, but otherwise just copies the users input
into the sqlite_master table. i.e. if you do:
CREATE TABLE main.x1(a, b);
SQLite rewrites "CREATE TABLE main." as "CREATE TABLE ". The
rest of the CREATE TABLE is stored in sqlite_master as is.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
