[jira] [Commented] (CASSANDRA-14165) execute_prepared_cql3_query with LIKE not working

2018-01-23 Thread Alexandr Gorbachev (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-14165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16335576#comment-16335576
 ] 

Alexandr Gorbachev commented on CASSANDRA-14165:


[cqlsh 5.0.1 | Cassandra 3.9 | CQL spec 3.4.2 | Native protocol v4]

According to version 3.9 seems like this problem should be already fixed, right 
?

 

> execute_prepared_cql3_query with LIKE not working
> -
>
> Key: CASSANDRA-14165
> URL: https://issues.apache.org/jira/browse/CASSANDRA-14165
> Project: Cassandra
>  Issue Type: Bug
>Reporter: Alexandr Gorbachev
>Assignee: Benjamin Lerer
>Priority: Major
>
> Hello ,
> I have faced up with following issue.
>  Seems like LIKE is not supported by 'execute_prepared_cql3_query'.
>  Is it by desing or somehow it is possible to find a workaroud or to fix this 
> issue?
> More details. Query looks like :
>  SELECT * FROM tabke WHERE a= ? AND b = ? AND c IN (?,?,?,?,?,?,?) AND column 
> LIKE ? ALLOW FILTERING;
>  Is not working.
> If I send directly query in prepare statement.
>  So actully wihout passing parameters in preare statement, just like plain 
> query, then this is working:
>  SELECT * FROM tabke WHERE a= '1' AND b = '2' AND c IN ('3','4') AND column 
> LIKE '%A%' ALLOW FILTERING;
> Could you please suggest also where it is possible to find 
> description/definition of 'execute_prepared_cql3_query'.
>  
> Thank you for help.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org



[jira] [Updated] (CASSANDRA-14165) execute_prepared_cql3_query with LIKE not working

2018-01-15 Thread Alexandr Gorbachev (JIRA)

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

Alexandr Gorbachev updated CASSANDRA-14165:
---
Description: 
Hello ,

I have faced up with following issue.
 Seems like LIKE is not supported by 'execute_prepared_cql3_query'.
 Is it by desing or somehow it is possible to find a workaroud or to fix this 
issue?

More details. Query looks like :
 SELECT * FROM tabke WHERE a= ? AND b = ? AND c IN (?,?,?,?,?,?,?) AND column 
LIKE ? ALLOW FILTERING;
 Is not working.

If I send directly query in prepare statement.
 So actully wihout passing parameters in preare statement, just like plain 
query, then this is working:
 SELECT * FROM tabke WHERE a= '1' AND b = '2' AND c IN ('3','4') AND column 
LIKE '%A%' ALLOW FILTERING;

Could you please suggest also where it is possible to find 
description/definition of 'execute_prepared_cql3_query'.

 

Thank you for help.

  was:
Hello ,

I have faced up with following issue.
Seems like LIKE is not supported by 'execute_prepared_cql3_query'.
Is it by desing or somehow it is possible to find a workaroud or to fix this 
issue?

More details. Query looks like :
SELECT * FROM tabke WHERE a= ? AND b = ? AND c IN (?,?,?,?,?,?,?) AND column 
LIKE ? ALLOW FILTERING;
Is not working.

If I send directly query in prepare statement.
So actully wihout passing parameters in preare statement, just like plain 
query,  then this is working:
SELECT * FROM tabke WHERE a= '1' AND b = '2' AND c IN ('3','4') AND column LIKE 
'%A%' ALLOW FILTERING;

Thank you for help.


> execute_prepared_cql3_query with LIKE not working
> -
>
> Key: CASSANDRA-14165
> URL: https://issues.apache.org/jira/browse/CASSANDRA-14165
> Project: Cassandra
>  Issue Type: Bug
>Reporter: Alexandr Gorbachev
>Priority: Major
>
> Hello ,
> I have faced up with following issue.
>  Seems like LIKE is not supported by 'execute_prepared_cql3_query'.
>  Is it by desing or somehow it is possible to find a workaroud or to fix this 
> issue?
> More details. Query looks like :
>  SELECT * FROM tabke WHERE a= ? AND b = ? AND c IN (?,?,?,?,?,?,?) AND column 
> LIKE ? ALLOW FILTERING;
>  Is not working.
> If I send directly query in prepare statement.
>  So actully wihout passing parameters in preare statement, just like plain 
> query, then this is working:
>  SELECT * FROM tabke WHERE a= '1' AND b = '2' AND c IN ('3','4') AND column 
> LIKE '%A%' ALLOW FILTERING;
> Could you please suggest also where it is possible to find 
> description/definition of 'execute_prepared_cql3_query'.
>  
> Thank you for help.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org



[jira] [Created] (CASSANDRA-14165) execute_prepared_cql3_query with LIKE not working

2018-01-12 Thread Alexandr Gorbachev (JIRA)
Alexandr Gorbachev created CASSANDRA-14165:
--

 Summary: execute_prepared_cql3_query with LIKE not working
 Key: CASSANDRA-14165
 URL: https://issues.apache.org/jira/browse/CASSANDRA-14165
 Project: Cassandra
  Issue Type: Bug
Reporter: Alexandr Gorbachev


Hello ,

I have faced up with following issue.
Seems like LIKE is not supported by 'execute_prepared_cql3_query'.
Is it by desing or somehow it is possible to find a workaroud or to fix this 
issue?

More details. Query looks like :
SELECT * FROM tabke WHERE a= ? AND b = ? AND c IN (?,?,?,?,?,?,?) AND column 
LIKE ? ALLOW FILTERING;
Is not working.

If I send directly query in prepare statement.
So actully wihout passing parameters in preare statement, just like plain 
query,  then this is working:
SELECT * FROM tabke WHERE a= '1' AND b = '2' AND c IN ('3','4') AND column LIKE 
'%A%' ALLOW FILTERING;

Thank you for help.



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

-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org