Bug 3964

Summary: colon (e.g. :x) parameters does not work in prepared statements
Product: SQL Reporter: Anthony Damico <ajdamico>
Component: allAssignee: SQL devs <bugs-sql>
Status: NEW ---    
Severity: enhancement CC: ajdamico
Priority: Normal    
Version: 11.21.19 (Jul2015-SP4)   
Hardware: Other   
OS: Windows   

Description Anthony Damico 2016-03-23 14:32:16 CET
User-Agent:       Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0
Build Identifier: 

from sqlite vignette

Reproducible: Always

Steps to Reproduce:
library(DBI)
library(MonetDBLite)
library(MonetDB.R)

mydb <- dbConnect(MonetDBLite())
dbWriteTable(mydb, "iris", iris)
dbGetQuery(mydb, 'SELECT * FROM iris WHERE "Sepal.Length" < :x',
  params = list(x = 4.6))
Comment 1 Hannes Muehleisen cwiconfidential 2016-05-23 11:12:52 CEST
This is true for MonetDB in general. Making it a feature request.
Comment 2 Anthony Damico 2016-05-23 11:40:59 CEST
switching to bugs-sql@monetdb.org then?