provsql icon indicating copy to clipboard operation
provsql copied to clipboard

Do not create provenance mappings with an uppercase letter unless required.

Open PierreSenellart opened this issue 1 year ago • 0 comments

By default, provenance mappings are created by create_provenance_mapping as a table that has exactly the name provided by the user. This means in particular that if the provenance mapping has uppercase characters, the table name will include these characters. But since PostgreSQL normalizes case in SQL statements to all lower cases for table/attribute names, the resulting table will be unusable unless quoted with " ".

This is mostly a quirk of PostgreSQL but it would probably cause less confusion if ProvSQL normalizes table/attribute names to lower case when constructing a provenance mapping (at least if they do not include special characters). Maybe add an optional argument to create_provenance_mapping to control this behavior.

PierreSenellart avatar Mar 14 '24 12:03 PierreSenellart