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

[Kirill Müller]

Thanks. I'm not sure why this was removed, I asked the person who 
changed this. From a maintainer's perspective, using a bundled version 
of SQLite certainly simplifies the replication of problems. I'm in favor 
of keeping things as they are, but I see the benefit of giving the user 
the same SQLite versions for both R and the command line.

Using a system version of SQLite is currently difficult because I'm 
using a patched version of sqlite.h, I might be able to get rid of this 
(https://github.com/rstats-db/RSQLite/issues/198).


-Kirill


On 11.01.2017 09:44, Andreas Tille wrote:
> 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
>>