[jira] [Commented] (CASSANDRA-14165) execute_prepared_cql3_query with LIKE not working
[ 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
[ 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
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