You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openjpa.apache.org by tovarisch <is...@gmail.com> on 2011/05/05 11:27:27 UTC

Re: SQL generated by TYPE() function

Hi all,

Could anyone confirm that the query is correct? 

    SELECT n FROM Node n WHERE TYPE(n.parent)=Folder 

Thank you very much.


--
View this message in context: http://openjpa.208410.n2.nabble.com/SQL-generated-by-TYPE-function-tp6310346p6333672.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: SQL generated by TYPE() function

Posted by Michael Dick <mi...@gmail.com>.
Looks correct to me. There's a similar example in 
https://fisheye6.atlassian.com/browse/openjpa/tags/2.1.0/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/inheritance/polymorphic/TestTablePerClassInheritanceWithAbstractRoot.java?r=1071316
this testcase  (line 203). 

-mike

--
View this message in context: http://openjpa.208410.n2.nabble.com/SQL-generated-by-TYPE-function-tp6310346p6334495.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.