From: <one...@us...> - 2002-11-19 15:35:38
|
Update of /cvsroot/hibernate/Hibernate/doc/reference/src In directory sc8-pr-cvs1:/tmp/cvs-serv2395/doc/reference/src Modified Files: query_language.xml Log Message: allow not between, not in in query language allow subqueries beginning with a from clause in query language Index: query_language.xml =================================================================== RCS file: /cvsroot/hibernate/Hibernate/doc/reference/src/query_language.xml,v retrieving revision 1.20 retrieving revision 1.21 diff -C2 -d -r1.20 -r1.21 *** query_language.xml 28 Oct 2002 15:41:55 -0000 1.20 --- query_language.xml 19 Nov 2002 15:35:35 -0000 1.21 *************** *** 328,333 **** <para> ! <literal>in</literal> and <literal>between</literal> ! may be used as follows: </para> --- 328,332 ---- <para> ! <literal>in</literal> and <literal>between</literal> may be used as follows: </para> *************** *** 337,357 **** <para> ! but the negated forms should be written ! </para> ! ! <programlisting><![CDATA[from cat in class eg.DomesticCat where not cat.name between 'A' and 'B' ! ! from cat in class eg.DomesticCat where not cat.name in ( 'Foo', 'Bar', Baz" )]]></programlisting> ! ! <para> ! rather than </para> ! <programlisting><![CDATA[from cat in class eg.DomesticCat where cat.name not between 'A' and 'B' (Error) ! from cat in class eg.DomesticCat where cat.name not in ( 'Foo', 'Bar', Baz" ) (Error)]]></programlisting> <para> ! However, both <literal>is null</literal> and <literal>is not null</literal> may be used to test for null values. </para> --- 336,348 ---- <para> ! and the negated forms may be written </para> ! <programlisting><![CDATA[from cat in class eg.DomesticCat where cat.name not between 'A' and 'B' ! from cat in class eg.DomesticCat where cat.name not in ( 'Foo', 'Bar', Baz" )]]></programlisting> <para> ! Likewise, <literal>is null</literal> and <literal>is not null</literal> may be used to test for null values. </para> *************** *** 534,538 **** from cat in class eg.DomesticCat where cat.name = ! some( select list.name from list in class eg.NameList )]]></programlisting> </sect1> --- 525,532 ---- from cat in class eg.DomesticCat where cat.name = ! some( select list.name from list in class eg.NameList ) ! ! from cat in class eg.Cat where not exists ! ( from mate in class eg.Cat where mate.mate = cat )]]></programlisting> </sect1> |