Hello, On 2016-04-06 16:33, Richard Hipp wrote: > On 4/4/16, Mike Bayer <classic at zzzcomputing.com> wrote: >> The "type" column in PRAGMA table_info() is now a blank string when the >> target object is a view in 3.12.0. In 3.11.0 and prior versions, the >> typing information is returned,
> I think the problem is fixed by this checkin: > https://www.sqlite.org/src/info/fb555c3c2af7f5e6 Perfunctory test showed that it works fine with plain 3.12.0 ([e9bb4cf4] Version 3.12.0 (user: drh, tags: trunk, release, version-3.12.0)) --- does not require intermediate check--ins. It goes even farther then 3.11.x because it keeps column's declared type when view's column name has changed (CREATE VIEW v(newname) ...). Thank you. -- best regards Cezary H. Noweta
