[ 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