jbovlaste
jbovlaste copied to clipboard
"Data inconsistencies" in natlangwords
Natural language words that are entered with both a "default" sense as well as at least one explicit sense are displayed with an error:
Data Inconsistency
There appears to be both a default meaning for this word, and one or more
specialized meanings. This makes little sense, and should be corrected.
e.g. http://jbovlaste.lojban.org/natlang/en/extreme
There are currently more than 800 language/word pairs in the database which exhibit this problem, as indicated by this query:
select w.langid, w.word, count(*)
from natlangwords w
where exists
(select 1 from natlangwords ww
where ww.langid = w.langid and ww.word = w.word
and ww.meaning is null)
and exists
(select 1 from natlangwords www
where www.langid = w.langid and www.word = w.word
and www.meaning is not null)
group by w.langid, w.word;
Either this rule should be enforced and the problem cases cleaned up, or the rule should be scrapped along with this error message.
I think this rule should be enforced. One needs to export them in csv or xml so that we can fix all of them collectivelyin a google spreadsheet.