Description Ivan Belis 2011-01-21 05:09:00 EST

Build Identifier: 2.1.2.v20101206-r8635

While migrating from EclipseLink 1 to the latest 2.1.2 we have encountered an incompatibillity when using native queries.

The result class of calling getSingleresult on a native query is different between eclipselink version 1.0.2 and 2.1.2

Example:
	Query q = em.createNativeQuery("SELECT '1' FROM dual ");
	Object obj = q.getSingleResult();

In EclipseLink 1.0.2 this will give a List with as first element a BigDecimal.
In EclipseLink 2.1.2 this will return a BigDecimal.

This means that upgrading from a 1 to version 2 means modifying code.

If the current behaviour is correct (as i presume it is) then this should be documented in a release note or an upgrade note.

Another test case but now with multiple columns:
		Query q = em.createNativeQuery("SELECT 1,2 FROM dual ");
		Object obj = q.getSingleResult();

In EclipseLink 1.0.2 this will give a List with as first element a BigDecimal.
In EclipseLink 2.1.2 this will return an Array with as first element a BigDecimal.


Greetings,
Ivan Belis

Reproducible: Always

Steps to Reproduce:
1. Create native query that returns a scalar non entity, for example
	Query q = em.createNativeQuery("SELECT '1' FROM dual ");
	Object obj = q.getSingleResult();
2. Examine the class returned by query.getSingleResult
3. Run with EclipseLink 1 
4. Run with EclipseLink 2