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

[Andreas Tille]

Hi,

I've checked version 1.1-2 but the described problem persists.  I think
Charles solution for the  issue sounds quite promissing.

Kind regards

       Andreas.

On Sun, Jan 08, 2017 at 11:45:58PM +0900, Charles Plessy wrote:
> > > 
> > > 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
> 
> _______________________________________________
> Debian-med-packaging mailing list
> Debian-med-packaging at lists.alioth.debian.org
> http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/debian-med-packaging
> 

-- 
http://fam-tille.de