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

Table attribute casing has changed #13

Open
steveoh opened this issue Apr 1, 2020 · 0 comments
Open

Table attribute casing has changed #13

steveoh opened this issue Apr 1, 2020 · 0 comments
Labels
known-issue We understand there is an issue with-workaround This issue has a work around

Comments

@steveoh
Copy link
Member

steveoh commented Apr 1, 2020

The problem

The Open SGID uses all lowercase attributes.

The reason

The SGID used a mix of lower, upper, snake, camel, and title case. To be more consistent, AGRC accepted the PostgreSQL lower case convention. Otherwise field names need to be quoted to persist their casing.

Example

[CountyBoundaries].[FIPS] becomes [county_boundaries].[fips]

MSSQL Server is not case sensitive when executing queries so this should not cause problems.

@steveoh steveoh added known-issue We understand there is an issue with-workaround This issue has a work around labels Apr 1, 2020
@agrc agrc locked as resolved and limited conversation to collaborators Apr 8, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
known-issue We understand there is an issue with-workaround This issue has a work around
Projects
None yet
Development

No branches or pull requests

1 participant