[Debian-med-packaging] Bug#850037: r-cran-rsqlite: Row value IN queries give syntax errors.

[Charles Plessy]

Le Tue, Jan 03, 2017 at 09:36:50PM +0100, Andreas Tille a écrit :
> On Tue, Jan 03, 2017 at 12:12:48PM +0000, Andy Wood wrote:
> > Package: r-cran-rsqlite
> > Version: 1.1-1-1
> > Severity: important
> > 
> > Dear Maintainer,
> > 
> > After the upgrade from 1.0.0-2 to 1.1-1-1, row value subqueries using IN no longer
> > appear to work.  Here is an example (taken from https://www.sqlite.org/rowvalue.html)

Hi Andreas and Kirill,

I was puzzled why version 1.0.0-2 worked, while it was built againt an
even older version of sqlite3, and figured out that until commit 8cdf941
in RSQLite's repository on GitHub, there was a configure script that
accepted the parameter --with-sqlite-dir, which we pass when we build
the r-cran-rsqlite package on Debian to dynamically link the package
against the system's sqlite library.

https://github.com/rstats-db/RSQLite/commit/8cdf941f4e0860be0c0dbafde0a64d1c5e75af72

Would it be possible to have this facility back ?

Have a nice day,

Charles Plessy

PS: Andreas, to make it further complicated, the conversion from CDBS to
dh_r caused the parameter to not be passed...  To correct this, one
needs do delete the dh override and instead add the following line:
export RExtraInstallFlags=--configure-args=--with-sqlite-dir=/usr

-- 
Charles Plessy
Debian Med packaging team,
http://www.debian.org/devel/debian-med
Tsurumi, Kanagawa, Japan