Skip to content
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

Column name with space #163

Open
Alletkla opened this issue Oct 7, 2023 · 0 comments
Open

Column name with space #163

Alletkla opened this issue Oct 7, 2023 · 0 comments
Labels
bug Something isn't working

Comments

@Alletkla
Copy link
Contributor

Alletkla commented Oct 7, 2023

Your inserted SQL-Statement:

SELECT "col mit Leerzeichen" FROM table1

The generated RegEx:

^\s*SELECT\s+[`´'"]?colmitLeerzeichen[`´'"]?\s*(\s*(?:ALIAS|AS)\s+.*?)?\s+FROM\s+[`´'"]*table1[`´'"]*(\s*(?:ALIAS|AS)?\s+.*)?\s*;?\s*$

Steps to reproduce:

all settings disabled

Expected Statement to match the RegEx:

SELECT "col mit Leerzeichen" FROM table1

Additional context:
Problem is that spaced column names get whitespace stripped in the RegEx

@Alletkla Alletkla added the bug Something isn't working label Oct 7, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant