[
https://issues.apache.org/jira/browse/CASSANDRA-2993?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13079629#comment-13079629
]
Blake Visin commented on CASSANDRA-2993:
----------------------------------------
This is using pickle to serialise objects in python.
> Issues with parameters being escaped correctly in Python CQL
> ------------------------------------------------------------
>
> Key: CASSANDRA-2993
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2993
> Project: Cassandra
> Issue Type: Bug
> Environment: Python CQL
> Reporter: Blake Visin
> Labels: CQL, parameter, python
>
> When using parameterised queries in Python CQL strings are not being escaped
> correctly.
> Query and Parameters:
> {code}
> '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."}
> {code}
> Query trying to be executed after processing parameters
> {code}
> "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'"
> {code}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
