SQLite

Check-in [0e45e8f157]
Login

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

Overview
Comment:Add a test case to verify that CREATE TABLE AS does not store INT values in TEXT columns. Ticket [f2ad7de056ab1dc92].
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | create-table-as-type-fix
Files: files | file ages | folders
SHA1: 0e45e8f1574ef19a43dbd118440ddbc5cec80ce7
User & Date: drh 2015-05-20 17:25:44.766
Context
2015-05-20
17:36
Fix the initialization logic in CREATE TABLE AS so that the correct affinities are applied to all values being inserted into the new table, even if the RHS is a compound SELECT. Fix for ticket [f2ad7de056ab1dc9200]. (check-in: 6a0cf3ce9e user: drh tags: trunk)
17:25
Add a test case to verify that CREATE TABLE AS does not store INT values in TEXT columns. Ticket [f2ad7de056ab1dc92]. (Closed-Leaf check-in: 0e45e8f157 user: drh tags: create-table-as-type-fix)
17:18
Simplification of the initialization code for CREATE TABLE AS. (check-in: 937f659e89 user: drh tags: create-table-as-type-fix)
Changes
Unified Diff Side-by-Side Diff Patch
Changes to test/misc1.test.