From: <one...@us...> - 2003-03-01 06:14:17
|
Update of /cvsroot/hibernate/Hibernate2/src/net/sf/hibernate/test In directory sc8-pr-cvs1:/tmp/cvs-serv8308/sf/hibernate/test Modified Files: FooBarTest.java Log Message: outer join support in HQL Index: FooBarTest.java =================================================================== RCS file: /cvsroot/hibernate/Hibernate2/src/net/sf/hibernate/test/FooBarTest.java,v retrieving revision 1.30 retrieving revision 1.31 diff -C2 -d -r1.30 -r1.31 *** FooBarTest.java 1 Mar 2003 02:45:27 -0000 1.30 --- FooBarTest.java 1 Mar 2003 06:14:10 -0000 1.31 *************** *** 262,270 **** s.save(bar); ! s.find("select baz.name from Bar bar, bar.baz baz, baz.fooSet foo where baz.name = bar.string"); ! s.find("SELECT baz.name FROM Bar AS bar, bar.baz AS baz, baz.fooSet AS foo WHERE baz.name = bar.string"); ! s.find("select bar.string, foo.string from bar in class Bar, bar.baz as baz, elements(baz.fooSet) as foo where baz.name = 'name'"); ! s.find("select foo from bar in class Bar, bar.baz as baz, baz.fooSet as foo"); assertTrue( s.find("from bar in class Bar, foo in bar.baz.fooSet.elements").size()==0 ); --- 262,284 ---- s.save(bar); ! s.find("select baz.name from Bar bar inner join bar.baz baz inner join baz.fooSet foo where baz.name = bar.string"); ! s.find("SELECT baz.name FROM Bar AS bar INNER JOIN bar.baz AS baz INNER JOIN baz.fooSet AS foo WHERE baz.name = bar.string"); ! //s.find("select baz.name from Bar bar, bar.baz baz, baz.fooSet foo where baz.name = bar.string"); ! //s.find("SELECT baz.name FROM Bar AS bar, bar.baz AS baz, baz.fooSet AS foo WHERE baz.name = bar.string"); ! ! s.find("select baz.name from Bar bar left join bar.baz baz left join baz.fooSet foo where baz.name = bar.string"); ! s.find("select foo.string from Bar bar left join bar.baz.fooSet foo where bar.string = foo.string"); ! ! s.find("select baz.name from Bar bar left join bar.baz baz left join baz.fooArray foo where baz.name = bar.string"); ! s.find("select foo.string from Bar bar left join bar.baz.fooArray foo where bar.string = foo.string"); ! ! s.find("select bar.string, foo.string from bar in class Bar inner join bar.baz as baz inner join elements(baz.fooSet) as foo where baz.name = 'name'"); ! s.find("select foo from bar in class Bar inner join bar.baz as baz inner join baz.fooSet as foo"); ! s.find("select foo from bar in class Bar inner join bar.baz.fooSet as foo"); ! ! //s.find("select bar.string, foo.string from bar in class Bar, bar.baz as baz, elements(baz.fooSet) as foo where baz.name = 'name'"); ! //s.find("select foo from bar in class Bar, bar.baz as baz, baz.fooSet as foo"); ! //s.find("select foo from bar in class Bar, bar.baz.fooSet as foo"); assertTrue( s.find("from bar in class Bar, foo in bar.baz.fooSet.elements").size()==0 ); |