Bug 3964 - colon (e.g. :x) parameters does not work in prepared statements
Summary: colon (e.g. :x) parameters does not work in prepared statements
Status: NEW
Alias: None
Product: SQL
Classification: Unclassified
Component: all (show other bugs)
Version: 11.21.19 (Jul2015-SP4)
Hardware: Other Windows
: Normal enhancement
Assignee: SQL devs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-03-23 14:32 CET by Anthony Damico
Modified: 2016-05-23 11:40 CEST (History)
1 user (show)



Attachments

Note You need to log in before you can comment on or make changes to this bug.
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?