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

[Niko Tyni]

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
> 
> As noticed by the ci.debian.net test setup, this package
> currently fails its test suite, making it fail to build.
> 
>   https://ci.debian.net/packages/libd/libdbix-class-schema-loader-perl/unstable/amd64/
> 
>    not ok 301 - columns for views are introspected
>    
>    #   Failed test 'columns for views are introspected'
>    #   at t/10_01sqlite_common.t line 171.
>    #          got: ''
>    #     expected: 'integer'

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.

The type is exposed to the Perl side via the DBI column_info() method,
key 'TYPE_NAME'.  See DBD::SQLite::column_info() at
 https://sources.debian.net/src/libdbd-sqlite3-perl/1.50-1/lib/DBD/SQLite.pm/#L838
or so.

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.

In case it stays, I suppose DBD::SQLite could work around it centrally
by implementing TYPE_NAME in a different way.
-- 
Niko Tyni   ntyni at debian.org