phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kevin Liew (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate
Date Thu, 17 Dec 2015 23:23:46 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-2314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kevin Liew updated PHOENIX-2314:
--------------------------------
    Description: 
*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*

  was:
*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}
*org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): Type mismatch. BOOLEAN
for null*


> 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
>              Labels: avatica, phoenix
>
> *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
(v6.3.4#6332)

Mime
View raw message