data-api-builder icon indicating copy to clipboard operation
data-api-builder copied to clipboard

[Bug]: Cannot read the table name when it is contains capital letters

Open ellaching2468 opened this issue 1 year ago • 2 comments

What happened?

When the table name contains capital letter, Data Api Builder will convert it into lower case and hence the table cannot be read

Version

Microsoft.DataApiBuilder 1.1.7+74ea6c5f37f8629fd7f8b13fc56027bf0bf0a93a

What database are you using?

PostgreSQL

What hosting model are you using?

Local (including CLI)

Which API approach are you accessing DAB through?

REST

Relevant log output

No response

Code of Conduct

  • [X] I agree to follow this project's Code of Conduct
### Tasks

ellaching2468 avatar May 16 '24 10:05 ellaching2468

Thank you for reporting, we will look into this

seantleonard avatar May 17 '24 00:05 seantleonard

Encountering same issue in PSQL "entities"->"$"->"object": "public.TableName" gives relation not exists error. Creating a copy of table with small letters and giving that in object name works. Also tried "object": "public."TableName""

SaiyamK avatar May 31 '24 14:05 SaiyamK