jbovlaste icon indicating copy to clipboard operation
jbovlaste copied to clipboard

"Data inconsistencies" in natlangwords

Open teleological opened this issue 10 years ago • 1 comments

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.

teleological avatar Mar 30 '14 04:03 teleological

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.

lagleki avatar Mar 30 '14 06:03 lagleki