phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Josh Elser (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate
Date Fri, 06 Apr 2018 17:30:00 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-2314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16428642#comment-16428642
] 

Josh Elser commented on PHOENIX-2314:
-------------------------------------

Thanks, [~jaspervanams]. It appears that this only made it to the master branch and not any
of the other 4.x branches. So, at the time, that means this is only contained in the HBase
1.3 branch, not the 0.98, 1.1, or 1.2 branches.

[~kliew], any chance you could revisit this and make sure it hits all of the 4.x branches?

> Cannot prepare parameterized statement with a 'like' predicate
> --------------------------------------------------------------
>
>                 Key: PHOENIX-2314
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2314
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.5.2
>         Environment: Using Fiddler or cURL to communicate with a Phoenix 4.5.2 queryserver
using Avatica wire protocol
>            Reporter: Kevin Liew
>            Assignee: Kevin Liew
>            Priority: Major
>              Labels: avatica, phoenix
>             Fix For: 4.12.0
>
>         Attachments: PHOENIX-2314.2.patch, PHOENIX-2314.3.patch, PHOENIX-2314.4.patch,
PHOENIX-2314.5.patch, PHOENIX-2314.patch
>
>
> *POST*
> {noformat}
> request: { "request":"prepare", "connectionId":"1646a1b9-334e-4a21-ade8-47c3d0c8e5a3",
"sql":"select * from emp where first_name like ?", "maxRowCount":-1 }
> Host: 192.168.203.156:8765
> Content-Length: 0
> {noformat}
> _select * from emp where first_name like ?_
> *RESPONSE*
> {noformat}
> HTTP/1.1 500 org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): Type
mismatch. BOOLEAN for null
> Date: Wed, 07 Oct 2015 22:42:26 GMT
> Cache-Control: must-revalidate,no-cache,no-store
> Content-Type: text/html; charset=ISO-8859-1
> Content-Length: 368
> Connection: close
> Server: Jetty(9.2.z-SNAPSHOT)
> <html>
> <head>
> <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1"/>
> <title>Error 500 </title>
> </head>
> <body>
> <h2>HTTP ERROR: 500</h2>
> <p>Problem accessing /. Reason:
> <pre>    org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): Type
mismatch. BOOLEAN for null</pre></p>
> <hr /><i><small>Powered by Jetty://</small></i>
> </body>
> </html>
> {noformat}
> _org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): Type mismatch. BOOLEAN
for null_



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message