Bug#819787: libdbix-class-schema-loader-perl: FTBFS: t/10_01sqlite_common.t failure

[László Böszörményi (GCS)]

On Wed, Apr 6, 2016 at 11:53 AM, Niko Tyni <ntyni at 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-perl at lists.debian.org
>> Usertags: autopkgtest
>> X-Debbugs-Cc: sqlite3 at 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