generated from mtxr/vsc-sqltools-driver-template
-
Notifications
You must be signed in to change notification settings - Fork 8
Open
Description
I have several @ and | characters in table and column names (yes I need these). Unfortunately the driver doesn't handling them properly.
-
Show table records: 'Parser Error: syntax error at or near "@"'
-
Describe table: works fine
-
Generate insert query: Two problems
- there's an additional space before (and sometimes after) the special characters like 'test@a' -> 'test @A' and test|b' -> 'test | b' in case of table and column names
- the other problem is that it doesn't generate double quote chars around column and table names including special characters
-
Add names to cursor: it doesn't add extra spaces but still no double quote chars around names with special characters included ( less problematic since it can be added manually )
-
Copy values: works fine
Reproduction:
create table "test@a|b"
(
"test@a" int,
"test|b" int
)
Metadata
Metadata
Assignees
Labels
No labels