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>
|