[Hibernate-commits] Hibernate Code SVN: r9640 - trunk/HibernateExt/ejb/src/test/org/hibernate/ejb/test

[<hib...@li...>]

Author: epbernard
Date: 2006-03-16 16:46:33 -0500 (Thu, 16 Mar 2006)
New Revision: 9640

Modified:
   trunk/HibernateExt/ejb/src/test/org/hibernate/ejb/test/QueryTest.java
Log:
better test

Modified: trunk/HibernateExt/ejb/src/test/org/hibernate/ejb/test/QueryTest.java
===================================================================
--- trunk/HibernateExt/ejb/src/test/org/hibernate/ejb/test/QueryTest.java	2006-03-16 21:45:03 UTC (rev 9639)
+++ trunk/HibernateExt/ejb/src/test/org/hibernate/ejb/test/QueryTest.java	2006-03-16 21:46:33 UTC (rev 9640)
@@ -234,6 +234,37 @@
 		em.close();
 	}
 
+	public void testIsNull() throws Exception {
+		EntityManager em = factory.createEntityManager();
+		em.getTransaction().begin();
+		Distributor d1 = new Distributor();
+		d1.setName( "Fnac" );
+		Distributor d2  = new Distributor();
+		d2.setName( "Darty" );
+		Item item = new Item( "Mouse", null );
+		Item item2 = new Item( "Mouse2", "dd" );
+		item.getDistributors().add( d1 );
+		item.getDistributors().add( d2 );
+		em.persist( d1 );
+		em.persist( d2 );
+		em.persist( item );
+		em.persist( item2 );
+		em.flush();
+		em.clear();
+		Query q = em.createQuery( "select i from Item i where (i.descr is null and :descr is null) or i.descr = :descr");
+		//Query q = em.createQuery( "select i from Item i where (i.descr is null and :descr is null) or (i.descr = :descr");
+		q.setParameter( "descr", "dd" );
+		List result =  q.getResultList();
+		assertEquals( 1, result.size() );
+		q.setParameter( "descr", null );
+		result =  q.getResultList();
+		assertEquals( 1, result.size() );
+		//item = (Item) distinctResult.get( 0 );
+
+		em.getTransaction().rollback();
+		em.close();
+	}
+
 	public Class[] getAnnotatedClasses() {
 		return new Class[]{
 				Item.class,