Bind variables and parameterising the expression in case when

Sjoerd Mullender sjoerd at acm.org
Wed Jul 10 09:51:47 CEST 2013


Please submit this as a bug report at bugs.monetdb.org.

On 2013-07-08 22:09, Dan wrote:
> Hi,
> 
> I seem to have come across a strange restriction in using bind 
> variables in MonetDB. If i use bind variables in the normal way by 
> saying where field=${var} then it works. But not in this case:
> 
> Here is a sample:
> 
> |select case when ${Brand} = 'All' |
> 
> And here is the error:
> 
> |EXEC: wrong type for argument 1 of prepared statement: char, 
> expected char |
> 
> This is using the latest version of the jdbc driver (2.9) via 
> Pentaho.
> 
> Not quite sure how to set up a test case of this via a normal SQL 
> client though.
> 
> Thanks for any suggestions!
> 
> Dan
> 
> 
> 
> _______________________________________________ users-list mailing 
> list users-list at monetdb.org 
> http://mail.monetdb.org/mailman/listinfo/users-list
> 


-- 
Sjoerd Mullender



More information about the users-list mailing list