[CASSANDRA-2939] CQL regex to match column family in query

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Labels: CQL python

Environment

Python CQL

• Severity: Low
• Assignee: Blake Visin
• Reporter: Blake Visin

Authors

Blake Visin

Reviewers

Tom Hobbs

• Created: 22/Jul/11 19:33
• Updated: 16/Apr/19 09:32
• Resolved: 08/Aug/11 18:47

Description

In the file cursor.py (https://svn.apache.org/repos/asf/cassandra/drivers/py/cql/cursor.py)

Line 37: _cfamily_re = re.compile("\s*SELECT\s+.+\s+FROM\s+[\']?(\w+)", re.I | re.M)

The Regex will improperly match anything after the word 'from' even if it is in the WHERE clause

I believe the fix is:

_cfamily_re = re.compile("\s*SELECT\s+.+?\s+FROM\s+[\']?(\w+)", re.I | re.M)

Added the ? so the regex is not so greedy

use this query to reproduce the results:

SELECT key FROM column_family WHERE key = 'break from chores'"