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

[Kirill Müller]

On 07.01.2017 22:02, Andreas Tille wrote:
> Hi,
>
> On Sat, Jan 07, 2017 at 07:56:24PM +0100, Kirill Müller wrote:
>> After upgrading the embedded SQLite sources to 3.16.2, the query now works.
>> Please install the branch that contains the upgrade with
>>
>> #install.packages("remotes")
>> remotes::install_github("rstats-db/RSQLite at f-upgrade")
>>
>> (not recommended for production!)
> Hmmm, this does not really help.  We want to release rsqlite with the
> next Debian stable release so this is definitely for production.  The
> version that was used once this bug report was created was 3.15.2 but
> we expect to release with sqlite version 3.16.2.
>
> Do you think you can release some stable version ready for production
> soon?
Thanks. The only issue I see is that RSQLite (that comes in 
r-cran-rsqlite) is bundled with a version of the SQLite library that is 
older than the one of the command line. Users who want to use RSQLite 
with a more recent version of the SQLite library will be able to do so 
by installing the development version of RSQLite from source. This is 
currently in a branch, therefore not recommended for production, but 
will be soon merged to master -- I'm afraid this is as stable as I can 
make it in the nearest future.

We decided to bundle the SQLite library (and not to use the system 
version) to simplify installation on other platforms and to simplify 
troubleshooting.


-Kirill
>
> Kind regards
>
>         Andreas.
>