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