[ 
https://issues.apache.org/jira/browse/CASSANDRA-2993?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13082395#comment-13082395
 ] 

Hudson commented on CASSANDRA-2993:
-----------------------------------

Integrated in Cassandra-0.8 #266 (See 
[https://builds.apache.org/job/Cassandra-0.8/266/])
    Fixes issues with parameters being escaped incorrectly in Python CQL
patch by Tyler Hobbs; reviewed by Pavel Yaskevich for CASSANDRA-2993

xedin : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1156198
Files : 
* /cassandra/branches/cassandra-0.8/test/system/test_cql.py
* /cassandra/branches/cassandra-0.8/CHANGES.txt
* /cassandra/drivers/py/cql/cursor.py
* /cassandra/branches/cassandra-0.8/src/java/org/apache/cassandra/cql/Cql.g
* /cassandra/drivers/py/test/test_regex.py


> 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
>            Assignee: Tyler Hobbs
>              Labels: CQL, parameter, python
>             Fix For: 0.8.4
>
>         Attachments: 2993-cql-grammar.txt, 2993-pycql.txt, 
> 2993-system-test.txt
>
>
> 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

        

Reply via email to