Hi we have a problem with queries, database is returning wrong results.
These are the queries we run from ObjectDB explorer.
Query 1 - SELECT MAX(e.generisaniID) FROM AktImpl e – returns string (from field e.brojAkta) although field generisaniID is of type long.
Query 2 - select e.idRecord, e.generisaniID from AktImpl e- returns string (from field e.brojAkta) although field generisaniID is of type long. Retuned value from field idRecord is correct.
Query 3 SELECT e FROM AktImpl e – returns correct results
We had this problem on records created on 13 and 14 January, problem was detected yesterday when bug was detected in application.
We found a workaround by manually (through queries) changing the values of filed brojAkta in a way that we deleted the original values, saved the database and then inserted that value again and saved the database.
Repairing the database didn’t help,
Attached are a db repair log and a screenshot of queries and results. We will upload the DB through private issue ticket on which you can run these queris
Thanks for help