On Wed, Apr 6, 2016 at 11:53 AM, Niko Tyni <nt...@debian.org> wrote: > On Sat, Apr 02, 2016 at 12:10:20PM +0300, Niko Tyni wrote: >> Package: libdbix-class-schema-loader-perl >> Version: 0.07045-1 >> Severity: serious >> User: debian-p...@lists.debian.org >> Usertags: autopkgtest >> X-Debbugs-Cc: sqli...@packages.debian.org [...] >> not ok 301 - columns for views are introspected [...] > 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. [...] > There's a thread about this at > http://thread.gmane.org/gmane.comp.db.sqlite.general/100856 > but it doesn't seem quite clear yet if this is an accidental regression > or something that will stay. 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. Of course, there's at least one proposed solution[2] for these cases.
Laszlo/GCS [1] http://article.gmane.org/gmane.comp.db.sqlite.general/100860 [2] http://article.gmane.org/gmane.comp.db.sqlite.general/100898
