Your message dated Fri, 8 Dec 2017 10:04:49 +0100
with message-id <[email protected]>
and subject line Closing since problem does not exist in version 2.0 any more
has caused the Debian Bug report #850037,
regarding r-cran-rsqlite: Row value IN queries give syntax errors.
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
850037: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=850037
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
Hi,
I tried to reproduce the problem with r-cran-rsqlite 2.0-2 but it
seems to be solved. Since also
https://github.com/rstats-db/RSQLite/issues/198
is closed it seems sensible to close this bug.
Kind regards
Andreas.
--
http://fam-tille.de
--- End Message ---
