Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
From: Hugi Thordarson <hugi@karlmenn.is>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Subject: EJBQL weirdness
Message-Id: <622C0864-EACA-4011-8C9B-C0BAEF9E022F@karlmenn.is>
Date: Tue, 30 Aug 2016 11:35:33 +0000
To: user@cayenne.apache.org
Mime-Version: 1.0 (Mac OS X Mail 9.3 \(3124\))
archived-at: Tue, 30 Aug 2016 11:35:47 -0000

Hi all.
I=E2=80=99m encountering some weirdness when running EJBQLQuery. =
Consider the following code:

	EJBQLQuery q =3D new EJBQLQuery( "select i.unitPrice,i.quantity =
from InvoiceLine i where i.companyNumber=3D'0100008338'" );
	List fetchedRows =3D objectContext.performQuery( q );
	System.out.println( "Size of resulting list: " + =
fetchedRows.size() );
	System.out.println( "Class of fetched objects: " + =
fetchedRows.get( 0 ).getClass() );

This generates the following output:

	- --- transaction started.
	- SELECT t0.unit_price AS sc0, t0.quantity AS sc1 FROM =
bok_invoice_line t0 WHERE t0.company =3D ? [bind: 1:'0100008338']
	- =3D=3D=3D returned 508 rows. - took 72 ms.
	- +++ transaction committed.
	Size of resulting list: 200
	Class of fetched objects: class [Ljava.lang.Object;

As you can see, the SQL is correct, and the debug log shows that the DB =
returns the expected number of 508 objects. However, the resulting List =
will only contain 200 objects. This number will then go on to change in =
weird ways if I modify the query, for example if I add a third attribute =
to fetch, the List will suddenly contain 204 objects=E2=80=94and that =
number may change based on which attribute I added. Quite odd, and =
I=E2=80=99ve not been able to identify any rule to how it happens.

Now, for the second level of weirdness: If I change the query to fetch =
data rows (by invoking setFetchingDataRows( true )), the list will end =
up containing the correct number of rows. But they will still be =
Object[] but not DataRows.

	- --- transaction started.
	- SELECT t0.unit_price AS sc0, t0.quantity AS sc1 FROM =
bok_invoice_line t0 WHERE t0.company =3D ? [bind: 1:'0100008338']
	- =3D=3D=3D returned 508 rows. - took 64 ms.
	- +++ transaction committed.
	Size of resulting list: 508
	Class of fetched objects: class [Ljava.lang.Object;

Any idea what=E2=80=99s happening? Thought I=E2=80=99d ask before I =
start digging around.

Cheers,
- hugi=