search

oaregithub / oare_sql

1 stars 0 forks source link

text epigraphy rows that are missing words #46

Closed oaregithub closed 1 year ago

oaregithub commented 1 year ago

Error discovered by Harrison, shown in this query: SELECT te.* FROM text_epigraphy te LEFT JOIN text_discourse td ON td.uuid = te.discourse_uuid WHERE td.id IS NULL AND te.type IN ('word','number');

All are numbers. Most have a discourse_uuid - suggesting that the numbers were deleted in previous editing...

Google sheet with the examples and progress here: https://docs.google.com/spreadsheets/d/1fWVWZ_SQgwnhsfRqq4Vm833HeW1qzquFeKPXM2lmCRs/edit#gid=0

oaregithub commented 1 year ago

All texts I looked at closely were texts that had been heavily articulated by me in distant past - some configuration may have meant that the number got deleted during one of the cleaning operations. All are fixed now.