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

2018-05-23 Thread Hudson (JIRA) 

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

Hudson commented on PHOENIX-2314:
-

SUCCESS: Integrated in Jenkins build Phoenix-4.x-HBase-0.98 #1903 (See 
[https://builds.apache.org/job/Phoenix-4.x-HBase-0.98/1903/])
PHOENIX-2314 Cannot prepare parameterized statement with a 'like' (elserj: rev 
fa18c8f0992407e0df11c060a17c3346b723b3ab)
* (edit) 
phoenix-queryserver/src/it/java/org/apache/phoenix/end2end/QueryServerBasicsIT.java
* (edit) 
phoenix-core/src/it/java/org/apache/phoenix/end2end/LikeExpressionIT.java
* (edit) 
phoenix-core/src/main/java/org/apache/phoenix/compile/ExpressionCompiler.java


> 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, 5.0.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] [Commented] (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:comment-tabpanel=16487656#comment-16487656
 ] 

Josh Elser commented on PHOENIX-2314:
-

Yeah, I'm going to try to :)

> 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)
> 
> 
> 
> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2018-05-23 Thread James Taylor (JIRA) 

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

James Taylor commented on PHOENIX-2314:
---

Looks like the patch was never committed by [~kliew]. Patch needs to be rebased 
again. Will you rebase and commit, [~elserj]?

> 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)
> 
> 
> 
> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2018-05-22 Thread Johanes Anggara (JIRA) 

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

Johanes Anggara commented on PHOENIX-2314:
--

Any suggestion which library to use, to be able using LIKE statement?

> 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)
> 
> 
> 
> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2018-04-06 Thread Josh Elser (JIRA) 

[ 
https://issues.apache.org/jira/browse/PHOENIX-2314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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)
> 
> 
> 
> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2018-04-06 Thread Jasper van Ams (JIRA) 

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

Jasper van Ams commented on PHOENIX-2314:
-

Fix version 4.12.0 should be removed.

We moved from 4.10 to 4.12 and experienced the same avitica exception.

So I double checked the LikeExpressionIT and the fix was not there. (Neither is 
it in 4.13)

> 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)
> 
> 
> 
> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2017-09-04 Thread Hudson (JIRA) 

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

Hudson commented on PHOENIX-2314:
-

FAILURE: Integrated in Jenkins build Phoenix-master #1768 (See 
[https://builds.apache.org/job/Phoenix-master/1768/])
PHOENIX-2314 Cannot prepare parameterized statement with a 'like' (kliewkliew: 
rev 0a3ef6c1b5f2013ce6b3e5158e0417294ab7d92b)
* (edit) 
phoenix-queryserver/src/it/java/org/apache/phoenix/end2end/QueryServerBasicsIT.java
* (edit) 
phoenix-core/src/it/java/org/apache/phoenix/end2end/LikeExpressionIT.java
* (edit) 
phoenix-core/src/main/java/org/apache/phoenix/compile/ExpressionCompiler.java


> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2017-09-04 Thread James Taylor (JIRA) 

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

James Taylor commented on PHOENIX-2314:
---

+1

> 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] [Commented] (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:comment-tabpanel=16152072#comment-16152072
 ] 

Kevin Liew commented on PHOENIX-2314:
-

Failures seem unrelated to patch. Will commit.

> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2017-09-03 Thread Hadoop QA (JIRA) 

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

Hadoop QA commented on PHOENIX-2314:


{color:red}-1 overall{color}.  Here are the results of testing the latest 
attachment 
  http://issues.apache.org/jira/secure/attachment/12885167/PHOENIX-2314.5.patch
  against master branch at commit f03c43bdd2abb18f3a1edbc717340b52b529fb48.
  ATTACHMENT ID: 12885167

{color:green}+1 @author{color}.  The patch does not contain any @author 
tags.

{color:red}-1 tests included{color}.  The patch doesn't appear to include 
any new or modified tests.
Please justify why no new tests are needed for this 
patch.
Also please list what manual steps were performed to 
verify this patch.

{color:green}+1 javac{color}.  The applied patch does not increase the 
total number of javac compiler warnings.

{color:green}+1 release audit{color}.  The applied patch does not increase 
the total number of release audit warnings.

{color:green}+1 lineLengths{color}.  The patch does not introduce lines 
longer than 100

 {color:red}-1 core tests{color}.  The patch failed these unit tests:
 
./phoenix-core/target/failsafe-reports/TEST-org.apache.phoenix.end2end.TableSnapshotReadsMapReduceIT

Test results: 
https://builds.apache.org/job/PreCommit-PHOENIX-Build/1364//testReport/
Console output: 
https://builds.apache.org/job/PreCommit-PHOENIX-Build/1364//console

