jowkl not filtering deleted entries in the database

[chmeyer]

Originally reported on Google Code with ID 1

What steps will reproduce the problem?
1. Use getDefinedMeaningByWord(String) from OmegaWiki Class
2. look for "ночь" - russian night



What is the expected output? What do you see instead?
it will find night and morning (which is wrong) as defined meaning

What version of the product are you using? On what operating system?


Please provide any additional information below.
I checked the DBStamtements class. To me it looks like, that the column remove_transaction_id
in syntranstable inidcates (if not null) that the syntrans has been deleted and therefore
should not be in the result set.
I add an AND to thw Where Clause for the sql string and it shows the desired result.

take care

volker

Reported by skolasiela on 2013-05-30 15:14:29