On Wed, Apr 06, 2016 at 01:07:17PM +0200, László Böszörményi wrote: > On Wed, Apr 6, 2016 at 11:53 AM, Niko Tyni <nt...@debian.org> wrote:
> > This is due to a change in 'PRAGMA table_info' behaviour in 3.12.0. The > > "type" column in PRAGMA table_info() is now a blank string when the > > target object is a view. > It seems it'll stay. Please read the opinion of the main SQLite3 > developer[1]: > "This could easily be considered a bug fix rather than a regression." > There are examples in his mail which demonstrate why a type of view is > unambiguous and should not be depend on. Hence they chose to return an > empty string for these queries. OTOH there's this trunk commit from yesterday: http://www.sqlite.org/src/info/fb555c3c2af7f5e6 which looks like it's trying to restore the older behaviour? -- Niko