search

oaregithub / oare_mono

1 stars 0 forks source link

Fix for `update_discourse_spellings` stored procedure #1482

Closed Gertrudius closed 2 years ago

Gertrudius commented 2 years ago

SELECT FROM text_epigraphy WHERE discourse_uuid = "3a963317-4192-4015-b96b-ae7bb75a05ec"; SELECT FROM text_discourse WHERE uuid = "3a963317-4192-4015-b96b-ae7bb75a05ec";

As the above queries show, the explicit spelling in discourse is lacking the 6 in i-6, which means an adjustment needs to be made in one of the logical strings that concatenate dashes to the explicit spelling.

Gertrudius commented 2 years ago

After further examination, it looks like the procedure does successfully update these entries, so the explicit_spelling must have been generated before the latest version of the procedure was put in place. I went ahead and ran the procedure on any instances the below query found, which now have the correct explicit_spelling values. As such I'm closing this issue. SELECT * FROM text_discourse WHERE explicit_spelling LIKE ("%-")