[CASSANDRA-2993] Issues with parameters being escaped correctly in Python CQL

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 0.8.4
• Labels: CQL parameter python

Environment

Python CQL

• Severity: Normal
• Assignee: Tom Hobbs
• Reporter: Blake Visin

Authors

Tom Hobbs

Reviewers

Pavel Yaskevich

• Created: 04/Aug/11 21:54
• Updated: 16/Apr/19 09:32
• Resolved: 10/Aug/11 14:37

Description

When using parameterised queries in Python CQL strings are not being escaped correctly.

Query and Parameters:

'UPDATE sites SET :col = :val WHERE KEY = :site_id'

{'col': 'feed_stats:1312493736688033024',
 'site_id': '899d15e8-bd4a-11e0-bc8c-001fe14cba06',
 'val': "(dp0\nS'1'\np1\n(lp2\nI1\naI2\naI3\naI4\nasS'0'\np3\n(lp4\nI1\naI2\naI3\naI4\nasS'3'\np5\n(lp6\nI1\naI2\naI3\naI4\nasS'2'\np7\n(lp8\nI1\naI2\naI3\naI4\nas."}

Query trying to be executed after processing parameters

     
"UPDATE sites SET 'feed_stats:1312493736688033024' = '(dp0\nS''1''\np1\n(lp2\nI1\naI2\naI3\naI4\nasS''0''\np3\n(lp4\nI1\naI2\naI3\naI4\nasS''3''\np5\n(lp6\nI1\naI2\naI3\naI4\nasS''2''\np7\n(lp8\nI1\naI2\naI3\naI4\nas.' WHERE KEY = '899d15e8-bd4a-11e0-bc8c-001fe14cba06'"