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@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.