Bind variables and parameterising the expression in case when

Dan dan at dankeeley.co.uk
Mon Jul 8 22:09:13 CEST 2013


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20130708/b8430d7f/attachment.html>


More information about the users-list mailing list