Hello, On 2016-04-04 22:14, Mike Bayer wrote: > if it is by design that views no longer carry typing information, this > is a major behavioral change and no mention of it occurs in the release > notes for 3.12.0, so at the very least this change should be documented > if expected.
This is not true. Column's affinity is still propagated to a view, though it is not displayed by ``PRAGMA table_info''. Try: sqlite> INSERT INTO users VALUES (2); sqlite> SELECT * FROM users_v WHERE user_id > '1'; 2 If an affinity was not carried then the above ``SELECT'' would return an empty set, while it returns ``2'' (as in SQLite 3.11.x). IMHO, this described by you behavior can be considered as a bug in ``PRAGMA table_info'', which takes column's affinity from ``CREATE TABLE'' command only as for now. -- best regards Cezary H. Noweta
