Mamta A. Satoor (JIRA) wrote:
Is this a Java behavior that you can count on the order in which items will be added and retrieved from HashMap?
At this point, I am not sure, how to make sure that items get added and
retrieved in the same order from the HashMap so that we will have consistent
error message return from the create view sql above. Any insight from the list
will be appreciated.
I do not believe you can count on the order of a HashMap, different
JVM's may use different hash algo's which may result in different orders
when you ask for the full list. I have seen this behavior in queries
which use hash nodes in derby (I believe we first noticed a difference
between j9 and other jvm's). In that case we added order by's as
necessary to the tests, as either order of results was correct from
SQL point of view.
In your case is the order a code problem, or just a testing issue?
