tiberius icon indicating copy to clipboard operation
tiberius copied to clipboard

fix: allow query on columns with space in name

Open Geo-W opened this issue 1 year ago • 3 comments

As sql server allows empty space in column name, make it adaptable to columns with space in its name.

Geo-W avatar May 28 '23 06:05 Geo-W

This looks good. Do you think this would be straightforward to check in a test?

tomhoule avatar May 31 '23 08:05 tomhoule

This looks good. Do you think this would be straightforward to check in a test?

Sure! Thank you very much~

Geo-W avatar May 31 '23 09:05 Geo-W

I was bitten by this issue today when attempting to do a bulk insert to a table having columns with spaces in the name. Is this just waiting on a test to be merged? I can take a crack at it if @Geo-W isn't able to. The code should probably also be updated to handle the case where the column name contains the ] character, which would need to be escaped by doubling it.

descawed avatar Oct 08 '23 01:10 descawed