This message is automatically generated.

> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2017-09-01 Thread Hadoop QA (JIRA) 

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

Hadoop QA commented on PHOENIX-2314:


{color:red}-1 overall{color}.  Here are the results of testing the latest 
attachment 
  http://issues.apache.org/jira/secure/attachment/12885039/PHOENIX-2314.3.patch
  against master branch at commit 1aabbfa0d04261d1cebba845deaebf4c4048ae62.
  ATTACHMENT ID: 12885039

{color:green}+1 @author{color}.  The patch does not contain any @author 
tags.

{color:red}-1 tests included{color}.  The patch doesn't appear to include 
any new or modified tests.
Please justify why no new tests are needed for this 
patch.
Also please list what manual steps were performed to 
verify this patch.

{color:red}-1 javac{color}.  The patch appears to cause mvn compile goal to 
fail .

Compilation errors resume:
[ERROR] Failed to execute goal 
org.apache.maven.plugins:maven-clean-plugin:2.5:clean (default-clean) on 
project phoenix-core: Failed to clean project: Failed to delete 
/home/jenkins/jenkins-slave/workspace/PreCommit-PHOENIX-Build/phoenix-core/target
 -> [Help 1]
[ERROR] 
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e 
switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR] 
[ERROR] For more information about the errors and possible solutions, please 
read the following articles:
[ERROR] [Help 1] 
http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
[ERROR] 
[ERROR] After correcting the problems, you can resume the build with the command
[ERROR]   mvn  -rf :phoenix-core


Console output: 
https://builds.apache.org/job/PreCommit-PHOENIX-Build/1350//console

This message is automatically generated.

> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2017-09-01 Thread James Taylor (JIRA) 

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

James Taylor commented on PHOENIX-2314:
---

Would you have some spare cycles to rebase this patch so we can get it into 
4.12, [~kliew]?

> 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.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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2017-06-09 Thread Hadoop QA (JIRA) 

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

Hadoop QA commented on PHOENIX-2314:


{color:red}-1 overall{color}.  Here are the results of testing the latest 
attachment 
  http://issues.apache.org/jira/secure/attachment/12851117/PHOENIX-2314.2.patch
  against master branch at commit 4c11818429f437e4c926ba2a84c6ef67957ae506.
  ATTACHMENT ID: 12851117

{color:green}+1 @author{color}.  The patch does not contain any @author 
tags.

{color:red}-1 tests included{color}.  The patch doesn't appear to include 
any new or modified tests.
Please justify why no new tests are needed for this 
patch.
Also please list what manual steps were performed to 
verify this patch.

{color:green}+1 javac{color}.  The applied patch does not increase the 
total number of javac compiler warnings.

{color:red}-1 javadoc{color}.  The javadoc tool appears to have generated 
50 warning messages.

{color:green}+1 release audit{color}.  The applied patch does not increase 
the total number of release audit warnings.

{color:green}+1 lineLengths{color}.  The patch does not introduce lines 
longer than 100

 {color:red}-1 core tests{color}.  The patch failed these unit tests:
 

Test results: 
https://builds.apache.org/job/PreCommit-PHOENIX-Build/1082//testReport/
Javadoc warnings: 
https://builds.apache.org/job/PreCommit-PHOENIX-Build/1082//artifact/patchprocess/patchJavadocWarnings.txt
Console output: 
https://builds.apache.org/job/PreCommit-PHOENIX-Build/1082//console

This message is automatically generated.

> 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.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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2017-01-04 Thread James Taylor (JIRA) 

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

James Taylor commented on PHOENIX-2314:
---

