[jira] [Updated] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2018-05-23 Thread Josh Elser (JIRA) 

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

Josh Elser updated PHOENIX-2314:

Fix Version/s: (was: 4.12.0)
   4.14.0

> 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.14.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)
> 
> 
> 
> Error 500 
> 
> 
> HTTP ERROR: 500
> Problem accessing /. Reason:
> org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): 
> Type mismatch. BOOLEAN for null
> Powered by Jetty://
> 
> 
> {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)

[jira] [Updated] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2017-09-03 Thread Kevin Liew (JIRA) 

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

Kevin Liew updated PHOENIX-2314:

Attachment: PHOENIX-2314.5.patch

> 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
>  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)
> 
> 
> 
> Error 500 
> 
> 
> HTTP ERROR: 500
> Problem accessing /. Reason:
> org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): 
> Type mismatch. BOOLEAN for null
> Powered by Jetty://
> 
> 
> {noformat}
> _org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): Type 
> mismatch. BOOLEAN for null_



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

[jira] [Updated] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2017-09-02 Thread Kevin Liew (JIRA) 

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

Kevin Liew updated PHOENIX-2314:

Attachment: PHOENIX-2314.4.patch

> 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
>  Labels: avatica, phoenix
> Fix For: 4.12.0
>
> Attachments: PHOENIX-2314.2.patch, PHOENIX-2314.3.patch, 
> PHOENIX-2314.4.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)
> 
> 
> 
> Error 500 
> 
> 
> HTTP ERROR: 500
> Problem accessing /. Reason:
> org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): 
> Type mismatch. BOOLEAN for null
> Powered by Jetty://
> 
> 
> {noformat}
> _org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): Type 
> mismatch. BOOLEAN for null_



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

[jira] [Updated] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2017-09-01 Thread Kevin Liew (JIRA) 

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

Kevin Liew updated PHOENIX-2314:

Attachment: PHOENIX-2314.3.patch

Attaching patch. Will wait for test results before committing.

> 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
>  Labels: avatica, phoenix
> Fix For: 4.12.0
>
> Attachments: PHOENIX-2314.2.patch, PHOENIX-2314.3.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)
> 
> 
> 
> Error 500 
> 
> 
> HTTP ERROR: 500
> Problem accessing /. Reason:
> org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): 
> Type mismatch. BOOLEAN for null
> Powered by Jetty://
> 
> 
> {noformat}
> _org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): Type 
> mismatch. BOOLEAN for null_



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

[jira] [Updated] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2017-02-05 Thread Kevin Liew (JIRA) 

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

Kevin Liew updated PHOENIX-2314:

Attachment: PHOENIX-2314.2.patch

Thanks [~jamestaylor]. I attached another patch including the queryserver test.


> 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
>  Labels: avatica, phoenix
> Fix For: 4.10.0, 4.8.3
>
> Attachments: PHOENIX-2314.2.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)
> 
> 
> 
> Error 500 
> 
> 
> HTTP ERROR: 500
> Problem accessing /. Reason:
> org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): 
> Type mismatch. BOOLEAN for null
> Powered by Jetty://
> 
> 
> {noformat}
> _org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): Type 
> mismatch. BOOLEAN for null_



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Updated] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2016-12-19 Thread Kevin Liew (JIRA) 

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

Kevin Liew updated PHOENIX-2314:

Attachment: PHOENIX-2314.patch

Attached patch. I didn't include the queryserver test in this patch pending the 
conclusion of PHOENIX-1824.

> 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
>  Labels: avatica, phoenix
> Fix For: 4.10.0, 4.8.3
>
> Attachments: 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)
> 
> 
> 
> Error 500 
> 
> 
> HTTP ERROR: 500
> Problem accessing /. Reason:
> org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): 
> Type mismatch. BOOLEAN for null
> Powered by Jetty://
> 
> 
> {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)

[jira] [Updated] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2015-12-17 Thread Kevin Liew (JIRA) 

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




Error 500 


HTTP ERROR: 500
Problem accessing /. Reason:
org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): 
Type mismatch. BOOLEAN for null
Powered by Jetty://


{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}
*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)




Error 500 


HTTP ERROR: 500
Problem accessing /. Reason:
org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): 
Type mismatch. BOOLEAN for null
Powered by Jetty://


{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)
> 
> 
> 
> Error 500 
> 
> 
> HTTP ERROR: 500
> Problem accessing /. Reason:
> org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): 
> Type mismatch. BOOLEAN for null
> Powered by Jetty://
> 
> 
> {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)

[jira] [Updated] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2015-12-17 Thread Kevin Liew (JIRA) 

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




Error 500 


HTTP ERROR: 500
Problem accessing /. Reason:
org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): 
Type mismatch. BOOLEAN for null
Powered by Jetty://


{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}
*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)




Error 500 


HTTP ERROR: 500
Problem accessing /. Reason:
org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): 
Type mismatch. BOOLEAN for null
Powered by Jetty://


{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)
> 
> 
> 
> Error 500 
> 
> 
> HTTP ERROR: 500
> Problem accessing /. Reason:
> org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): 
> Type mismatch. BOOLEAN for null
> Powered by Jetty://
> 
> 
> {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)

[jira] [Updated] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2015-12-17 Thread Kevin Liew (JIRA) 

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




Error 500 


HTTP ERROR: 500
Problem accessing /. Reason:
org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): 
Type mismatch. BOOLEAN for null
Powered by Jetty://


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




Error 500 


HTTP ERROR: 500
Problem accessing /. Reason:
org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): 
Type mismatch. BOOLEAN for null
Powered by Jetty://


{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)
> 
> 
> 
> Error 500 
> 
> 
> HTTP ERROR: 500
> Problem accessing /. Reason:
> org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): 
> Type mismatch. BOOLEAN for null
> Powered by Jetty://
> 
> 
> {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)

[jira] [Updated] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2015-12-17 Thread Kevin Liew (JIRA) 

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




Error 500 


HTTP ERROR: 500
Problem accessing /. Reason:
org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): 
Type mismatch. BOOLEAN for null
Powered by Jetty://


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




Error 500 


HTTP ERROR: 500
Problem accessing /. Reason:
org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): 
Type mismatch. BOOLEAN for null
Powered by Jetty://


{noformat}


> 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}
> *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)
> 
> 
> 
> Error 500 
> 
> 
> HTTP ERROR: 500
> Problem accessing /. Reason:
> org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): 
> Type mismatch. BOOLEAN for null
> Powered by Jetty://
> 
> 
> {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)