Skip to content

/ queryparser

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Column names or parts of column names may be incorrectly converted to lowercase #1

Closed
ianmcook opened this issue Aug 31, 2019 · 1 comment
Closed

Column names or parts of column names may be incorrectly converted to lowercase #1

ianmcook opened this issue Aug 31, 2019 · 1 comment
Labels
bug

Comments

@ianmcook
Copy link
Owner

@ianmcook ianmcook commented Aug 31, 2019 •
edited

When a column name matches the name of a SQL function that queryparser translates, then that column name is converted to lowercase. This also occurs for parts of columns names that are separated from other parts by periods. For example:

parse_expression("Length > 2")
#length > 2

parse_expression("Petal.Length > 2")
#Petal.length > 2

As a workaround until this is resolved, enclose variable names in backticks:

parse_expression("`Length` > 2")
#Length > 2

parse_expression("`Petal.Length` > 2")
#Petal.Length > 2
@ianmcook ianmcook changed the title Periods in names are sometimes treated like word boundaries Variable names or parts of variable names may be incorrectly converted to lowercase Aug 31, 2019
@ianmcook ianmcook changed the title Variable names or parts of variable names may be incorrectly converted to lowercase Column names or parts of column names may be incorrectly converted to lowercase Aug 31, 2019
ianmcook added a commit that referenced this issue Aug 31, 2019
@ianmcook
Fix issue with column names being converted to lowercase (#1)
e6fb07d
@ianmcook
Copy link
Owner Author

@ianmcook ianmcook commented Aug 31, 2019

Fixed in e6fb07d
@ianmcook ianmcook closed this Aug 31, 2019
@ianmcook ianmcook added the bug label Aug 31, 2019
ianmcook pushed a commit that referenced this issue Mar 29, 2020
@StevenHibble
Merge pull request #1 from ianmcook/master
Verified
This commit was created on GitHub.com and signed with a verified signature using GitHub’s key.
GPG key ID: 4AEE18F83AFDEB23 Learn about signing commits
eb44382 
Rebase
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
No milestone
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant
@ianmcook
You can’t perform that action at this time.