Kevin Liew created PHOENIX-2314: ----------------------------------- Summary: 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
*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} *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} -- This message was sent by Atlassian JIRA (v6.3.4#6332)