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-packag...@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/debian-med-packaging


Reply via email to