Here is the scenario: I had derby 10.8.1.2 up and running for about 10 days. Few hours ago I stopped it and restarted it. However it appears that my data is somehow messed up (or some setting that I am not aware of).
If I run select activitytypeid from activitytype", it returns 35 records; if I run "select activitytypeid, name from activitytype", it returns only 28 records!!! I have no clue what is going on or where/what I should be looking for to fix this problem. Please advise, Sandeep
