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

kg-construct / rml-test-cases

RML conformance test suite

http://rml.io/test-cases/

Creative Commons Attribution 4.0 International

4 stars 11 forks source link

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

Open thomas-delva opened 3 years ago

thomas-delva commented 3 years ago

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 commented 3 years ago

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