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.

Sign up for GitHub

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

Jump to bottom

RMLTC0011b-MySQL: case-sensitivity in database relations and columns #40

Open
thomas-delva opened this issue Apr 12, 2021 · 1 comment
Open

RMLTC0011b-MySQL: case-sensitivity in database relations and columns #40

thomas-delva opened this issue Apr 12, 2021 · 1 comment

Comments

@thomas-delva
Copy link

Sometimes Student_Sport is used and sometimes student_sport, both in resource.sql and in mapping.ttl. MySQL is case-sensitive so this throws errors either when defining the database, or when querying it during RML execution.

Proposal: choose one of (i) all lowercase or (ii) capitalize first letter, and use it consistently in table/column identifiers
@bjdmeest
Copy link
Member

I'd use Student_Sport, to be/stay consistent with R2RML

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@bjdmeest @thomas-delva