phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Phoenix LIKE operator with bind parameters question/error
Date Mon, 28 Nov 2016 21:16:18 GMT
Sounds like there's a bug here. Please file a JIRA with the steps to repro
it.
Thanks,
James

On Mon, Nov 28, 2016 at 12:32 AM jasper.vanams@baesystems.com <
jasper.vanams@baesystems.com> wrote:

> Hi all,
>
>
>
> I am experiencing the same problem as Bartek.
>
> Using the numbers for binding the parameters does not solve it.
>
> Is anyone else experiencing this?
>
>
>
> (I am using 4.9.0)
>
>
>
> Jasper.
>
>
>
> *From:* Bartłomiej Niemienionek [mailto:b.niemienionek@gmail.com]
> *Sent:* 23 November 2016 21:12
> *To:* user@phoenix.apache.org
> *Subject:* Re: Phoenix LIKE operator with bind parameters question/error
>
>
>
> *ATTENTION.* This message originates from outside BAE Systems.
>
> Hi
>
> Aby other thoughts ideas to get Like operator working with bind parameters
> ?
>
> Regards
> Bartek
>
>
>
> 18.11.2016 22:20 "Bartłomiej Niemienionek" <b.niemienionek@gmail.com>
> napisał(a):
>
> 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 <jamestaylor@apache.org>:
>
> Use :<number> instead, like this :1
>
> Thanks,
> James
>
>
>
> On Fri, Nov 18, 2016 at 5:28 AM Bartłomiej Niemienionek <
> b.niemienionek@gmail.com> 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
>
>
> Please consider the environment before printing this email. This message
> should be regarded as confidential. If you have received this email in
> error please notify the sender and destroy it immediately. Statements of
> intent shall only become binding when confirmed in hard copy by an
> authorised signatory. The contents of this email may relate to dealings
> with other companies under the control of BAE Systems Applied Intelligence
> Limited, details of which can be found at
> http://www.baesystems.com/Businesses/index.htm.
>

Mime
View raw message