[eclipselink-users] Native queries...disturbing behavior...bug?

[Laird Nelson <ljnelson@xxxxxxxxx>]

I am running a native query with the following SQL:

SELECT t.id AS ID, t.description AS TEXT, NULL AS FREERESPONSEIDS FROM LEAD.YesNo t ORDER BY id;

(I have an AnswerEntity that can build itself from these properties.  That part works fine.)

I use these results.

Then I create another new native query like this:

SELECT t.id AS ID, t.description AS TEXT, "17" AS FREERESPONSEIDS FROM Stay t ORDER BY id;

The answers that come back in the list include the answers from my FIRST native query.

It is like the two queries are somehow linked, even though they are created anew each time.

Is there any sharing of results between native queries?  Any ideas on where to look here for pilot or EclipseLink error?

Thanks,
Laird