Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-14165

execute_prepared_cql3_query with LIKE not working

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Normal
    • Resolution: Cannot Reproduce
    • None
    • None
    • None
    • Normal

    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.

      Attachments

        Activity

          People

            blerer Benjamin Lerer
            agorbachev Alexandr Gorbachev
            Benjamin Lerer
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: