Changes in python-sqlparse¶

Release 0.1.3 (Jul 29, 2011)¶

Bug Fixes

Improve parsing of floats (thanks to Kris).
When formatting a statement a space before LIMIT was removed (issue35).
Fix strip_comments flag (issue38, reported by ooberm...@gmail.com).
Avoid parsing names as keywords (issue39, reported by djo...@taket.org).
Make sure identifier lists in subselects are grouped (issue40, reported by djo...@taket.org).
Split statements with IF as functions correctly (issue33 and issue29, reported by charles....@unige.ch).
Relax detection of keywords, esp. when used as function names (issue36, nyuhu...@gmail.com).
Don’t treat single characters as keywords (issue32).
Improve parsing of stand-alone comments (issue26).
Detection of placeholders in paramterized queries (issue22, reported by Glyph Lefkowitz).
Add parsing of MS Access column names with braces (issue27, reported by frankz...@gmail.com).

Other

Bug Fixes

Fixed incorrect detection of keyword fragments embed in names (issue7, reported and initial patch by andyboyko).
Stricter detection of identfier aliases (issue8, reported by estama).
WHERE grouping consumed closing parenthesis (issue9, reported by estama).
Fixed an issue with trailing whitespaces (reported by Kris).
Better detection of escaped single quotes (issue13, reported by Martin Brochhaus, patch by bluemaro with test case by Dan Carley).
Ignore identifier in double-quotes when changing cases (issue 21).
Lots of minor fixes targeting encoding, indentation, statement parsing and more (issues 12, 14, 15, 16, 18, 19).
Code cleanup with a pinch of refactoring.

Bug Fixes

Lexers preserves original line breaks (issue1).
Improved identifier parsing: backtick quotes, wildcards, T-SQL variables prefixed with @.
Improved parsing of identifier lists (issue2).
Recursive recognition of AS (issue4) and CASE.
Improved support for UPDATE statements.

Other

Initial release.