Add support for additional SPARK keywords (pr643, by mrmasterplan).
Avoid tokens copy (pr622, by living180).
Add REGEXP as a comparision (pr647, by PeterSandwich).
Add DISTINCTROW keyword for MS Access (issue677).
Improve parsing of CREATE TABLE AS SELECT (pr662, by chezou).
Bug Fixes
Fix spelling of INDICATOR keyword (pr653, by ptld).
Fix formatting error in EXTRACT function (issue562, issue670, pr676, by ecederstrand).
Fix bad parsing of create table statements that use lower case (issue217, pr642, by mrmasterplan).
Handle backtick as valid quote char (issue628, pr629, by codenamelxl).
Allow any unicode character as valid identifier name (issue641).
Other
Update github actions to test on Python 3.10 as well (pr661, by cclaus).
Release 0.4.2 (Sep 10, 2021)
Notable Changes
IMPORTANT: This release fixes a security vulnerability in the
strip comments filter. In this filter a regular expression that was
vulnerable to ReDOS (Regular Expression Denial of Service) was
used. See the security advisory for details: https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-p5w8-wqhj-9hhf
The vulnerability was discovered by @erik-krogh and @yoff from
GitHub Security Lab (GHSL). Thanks for reporting!
Enhancements
Add ELSIF as keyword (issue584).
Add CONFLICT and ON_ERROR_STOP keywords (pr595, by j-martin).
Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.
Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR:
- `@dependabot rebase` will rebase this PR
- `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it
- `@dependabot merge` will merge this PR after your CI passes on it
- `@dependabot squash and merge` will squash and merge this PR after your CI passes on it
- `@dependabot cancel merge` will cancel a previously requested merge and block automerging
- `@dependabot reopen` will reopen this PR if it is closed
- `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
- `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
- `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
- `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
Bumps sqlparse from 0.2.3 to 0.4.3.
Changelog
Sourced from sqlparse's changelog.
... (truncated)
Commits
fba15d3
Bump version.b72a8ff
Allow any unicode character as identifier name (fixes #641).07a2e81
Add docstring and comments.4235eb8
Add tests for utils.remove_quotes.e269881
Update Changelog and authors.c1a597e
add backtick to remove_quotes character list893d7b2
Update CHANGELOG.403de6f
Fixed bad parsing of create table statements that use lower casea172486
Update Changelog.7de1999
CREATE TABLE tbl AS SELECT should return get_alias() for its columnDependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting
@dependabot rebase
.Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)