Bug#850037: r-cran-rsqlite: Row value IN queries give syntax errors.

2017-01-11 Thread 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

Bug#850037: r-cran-rsqlite: Row value IN queries give syntax errors.

2017-01-07 Thread 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"

Bug#850037: r-cran-rsqlite: Row value IN queries give syntax errors.

2017-01-07 Thread Kirill Müller
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!) -Kirill On 03.01.2017 21:36, Andreas

Bug#850037: r-cran-rsqlite: Row value IN queries give syntax errors.

2017-01-07 Thread Kirill Müller
Thanks. I'm getting the following error when running the query from the sqlite3 command line (package version 3.14.1-1build1 on Ubuntu 16.10): > sqlite3 test.db SQLite version 3.14.1 2016-08-11 18:53:32 Enter ".help" for usage hints. sqlite> select ...> (1,2,3) in (select x,y,z from t2),