[
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)
