|
2009-10-22
| ||
| 21:27 | • Ticket [7b61b6c6ce] insert mode is incorrectly converting text to numbers status still Fixed with 1 other change (artifact: b8c779e7ff 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: 790402c150 user: shane tags: trunk) | |
| 19:38 | • Fixed ticket [7b61b6c6ce]: insert mode is incorrectly converting text to numbers plus 4 other changes (artifact: 91fba9fd6a 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: ab99faca6c user: shane tags: trunk) | |
|
2009-10-12
| ||
| 21:22 | • New ticket [7b61b6c6ce] insert mode is incorrectly converting text to numbers. (artifact: 7ec8cb6ef8 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 15.49 years |
Created: |
2009-10-12 21:22:28 15.52 years |
| 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: shane added on 2009-10-22 21:27:32: | ||||