keboola / db-extractor-mssql

MIT License
1 stars 2 forks source link

Fix edge-case - if column name contains only spaces #176

Closed michaljurecko closed 4 years ago

michaljurecko commented 4 years ago

Solving: https://keboola.atlassian.net/browse/COM-352

Slack: https://keboola.slack.com/archives/CQ1ASK06M/p1595939846007000?thread_ts=1595493896.000800&cid=CQ1ASK06M

Changes:

From doc https://docs.microsoft.com/en-us/sql/odbc/microsoft/column-name-limitations?view=sql-server-ver15:

Column names can contain any valid characters (for example, spaces). 
If column names contain any characters except letters, numbers, and underscores, 
the name must be delimited by enclosing it in back quotes (`).