SQLite

Check-in [33cf83591e]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Rework the logic that generates a schema for tables created using "CREATE TABLE ... AS SELECT ...". Instead of trying to copy the raw datatype string from the right-hand side, just make the type one of TEXT, INT, REAL, NUM, or nothing. This is much simpler than trying to parse and quote datatype strings. Other minor implifications to build.c are bundled with this change. (CVS 6626)
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 33cf83591e6e13875ef6ada5b8ac8ab07619d8bc
User & Date: drh 2009-05-11 20:53:29.000
References
2019-08-05
13:06 Fixed ticket [d52a29a9e6]: Unexpected affinity conversion in view plus 8 other changes (artifact: ac513e2ebb user: drh)
Context
2009-05-11
23:38
If a virtual table constructor returns SQLITE_NOMEM, set the mallocFailed flag in the corresponding database connection to insure that the error is propagated back to the top layer. (CVS 6627) (check-in: 5635666f20 user: drh tags: trunk)
20:53
Rework the logic that generates a schema for tables created using "CREATE TABLE ... AS SELECT ...". Instead of trying to copy the raw datatype string from the right-hand side, just make the type one of TEXT, INT, REAL, NUM, or nothing. This is much simpler than trying to parse and quote datatype strings. Other minor implifications to build.c are bundled with this change. (CVS 6626) (check-in: 33cf83591e user: drh tags: trunk)
18:22
Enhance the parser to allow nested parentheses in the module argument of a CREATE VIRTUAL TABLE statement. (CVS 6625) (check-in: 93772bd7f5 user: drh tags: trunk)
Changes
Unified Diff Side-by-Side Diff Patch
Changes to src/build.c.
Changes to src/callback.c.
Changes to src/expr.c.
Changes to src/main.c.
Changes to src/prepare.c.
Changes to src/select.c.
Changes to src/sqliteInt.h.
Changes to test/table.test.