Hi,
It seems DN parse the native queries before execution. I found 2 cases:
-1- Query with * projection on flat inheritance model
The model (ex: Client -|> Person) mapped on one single table PERSON (ID, DISC, NAME)
In such situation when executing a query on the top persistent class, DN requires to have the discriminator column in the SELECT. (so far it's right)
ex: SELECT ID, DISC ... FROM PERSON
But if the query is (at least applicable on MySQL) "SELECT entity.* FROM PERSON entity ..." DN also requires to have the discriminator while it is returned by the query.
-2- Query comparing dates with > operator
SELECT P.* FROM PERSON P WHERE P.CREATION > P.DELETION
This works fine on the database but DN claims not supporting this > operator on temporals.
Are there any solution to desactivate the native query parsing ?
--
Stephane
