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

[Andy Wood]

Package: r-cran-rsqlite
Version: 1.1-1-1
Severity: important

Dear Maintainer,

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)

1. create a database and populate. The file create_db.sql contains:

CREATE TABLE t2(x,y,z);
INSERT INTO t2(x,y,z) VALUES(1,2,3),(2,3,4),(1,NULL,5);

# sqlite3 test.db < create_db.sql

2. query the database with sqlite3. The file query_db.sql contains:

select
 (1,2,3) in (select x,y,z from t2),
 (7,8,9) in (select x,y,z from t2),
 (1,3,5) in (select x,y,z from t2);

# sqlite3 test.db < query_db.sql

1|0|

3. query the database with RSQLite. The file query_db.r contains:

library(DBI)
library(RSQLite)
dbd <- dbDriver("SQLite")
dbf <- "test.db"
con <- dbConnect(dbd, dbf)
qry <- dbSendQuery(con, statement = paste(
       "select",
       " (1,2,3) in (select x,y,z from t2),",
       " (7,8,9) in (select x,y,z from t2),",                   
       " (1,3,5) in (select x,y,z from t2)"))
dbFetch(qry, n=-1)
dbClearResult(qry)
dbDisconnect(con)
quit()
 
# R --quiet --no-save < query_db.r

> library(DBI)
> library(RSQLite)
> #
> dbd <- dbDriver("SQLite")
> dbf <- "test.db"
> con <- dbConnect(dbd, dbf)
> qry <- dbSendQuery(con, statement = paste(
+        "select",
+        " (1,2,3) in (select x,y,z from t2),",
+        " (7,8,9) in (select x,y,z from t2),",                   
+        " (1,3,5) in (select x,y,z from t2)"))
Error in rsqlite_send_query(conn at ptr, statement) : near ",": syntax error
Calls: dbSendQuery ... initialize -> initialize -> rsqlite_send_query -> .Call
Execution halted


-- System Information:
Debian Release: stretch/sid
  APT prefers testing
  APT policy: (900, 'testing'), (300, 'unstable')
Architecture: amd64 (x86_64)

Kernel: Linux 4.8.0-2-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages r-cran-rsqlite depends on:
ii  libc6                  2.24-8
ii  libgcc1                1:6.2.1-5
ii  libstdc++6             6.2.1-5
ii  r-base-core [r-api-3]  3.3.2-1
ii  r-cran-dbi             0.5-1-1
ii  r-cran-memoise         1.0.0-1
ii  r-cran-rcpp            0.12.8-1

r-cran-rsqlite recommends no packages.

Versions of packages r-cran-rsqlite suggests:
pn  r-cran-dbitest   <none>
ii  r-cran-knitr     1.15.1-1
ii  r-cran-testthat  1.0.2-2

-- no debconf information