Thank you for your answer but it seems that your solution is not working in my case. As you can see in my example also :abs is workin fine when using "=" and it is not working with LIKE operator. It seems like parameters passed to LIKE operator are treated in a bit different way.
I am using DBeaver to test my queries and when I am using this notation :<number> (:1) or wirh parameter name (:abc) query is transleted to use "?" sign for bind parameters. Regards, Bartek 2016-11-18 17:09 GMT+01:00 James Taylor <[email protected]>: > Use :<number> instead, like this :1 > > Thanks, > James > > On Fri, Nov 18, 2016 at 5:28 AM Bartłomiej Niemienionek < > [email protected]> wrote: > >> Hi, >> >> >> >> I am trying to use Phoenix and I am facing some problems with LIKE >> operator when used in the prepared statement with bind parameters. >> >> I don’t know if this is some kind of known issue. >> >> >> >> *CREATE* *TABLE* TEST_TABLE ( >> >> NAME *VARCHAR*(100) *NOT* *NULL* *PRIMARY* *KEY*, >> >> VAL *VARCHAR*(100) >> >> ); >> >> >> >> These are working fine: >> >> *SELECT* 1 *FROM* TEST_TABLE *WHERE* NAME = *:abc*; >> >> *SELECT* 1 *FROM* TEST_TABLE *WHERE* NAME = 'abc'; >> >> *SELECT* 1 *FROM* TEST_TABLE *WHERE* NAME *LIKE* 'abc'; >> >> >> >> Here I get error: >> >> *SELECT* 1 *FROM* TEST_TABLE *WHERE* NAME *LIKE* *:abc*; >> >> >> >> SQL Error [00000]: Error -1 (00000) : while preparing SQL: SELECT 1 FROM >> TEST_TABLE WHERE NAME LIKE ? >> >> org.apache.calcite.avatica.AvaticaSqlException: Error -1 (00000) : >> while preparing SQL: SELECT 1 FROM TEST_TABLE WHERE NAME LIKE ? >> >> >> >> I am using phoenix driver in 4.9.0 version. >> >> >> >> Regards, >> >> bjn >> >
