[CASSANDRA-11456] support for PreparedStatement with LIKE

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 3.6
• Component/s: Legacy/CQL
• Labels: sasi
• Assignee: Sam Tunnicliffe
• Reporter: Pavel Yaskevich

Authors

Sam Tunnicliffe

Reviewers

Pavel Yaskevich

• Created: 29/Mar/16 18:19
• Updated: 16/Apr/19 09:30
• Resolved: 01/Apr/16 13:48

Description

Using the Java driver for example:

PreparedStatement pst = session.prepare("select * from test.users where first_name LIKE ?");
BoundStatement bs = pst.bind("Jon%");

The first line fails with SyntaxError: line 1:47 mismatched input '?' expecting STRING_LITERAL (which makes sense since it's how it's declared in the grammar). Other operators declare the right-hand side value as a Term.Raw, which can also be a bind marker.

I think users will expect to be able to bind the argument this way.