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@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
-- Sjoerd Mullender