SQLite

View Ticket
Login
2009-10-22
21:27 Ticket [7b61b6c6] insert mode is incorrectly converting text to numbers status still Fixed with 1 other change (artifact: b8c779e7 user: shane)
21:23
In shell, reworked .header and .echo handling. Updated shell_exec() to (really) handle multiple statements. Tickets [72adc99de9], [7b61b6c6ce], and [eb620916be]. (check-in: 790402c1 user: shane tags: trunk)
19:38 Fixed ticket [7b61b6c6]: insert mode is incorrectly converting text to numbers plus 4 other changes (artifact: 91fba9fd user: shane)
18:12
In shell, in shell_exec() logic, use type info if available when outputting in "insert" mode for other types in addition to blobs. Changed shell_exec() to use sqlite_prepare_v2(). Ticket [72adc99de9] and [7b61b6c6ce]. (check-in: ab99faca user: shane tags: trunk)
2009-10-12
21:22 New ticket [7b61b6c6] insert mode is incorrectly converting text to numbers. (artifact: 7ec8cb6e user: rogerb)

Ticket Hash: 7b61b6c6ce7a8c23bdc5c25c88b4bc60b0208e0d
Title: insert mode is incorrectly converting text to numbers
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Low
Subsystem: Shell Resolution: Fixed
Last Modified: 2009-10-22 21:27:32
Version Found In: 3.6.18
Description:
http://www.sqlite.org/cvstrac/tktview?tn=3906

The shell is deciding that a string looks like a number and then generating an insert that way. This is an unwarranted conversion but also loses information such as leading zeroes and probably also messing with strings that have digits and the letter E in them.

sqlite> CREATE TABLE test_table(city TEXT, zip TEXT);
sqlite> INSERT INTO test_table VALUES('Cambridge','02139');
sqlite> select typeof(city), typeof(zip) from test_table;
text|text
sqlite> .mode insert
sqlite> select * from test_table;
INSERT INTO table VALUES('Cambridge',02139);

shane added on 2009-10-22 19:38:33:
Check-in [ab99faca6c].


shane added on 2009-10-22 21:27:32:
Also check-in [790402c150].