[jira] [Resolved] (OPENJPA-2764) Map path expression tests behave random

["Mark Struberg (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OPENJPA-2764?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mark Struberg resolved OPENJPA-2764.
------------------------------------
    Resolution: Fixed

> Map path expression tests behave random
> ---------------------------------------
>
>                 Key: OPENJPA-2764
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2764
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: build / infrastructure
>    Affects Versions: 3.0.0
>            Reporter: Mark Struberg
>            Assignee: Mark Struberg
>            Priority: Major
>             Fix For: 3.0.1
>
>
> Most of the tests under org.apache.openjpa.persistence.jdbc.maps behave random when they test against a real database.
> Those tests capture the JQPL path navigation for Maps (Covered in the spec in 4.4.4.1).
> {code}
> public class @Entity Division {
>   private Map<Division, VicePresident> orga;
> }
> {code}
> Such structures can be navitated via KEY(), VALUE(), and ENTRY().
> Our tests did create 2 Divisions with 2 orga entries. And using {{query.getResultList().get(0)}} to verify the results. And this was exactly the problem. using {{get(0)}} leads to random behaviour with real databases. On the default Derby database it didn't make any difference as the result from the index query was always in the order in which the data got written to disk. But this is not guaranteed for performance tuned databases like PostgreSQL, MariaDB and MySQL. In those cases we got random errors.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)