[Rd] DBI + ROracle problem with parser ?? (PR#9424)

From: <christian.hoffmann_at_wsl.ch>
Date: Wed 20 Dec 2006 - 13:40:24 GMT


Full_Name: Christian Hoffmann
Version: 2.4.0
OS: Win 2000
Submission from: (NULL) (193.134.202.252)

Database queries using the combination DBI + ROracle are handicapped by

quirks in the pipeline between the textual representation of the query

and the database engine Oracle. Comments and linefeed at start are interfering:

dbGetQuery(conn, query):

works:

dbGetQuery(conn, "select * from dual")

dbGetQuery(conn, "select * from dual /* comment */")

dbGetQuery(conn, "select /* comment */ * from dual")

doesn't:

dbGetQuery(conn, "\nselect * from dual")

dbGetQuery(conn, "select\n * from dual")

dbGetQuery(conn, "/* comment */ select * from dual")



R-devel@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-devel Received on Thu Dec 21 12:49:39 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Fri 22 Dec 2006 - 07:31:03 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-devel. Please read the posting guide before posting to the list.