Ticket Hash: | a8a0d2996a2b229f8aaf702da267f05d80a1b1bb | |||
Title: | Incorrect column data type reported | |||
Status: | Fixed | Type: | Code_Defect | |
Severity: | Important | Priority: | Immediate | |
Subsystem: | Unknown | Resolution: | Fixed | |
Last Modified: | 2014-03-24 15:02:18 | |||
Version Found In: | 3.8.3, 3.8.4, trunk | |||
User Comments: | ||||
dan added on 2014-03-24 09:18:48:
(text/x-fossil-wiki)
<verbatim> SQLite version 3.8.5 2014-03-22 02:19:53 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> create table t(x); sqlite> insert into t values('1'); sqlite> select typeof(x) from t; text sqlite> select typeof(x) from t where x=x+0; integer sqlite> </verbatim> Introduced by [58704ed1f4cd78bb]. drh added on 2014-03-24 12:55:14: (text/x-fossil-wiki) Another example script: <blockquote><verbatim> CREATE TABLE t(x,y); INSERT INTO t VALUES('1','1'); SELECT typeof(x), typeof(y) FROM t WHERE 1=x+0 AND y=='1'; </verbatim></blockquote> |