The code change in ExpressionCompiler is fine, but the test isn't testing the 
code path you changed (the test passes without your change to 
ExpressionCompiler). You'd need to bind the parameter to null and you'd expect 
to get no rows back in that case. Also, you can't make the methods in the IT 
class static as then we wouldn't be able to run the methods in parallel:
{code}
 public class LikeExpressionIT extends ParallelStatsDisabledIT {
 
-private String tableName;
+private static String tableName;
 
-@Before
-public void initTable() throws Exception {
+@BeforeClass
+public static void initTable() throws Exception {
 tableName = generateUniqueName();
 Connection conn = null;
 PreparedStatement stmt = null;
@@ -58,7 +59,7 @@ public class LikeExpressionIT extends ParallelStatsDisabledIT 
{
 insertRow(conn, "321n7-App-2-", 32);
 }
 
-private void insertRow(Connection conn, String k, int i) throws 
SQLException {
+private static void insertRow(Connection conn, String k, int i) throws 
SQLException {
 PreparedStatement stmt = conn.prepareStatement(
 "UPSERT INTO " + tableName + " VALUES (?, ?)");
 stmt.setString(1, k);
{code}

I'm not convinced this is testing the actual issue, though. You should add a 
similar test with a parameterized LIKE query in QueryServerBasicsIT (but with 
the parameter bound as with your current 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.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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2017-01-04 Thread Josh Elser (JIRA) 

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

Josh Elser commented on PHOENIX-2314:
-

bq. this is okay to commit, right?

Going off of the precommit, I would imagine this is fine. I don't understand 
this part of the code well enough to say if the change is good.

Maybe [~jamestaylor] could take a quick glance before you commit it.

> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2017-01-03 Thread Kevin Liew (JIRA) 

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

Kevin Liew commented on PHOENIX-2314:
-

[~elserj], this is okay to commit, right?

> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2016-12-19 Thread Hadoop QA (JIRA) 

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

Hadoop QA commented on PHOENIX-2314:


{color:red}-1 overall{color}.  Here are the results of testing the latest 
attachment 
  http://issues.apache.org/jira/secure/attachment/12843955/PHOENIX-2314.patch
  against master branch at commit e45b5a706107e31bc6e5b8289725db097b2820eb.
  ATTACHMENT ID: 12843955

{color:green}+1 @author{color}.  The patch does not contain any @author 
tags.

{color:red}-1 tests included{color}.  The patch doesn't appear to include 
any new or modified tests.
Please justify why no new tests are needed for this 
patch.
Also please list what manual steps were performed to 
verify this patch.

{color:green}+1 javac{color}.  The applied patch does not increase the 
total number of javac compiler warnings.

{color:red}-1 javadoc{color}.  The javadoc tool appears to have generated 
44 warning messages.

{color:green}+1 release audit{color}.  The applied patch does not increase 
the total number of release audit warnings.

{color:green}+1 lineLengths{color}.  The patch does not introduce lines 
longer than 100

{color:green}+1 core tests{color}.  The patch passed unit tests in .

Test results: 
https://builds.apache.org/job/PreCommit-PHOENIX-Build/704//testReport/
Javadoc warnings: 
https://builds.apache.org/job/PreCommit-PHOENIX-Build/704//artifact/patchprocess/patchJavadocWarnings.txt
Console output: 
https://builds.apache.org/job/PreCommit-PHOENIX-Build/704//console

This message is automatically generated.

> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2016-12-12 Thread Kevin Liew (JIRA) 

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

Kevin Liew commented on PHOENIX-2314:
-

The fix is to change
{code:java}
return LiteralExpression.newConstant(null, rhs.getDeterminism());
{code}
to
{code:java}
return LiteralExpression.newConstant(null, PBoolean.INSTANCE, 
rhs.getDeterminism());
{code}

in ExpressionCompiler.visitLeave for LikeParseNode.

I will work on a patch with tests for the queryserver.

> 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
>
> *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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2015-12-23 Thread Kevin Liew (JIRA) 

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

Kevin Liew commented on PHOENIX-2314:
-

Hi Josh Elser

Do I need to build Phoenix on a Linux system with Hadoop installed?

I followed the guide at https://phoenix.apache.org/building.html on Windows but 
I get an error 

{quote}2015-12-23 10:21:32,874 ERROR [main] org.apache.hadoop.util.Shell(373): 
Failed to locate the winutils binary in the hadoop binary path
java.io.IOException: Could not locate executable null\bin\winutils.exe in the 
Hadoop binaries.{quote}

> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2015-12-23 Thread Josh Elser (JIRA) 

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

Josh Elser commented on PHOENIX-2314:
-

I've never tried to build Phoenix on Windows -- I'm not sure what the 
prerequisites are. I just know that it is possible. Sorry I'm not of more help 
from this side.

> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2015-12-23 Thread Josh Elser (JIRA) 

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

Josh Elser commented on PHOENIX-2314:
-

bq. I am using an HDP stack provisioned by Ambari. 

Not to outright call you a liar, but Ambari+HDP doesn't install HBase or 
Phoenix to {{/usr/local}}. It's going to be installing to {{/usr/hdp/...}} :). 
That's why I was a bit confused by the paths you shared before.

bq. If I'm not mistaken, queryserver.py:121 seems to indicate that the HBase 
path is used.

I believe you are mistaken. {{phoenix_utils.phoenix_queryserver_jar}} should be 
a path to {{/lib/phoenix-server-$VERSION-runnable.jar}}. 
{{hbase_config_path}} is the configuration directory for HBase (like I said 
earlier, getting {{hbase-site.xml}}).

Try modifying {{queryserver.py}} to print out {{java_cmd}} before it is invoked 
so that you can see what the actual values in the classpath are. That should 
help remove any doubt about where the jar is coming from.

> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2015-12-23 Thread Kevin Liew (JIRA) 

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

Kevin Liew commented on PHOENIX-2314:
-

After replacing the bin and jar files, I get the following error on any REST 
request:

{noformat}15/12/24 00:18:41 WARN server.HttpChannel: /
java.lang.IllegalArgumentException: Cannot find parser for
at 
org.apache.calcite.avatica.remote.ProtobufTranslationImpl.getParserForRequest(ProtobufTranslationImpl.java:166)
at 
org.apache.calcite.avatica.remote.ProtobufTranslationImpl.parseRequest(ProtobufTranslationImpl.java:223)
at 
org.apache.calcite.avatica.remote.ProtobufHandler.decode(ProtobufHandler.java:42)
at 
org.apache.calcite.avatica.remote.ProtobufHandler.decode(ProtobufHandler.java:28)
at 
org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:93)
at 
org.apache.calcite.avatica.remote.ProtobufHandler.apply(ProtobufHandler.java:38)
at 
org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle(AvaticaProtobufHandler.java:63)
at 
org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
at 
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:497)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
at 
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:245)
at 
org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
at 
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
at 
org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
at java.lang.Thread.run(Thread.java:745)
{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}
> _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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2015-12-23 Thread Kevin Liew (JIRA) 

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

Kevin Liew commented on PHOENIX-2314:
-

I am using an HDP stack provisioned by Ambari. 

If I'm not mistaken, queryserver.py:121 seems to indicate that the HBase path 
is used.
{code:python}java_cmd = '%(java)s -cp ' + hbase_config_path + os.pathsep + 
phoenix_utils.phoenix_queryserver_jar + \{code}
And the installation guide seems to corrobate this
https://phoenix.apache.org/installation.html


> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2015-12-23 Thread Josh Elser (JIRA) 

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

Josh Elser commented on PHOENIX-2314:
-

bq. /usr/local/hbase/lib/phoenix-server.jar

What kind of installation do you have here? Normally, this jar would go in 
{{/lib/}}. The {{queryserver.py} script doesn't look into 
the HBase installation other than for hbase-site.xml.

> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2015-12-23 Thread Kevin Liew (JIRA) 

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

Kevin Liew commented on PHOENIX-2314:
-

I built from the latest source code (which uses Calcite 1.5.0) and replaced the 
jars on the Phoenix server.
||Built jar||Server jar path||
|./phoenix-core/target/phoenix-core-4.7.0-HBase-1.1-SNAPSHOT.jar 
|/usr/local/hbase/lib/phoenix.jar|
|./phoenix-server/target/phoenix-server-4.7.0-HBase-1.1-SNAPSHOT-runnable.jar|/usr/local/hbase/lib/phoenix-server.jar|

Then I restarted the server and ran the query with the same results. Do I need 
to replace any other jars on the server? 

> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2015-12-23 Thread Kevin Liew (JIRA) 

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

Kevin Liew commented on PHOENIX-2314:
-

I redid the test using a simpler schema

{noformat}DROP TABLE IF EXISTS Char_Table;
CREATE TABLE IF NOT EXISTS Char_Table(
KeyColumn VARCHAR(255) PRIMARY KEY,
Column1 CHAR(255));{noformat}

{noformat}select * from char_table where column1 like ?{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}
> _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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2015-12-23 Thread Kevin Liew (JIRA) 

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

Kevin Liew commented on PHOENIX-2314:
-

No worries, it seems to be building fine on Linux without Hadoop installed

> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2015-12-23 Thread Kevin Liew (JIRA) 

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

Kevin Liew commented on PHOENIX-2314:
-

Sorry I was mistaken again, the HDP server is not the one I'm using right now. 
I'm using a Docker container with HBase and Phoenix installed during the image 
build
Reply.

I will try again after replacing those jars.

> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2015-12-22 Thread Josh Elser (JIRA) 

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

Josh Elser commented on PHOENIX-2314:
-

Also, the schema for your {{emp}} table would be very helpful to share!

> 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] [Commented] (PHOENIX-2314) Cannot prepare parameterized statement with a 'like' predicate

2015-12-22 Thread Josh Elser (JIRA) 

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

Josh Elser commented on PHOENIX-2314:
-

Hi [~kliew],

Any chance you could try this out with the latest release of Calcite (1.5.0)? 
We've fixed a lot of issues since 1.3.0-incubating (which Phoenix 4.5.2 used). 
It would be super helpful if you could rebuild (should be as simple as adding 
{{-Dcalcite.version=1.5.0}} to the maven command line arguments), and see if 
you still run into this issue.

If you don't have the time, I'll try to see if I can reproduce it.

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