FreeformQuery yields unexpected results!

General
1

Hi,

I’m currently testing an SQLContainer in combination with a FreeformQuery (without a user defined FrreformQueryDelegate!), but get a result that I don’ t understand!

I’ve the following query:

SELECT d.bb_id, se.subentry_id FROM DEMO d LEFT OUTER JOIN SUBENTRY se ON d.bb_id = se.bb_id_fk ORDER BY d.bb_id DESC which yields the following result when using sqldeveloper(Oracle):

bb_id  subentry_id
567812 3
567812 1
12344  2
 12    null
2

Hi,
Let me give it another try, sorry for the incomplete mail!

I’m currently testing an SQLContainer in combination with a FreeformQuery (without a user defined FreeformQueryDelegate!), but get a result that I don’ t understand!

I’ve the following query:

SELECT d.bb_id, se.subentry_id
FROM DEMO d LEFT OUTER JOIN SUBENTRY se
ON d.bb_id = se.bb_id_fk
ORDER BY d.bb_id DESC

which yields the following result when using sqldeveloper(Oracle):

[u] [b] bb_id subentry_id [/b] [/u] 567812 3 567812 1 12344 2 12 null That is okay, when comparing with the actual contents of the DEMO and SUBENTRY tables.

However when I add this query into a FreeformQuery instance like:

FreeformQuery ffq = new FreeformQuery("SELECT d.bb_id, se.subentry_id " + "FROM DEMO d LEFT OUTER JOIN SUBENTRY se " + "ON d.bb_id = se.bb_id_fk " + "ORDER BY d.bb_id DESC", connectionPool, "bb_id"); The result is:

[u] [b] bb_id subentry_id [/b] [/u] 567812 [color=#0000FF] [b] [i] 1 [/i] [/b] [/color] 567812 1 12344 2 12 null The subentry_id equal to 3 has gone; but why?

Regards,
Gerard