File Doc Category Size Date Package
HQLTest.java API Doc Hibernate 3.2.5 63113 Fri Jun 08 14:21:58 BST 2007 org.hibernate.test.hql

HQLTest

java.lang.Object
- QueryTranslatorTestCase

public class HQLTest extends QueryTranslatorTestCase

Tests cases where the AST based query translator and the 'classic' query translator generate identical SQL.

author: Gavin King

Fields Summary
Constructors Summary
public HQLTest(String x)
super( x );
Methods Summary
private java.util.Map buildTrueFalseReplacementMapForDialect()
HashMap replacements = new HashMap(); try { String dialectTrueRepresentation = getDialect().toBooleanValueString( true ); // if this call succeeds, then the dialect is saying to represent true/false as int values... Integer.parseInt( dialectTrueRepresentation ); replacements.put( "true", "1" ); replacements.put( "false", "0" ); } catch( NumberFormatException nfe ) { // the Integer#parseInt call failed... } return replacements;
private void check(org.hibernate.engine.query.ReturnMetadata returnMetadata, boolean expectingEmptyTypes, boolean expectingEmptyAliases)
assertNotNull( "null return metadata", returnMetadata ); assertNotNull( "null return metadata - types", returnMetadata ); assertEquals( "unexpected return size", 1, returnMetadata.getReturnTypes().length ); if ( expectingEmptyTypes ) { assertNull( "non-empty types", returnMetadata.getReturnTypes()[0] ); } else { assertNotNull( "empty types", returnMetadata.getReturnTypes()[0] ); } if ( expectingEmptyAliases ) { assertNull( "non-empty aliases", returnMetadata.getReturnAliases() ); } else { assertNotNull( "empty aliases", returnMetadata.getReturnAliases() ); assertNotNull( "empty aliases", returnMetadata.getReturnAliases()[0] ); }
protected void cleanupTest()
SelectClause.VERSION2_SQL = false; DotNode.REGRESSION_STYLE_JOIN_SUPPRESSION = false; DotNode.ILLEGAL_COLL_DEREF_EXCP_BUILDER = DotNode.DEF_ILLEGAL_COLL_DEREF_EXCP_BUILDER; super.cleanupTest();
private void compileWithAstQueryTranslator(java.lang.String hql, boolean scalar)
Map replacements = new HashMap(); QueryTranslatorFactory ast = new ASTQueryTranslatorFactory(); SessionFactoryImplementor factory = getSessionFactoryImplementor(); QueryTranslator newQueryTranslator = ast.createQueryTranslator( hql, hql, Collections.EMPTY_MAP, factory ); newQueryTranslator.compile( replacements, scalar );
public boolean createSchema()
return false;
protected void prepareTest()
super.prepareTest(); SelectClause.VERSION2_SQL = true; DotNode.REGRESSION_STYLE_JOIN_SUPPRESSION = true; DotNode.ILLEGAL_COLL_DEREF_EXCP_BUILDER = new DotNode.IllegalCollectionDereferenceExceptionBuilder() { public QueryException buildIllegalCollectionDereferenceException(String propertyName, FromReferenceNode lhs) { throw new QueryException( "illegal syntax near collection: " + propertyName ); } };
public boolean recreateSchemaAfterFailure()
return false;
public void selectWhereElements()
assertTranslation( "select foo from Foo foo, Baz baz where foo in elements(baz.fooArray)" );
public static junit.framework.Test suite()
return new FunctionalTestClassTestSuite( HQLTest.class );
public void testAggregation()
assertTranslation( "select count(an) from Animal an" ); assertTranslation( "select count(*) from Animal an" ); assertTranslation( "select count(distinct an) from Animal an" ); assertTranslation( "select count(distinct an.id) from Animal an" ); assertTranslation( "select count(all an.id) from Animal an" );
public void testAssociationPropertyWithoutAlias()
// The classic translator doesn't do this right, so don't bother asserting. compileWithAstQueryTranslator("from Animal where zoo is null", false);
public void testCaseExprWhenElse()
assertTranslation( "from Human h where case h.nickName when '1ovthafew' then 'Gavin' when 'turin' then 'Christian' else h.nickName end = h.name.first" );
public void testCaseWhenElse()
assertTranslation( "from Human h where case when h.nickName='1ovthafew' then 'Gavin' when h.nickName='turin' then 'Christian' else h.nickName end = h.name.first" );
public void testClassName()
// The Zoo reference is OK; Zoo is discriminator-based; // the old parser could handle these correctly // // However, the Animal one ares not; Animal is joined subclassing; // the old parser does not handle thee correctly. The new parser // previously did not handle them correctly in that same way. So they // used to pass regression even though the output was bogus SQL... // // I have moved the Animal ones (plus duplicating the Zoo one) // to ASTParserLoadingTest for syntax checking. assertTranslation( "from Zoo zoo where zoo.class = PettingZoo" ); // assertTranslation( "from DomesticAnimal an where an.class = Dog" ); // assertTranslation( "from Animal an where an.class = Dog" );
public void testClassProperty()
// This test causes failures on theta-join dialects because the SQL is different. // The queries are semantically the same however. if ( getDialect() instanceof Oracle9Dialect ) return; if ( getDialect() instanceof Oracle8iDialect ) return; assertTranslation( "from Animal a where a.mother.class = Reptile" );
public void testCollectionElementInWhere()
assertTranslation( "from Zoo zoo where 4 > some elements(zoo.animals)" ); assertTranslation( "from Zoo zoo where 4 > all elements(zoo.animals)" );
public void testCollectionFetchWithExplicitThetaJoin()
assertTranslation( "select m from Master m1, Master m left join fetch m.details where m.name=m1.name" );
public void testCollectionFunctions()
//these are both broken, a join that belongs in the subselect finds its way into the main query assertTranslation( "from Zoo zoo where size(zoo.animals) > 100" ); assertTranslation( "from Zoo zoo where maxindex(zoo.mammals) = 'dog'" );
public void testCollectionIndexFunctionsInWhere()
assertTranslation( "from Zoo zoo where 4 = maxindex(zoo.animals)" ); assertTranslation( "from Zoo zoo where 2 = minindex(zoo.animals)" );
public void testCollectionIndicesInWhere()
assertTranslation( "from Zoo zoo where 4 > some indices(zoo.animals)" ); assertTranslation( "from Zoo zoo where 4 > all indices(zoo.animals)" );
public void testCollectionJoinsInSubselect()
// caused by some goofiness in FromElementFactory that tries to // handle correlated subqueries (but fails miserably) even though this // is not a correlated subquery. HHH-1248 assertTranslation( "select a.id, a.description" + " from Animal a" + " left join a.offspring" + " where a in (" + " select a1 from Animal a1" + " left join a1.offspring o" + " where a1.id=1" + ")" ); assertTranslation( "select h.id, h.description" + " from Human h" + " left join h.friends" + " where h in (" + " select h1" + " from Human h1" + " left join h1.friends f" + " where h1.id=1" + ")" );
public void testCollectionOfComponents()
assertTranslation( "from Baz baz inner join baz.components comp where comp.name='foo'" );
public void testCollectionOfValues()
//old parser had a bug where the collection element was not returned! //TODO: broken on dialects with theta-style joins // steve (2005.10.06) - this works perfectly for me on Oracle8i assertTranslation( "from Baz baz join baz.stringDateMap date where index(date) = 'foo'" );
public void testCollectionOfValuesSize()
//SQL *was* missing a comma assertTranslation( "select size(baz.stringDateMap) from org.hibernate.test.legacy.Baz baz" );
public void testCollectionOrderBy()
assertTranslation("from Animal a join a.offspring o order by a.description"); assertTranslation("from Animal a join fetch a.offspring order by a.description"); assertTranslation("from Animal a join fetch a.offspring o order by o.description"); assertTranslation("from Animal a join a.offspring o order by a.description, o.description");
public void testCollectionSize()
//SQL is correct, query spaces *was* missing a table assertTranslation( "select size(zoo.animals) from Zoo zoo" );
public void testCollectionsInSelect2()
// This one looks okay now, it just generates extra parens in the where clause. assertTranslation( "select foo.string from Bar bar left join bar.baz.fooArray foo where bar.string = foo.string" );
public void testComplexExpressionInFunction()
assertTranslation( "from Animal an where an.bodyWeight > abs((3-5)/4)" );
public void testComponent()
assertTranslation( "from Human h where h.name.first = 'Gavin'" );
public void testComponent2()
assertTranslation( "from Dog dog where dog.owner.name.first = 'Gavin'" );
public void testComponentManyToOneDereferenceShortcut()
assertTranslation( "from Zoo z where z.address.stateProvince.id is null" );
public void testComponentNoAlias()
// The classic translator doesn't do this right, so don't bother asserting. compileWithAstQueryTranslator( "from Human where name.first = 'Gavin'", false);
public void testCompositeKeysWithPropertyNamedId()
assertTranslation( "select e.id.id from EntityWithCrazyCompositeKey e" ); assertTranslation( "select max(e.id.id) from EntityWithCrazyCompositeKey e" );
public void testConcatenation()
if ( getDialect() instanceof MySQLDialect || getDialect() instanceof SybaseDialect ) { // MySQL uses concat(x, y, z) // SQL Server replaces '||' with '+' // // this is syntax checked in {@link ASTParserLoadingTest#testConcatenation} return; } assertTranslation("from Human h where h.nickName = '1' || 'ov' || 'tha' || 'few'");
public void testConstructorNode()
ConstructorNode n = new ConstructorNode(); assertNull( n.getFromElement() ); assertFalse( n.isReturnableEntity() );
public void testCorrelatedSubselect1()
// The old translator generates the theta join before the condition in the sub query. // TODO: Decide if we want to bother generating the theta join in the same order (non simple). assertTranslation( "from Animal a where exists (from a.offspring o where o.bodyWeight>10)" );
public void testCorrelatedSubselect2()
assertTranslation( "from Animal a where a.bodyWeight > (select max(o.bodyWeight) from a.offspring o)" );
public void testCrazyIdFieldNames()
DotNode.useThetaStyleImplicitJoins = true; // only regress against non-scalar forms as there appears to be a bug in the classic translator // in regards to this issue also. Specifically, it interprets the wrong return type, though it gets // the sql "correct" :/ String hql = "select e.heresAnotherCrazyIdFieldName from MoreCrazyIdFieldNameStuffEntity e where e.heresAnotherCrazyIdFieldName is not null"; assertTranslation( hql, new HashMap(), false, ( String ) null ); hql = "select e.heresAnotherCrazyIdFieldName.heresAnotherCrazyIdFieldName from MoreCrazyIdFieldNameStuffEntity e where e.heresAnotherCrazyIdFieldName is not null"; assertTranslation( hql, new HashMap(), false, ( String ) null ); DotNode.useThetaStyleImplicitJoins = false;
public void testDateTimeArithmeticReturnTypesAndParameterGuessing()
QueryTranslatorImpl translator = createNewQueryTranslator( "select o.orderDate - o.orderDate from Order o" ); assertEquals( "incorrect return type count", 1, translator.getReturnTypes().length ); assertEquals( "incorrect return type", Hibernate.DOUBLE, translator.getReturnTypes()[0] ); translator = createNewQueryTranslator( "select o.orderDate + 2 from Order o" ); assertEquals( "incorrect return type count", 1, translator.getReturnTypes().length ); assertEquals( "incorrect return type", Hibernate.CALENDAR_DATE, translator.getReturnTypes()[0] ); translator = createNewQueryTranslator( "select o.orderDate -2 from Order o" ); assertEquals( "incorrect return type count", 1, translator.getReturnTypes().length ); assertEquals( "incorrect return type", Hibernate.CALENDAR_DATE, translator.getReturnTypes()[0] ); translator = createNewQueryTranslator( "from Order o where o.orderDate > ?" ); assertEquals( "incorrect expected param type", Hibernate.CALENDAR_DATE, translator.getParameterTranslations().getOrdinalParameterExpectedType( 1 ) ); translator = createNewQueryTranslator( "select o.orderDate + ? from Order o" ); assertEquals( "incorrect return type count", 1, translator.getReturnTypes().length ); assertEquals( "incorrect return type", Hibernate.CALENDAR_DATE, translator.getReturnTypes()[0] ); assertEquals( "incorrect expected param type", Hibernate.DOUBLE, translator.getParameterTranslations().getOrdinalParameterExpectedType( 1 ) );
public void testDotComponent()
// from FumTest.testListIdentifiers() assertTranslation( "select fum.id from org.hibernate.test.legacy.Fum as fum where not fum.fum='FRIEND'" );
public void testDuplicateExplicitJoinFailureExpected()
//very minor issue with select clause: assertTranslation( "from Animal a join a.mother m1 join a.mother m2" ); assertTranslation( "from Zoo zoo join zoo.animals an join zoo.mammals m" ); assertTranslation( "from Zoo zoo join zoo.mammals an join zoo.mammals m" );
public void testDuplicateImplicitJoinInSelect()
// This test causes failures on theta-join dialects because the SQL is different. The old parser // duplicates the condition, whereas the new parser does not. The queries are semantically the // same however. if ( getDialect() instanceof Oracle9Dialect ) return; if ( getDialect() instanceof Oracle8iDialect ) return; assertTranslation( "select an.mother.bodyWeight from Animal an join an.mother m where an.mother.bodyWeight > 10" ); assertTranslation( "select an.mother.bodyWeight from Animal an where an.mother.bodyWeight > 10" ); //assertTranslation("select an.mother from Animal an where an.mother.bodyWeight is not null"); assertTranslation( "select an.mother.bodyWeight from Animal an order by an.mother.bodyWeight" );
public void testElementsInWhere()
assertTranslation( "from Zoo zoo where 4 in elements(zoo.animals)" ); assertTranslation( "from Zoo zoo where exists elements(zoo.animals)" );
public void testEmptyInListFailureExpected()
assertTranslation( "select a from Animal a where a.description in ()" );
public void testEscapedQuote()
assertTranslation( "from Human h where h.nickName='1 ov''tha''few'");
public void testExceptions()
DetailedSemanticException dse = new DetailedSemanticException( "test" ); dse.printStackTrace(); dse.printStackTrace( new PrintWriter( new StringWriter() ) ); QuerySyntaxException qse = QuerySyntaxException.convert( new RecognitionException( "test" ), "from bozo b where b.clown = true" ); assertNotNull( qse.getMessage() );
public void testExplicitCollectionJoins()
assertTranslation( "from Animal an inner join an.offspring os" ); assertTranslation( "from Animal an left outer join an.offspring os" );
public void testExplicitEntityJoins()
assertTranslation( "from Animal an inner join an.mother mo" ); assertTranslation( "from Animal an left outer join an.mother mo" ); assertTranslation( "from Animal an left outer join fetch an.mother" );
public void testExplicitEntityJoinsWithRestriction()
assertTranslation( "from Animal an inner join an.mother mo where an.bodyWeight < mo.bodyWeight" );
public void testExplicitJoinMapIndex()
//TODO: this breaks on dialects with theta-style outerjoins: // steve (2005.10.06) - this works perfectly for me on Oracle8i assertTranslation( "from Zoo zoo, Dog dog where zoo.mammals['dog'] = dog" ); assertTranslation( "from Zoo zoo join zoo.mammals dog where zoo.mammals['dog'] = dog" );
public void testExplicitJoins()
Map replacements = buildTrueFalseReplacementMapForDialect(); assertTranslation( "from Zoo zoo join zoo.mammals mam where mam.pregnant = true and mam.description like '%white%'", replacements ); assertTranslation( "from Zoo zoo join zoo.animals an where an.description like '%white%'" );
public void testExplicitJoinsInSubquery()
// test for HHH-557, // TODO : this passes regardless because the only difference between the two sqls is one extra comma // (commas are eaten by the tokenizer during asserTranslation when building the token maps). assertTranslation( "from org.hibernate.test.hql.Animal as animal " + "where animal.id in (" + " select a.id " + " from org.hibernate.test.hql.Animal as a " + " left join a.mother as mo" + ")" );
public void testExplicitOuterJoinFetch()
assertTranslation( "from Animal an left outer join fetch an.offspring" );
public void testExplicitOuterJoinFetchWithSelect()
assertTranslation( "select an from Animal an left outer join fetch an.offspring" );
public void testExpressionInFunction()
assertTranslation( "from Animal an where an.bodyWeight > abs(3-5)" ); assertTranslation( "from Animal an where an.bodyWeight > abs(3/5)" ); assertTranslation( "from Animal an where an.bodyWeight > abs(3+5)" ); assertTranslation( "from Animal an where an.bodyWeight > abs(3*5)" ); SQLFunction concat = getSessionFactoryImplementor().getSqlFunctionRegistry().findSQLFunction( "concat"); List list = new ArrayList(); list.add("'fat'"); list.add("'skinny'"); assertTranslation( "from Animal an where an.description = " + concat.render(list, getSessionFactoryImplementor()) );
public void testExpressionWithParamInFunction()
assertTranslation("from Animal a where abs(a.bodyWeight-:param) < 2.0"); assertTranslation("from Animal a where abs(:param - a.bodyWeight) < 2.0"); assertTranslation("from Animal where abs(:x - :y) < 2.0"); assertTranslation("from Animal where lower(upper(:foo)) like 'f%'"); if ( ! ( getDialect() instanceof SybaseDialect ) ) { // SybaseDialect maps the length function -> len; classic translator does not consider that *when nested* assertTranslation("from Animal a where abs(abs(a.bodyWeight - 1.0 + :param) * abs(length('ffobar')-3)) = 3.0"); } if ( !( getDialect() instanceof MySQLDialect || getDialect() instanceof SybaseDialect ) ) { assertTranslation("from Animal where lower(upper('foo') || upper(:bar)) like 'f%'"); } if ( getDialect() instanceof PostgreSQLDialect ) { return; } assertTranslation("from Animal where abs(cast(1 as float) - cast(:param as float)) = 1.0");
public void testFetch()
assertTranslation( "from Zoo zoo left join zoo.mammals" ); assertTranslation( "from Zoo zoo left join fetch zoo.mammals" );
public void testFetchCollectionOfValues()
assertTranslation( "from Baz baz left join fetch baz.stringSet" );
public void testFetchList()
assertTranslation( "from User u join fetch u.permissions" );
public void testFetchOrderBy()
assertTranslation("from Animal a left outer join fetch a.offspring where a.mother.id = :mid order by a.description");
public void testFromClauseImplicitJoin()
assertTranslation( "from DomesticAnimal da join da.owner.mother m where m.bodyWeight > 10" );
public void testFromOnly()
// 2004-06-21 [jsd] This test now works with the new AST based QueryTranslatorImpl. assertTranslation( "from Animal" ); assertTranslation( "from Model" );
public void testGroupBy()
assertTranslation( "select an.mother.id, max(an.bodyWeight) from Animal an group by an.mother.id" ); assertTranslation( "select an.mother.id, max(an.bodyWeight) from Animal an group by an.mother.id having max(an.bodyWeight)>1.0" );
public void testGroupByFunction()
if ( getDialect() instanceof Oracle9Dialect ) return; if ( getDialect() instanceof Oracle8iDialect ) return; // the new hiearchy... if ( getDialect() instanceof PostgreSQLDialect ) return; assertTranslation( "select count(*) from Human h group by year(h.birthdate)" ); assertTranslation( "select count(*) from Human h group by trunc( sqrt(h.bodyWeight*4)/2 )" ); assertTranslation( "select count(*) from Human h group by year(sysdate)" );
public void testGroupByMultiple()
assertTranslation( "select s.id, s.count, count(t), max(t.date) from org.hibernate.test.legacy.Simple s, org.hibernate.test.legacy.Simple t where s.count = t.count group by s.id, s.count order by s.count" );
public void testHHH719()
assertTranslation("from Baz b order by org.bazco.SpecialFunction(b.id)"); assertTranslation("from Baz b order by anypackage.anyFunction(b.id)");
public void testHavingCount()
assertTranslation( "from Animal an group by an.zoo.id having count(an.zoo.id) > 1" );
public void testIdProperty()
assertTranslation( "from Animal a where a.mother.id = 12" );
public void testImplicitJoinContainedByCollectionFunction()
// HHH-281 : Implied joins in a collection function (i.e., indices or elements) assertTranslation( "from Human as h where 'shipping' in indices(h.father.addresses)" ); assertTranslation( "from Human as h where 'shipping' in indices(h.father.father.addresses)" ); assertTranslation( "from Human as h where 'sparky' in elements(h.father.nickNames)" ); assertTranslation( "from Human as h where 'sparky' in elements(h.father.father.nickNames)" );
public void testImplicitJoinInExplicitJoin()
assertTranslation( "from Animal an inner join an.mother.mother gm" ); assertTranslation( "from Animal an inner join an.mother.mother.mother ggm" ); assertTranslation( "from Animal an inner join an.mother.mother.mother.mother gggm" );
public void testImplicitJoinInFrom()
assertTranslation( "from Human h join h.mother.mother.offspring o" );
public void testImplicitJoinInSelect()
assertTranslation( "select foo, foo.long from Foo foo" ); DotNode.useThetaStyleImplicitJoins = true; assertTranslation( "select foo.foo from Foo foo" ); assertTranslation( "select foo, foo.foo from Foo foo" ); assertTranslation( "select foo.foo from Foo foo where foo.foo is not null" ); DotNode.useThetaStyleImplicitJoins = false;
public void testImplicitJoinInSubselect()
assertTranslation( "from Animal a where a = (select an.mother from Animal an)" ); assertTranslation( "from Animal a where a.id = (select an.mother.id from Animal an)" );
public void testImplicitJoins()
// Two dots... assertTranslation( "from Animal an where an.mother.bodyWeight > ?" ); assertTranslation( "from Animal an where an.mother.bodyWeight > 10" ); assertTranslation( "from Dog dog where dog.mother.bodyWeight > 10" ); // Three dots... assertTranslation( "from Animal an where an.mother.mother.bodyWeight > 10" ); // The new QT doesn't throw an exception here, so this belongs in ASTQueryTranslator test. [jsd] // assertTranslation( "from Animal an where an.offspring.mother.bodyWeight > 10" ); // Is not null (unary postfix operator) assertTranslation( "from Animal an where an.mother is not null" ); // ID property shortut (no implicit join) assertTranslation( "from Animal an where an.mother.id = 123" );
public void testImplicitJoinsAlongWithCartesianProduct()
DotNode.useThetaStyleImplicitJoins = true; assertTranslation( "select foo.foo from Foo foo, Foo foo2" ); assertTranslation( "select foo.foo.foo from Foo foo, Foo foo2" ); DotNode.useThetaStyleImplicitJoins = false;
public void testImplicitJoinsInGroupBy()
assertTranslation( "select o.mother.bodyWeight, count(distinct o) " + "from Animal an " + " join an.offspring as o " + "group by o.mother.bodyWeight" );
public void testImpliedJoinInSubselectFrom()
// HHH-276 : Implied joins in a from in a subselect. assertTranslation( "from Animal a where exists( from a.mother.offspring )" );
public void testImpliedManyToManyProperty()
//missing a table join (SQL correct for a one-to-many, not for a many-to-many) assertTranslation( "select c from ContainerX c where c.manyToMany[0].name = 's'" );
public void testImpliedSelect()
assertTranslation( "select zoo from Zoo zoo" ); assertTranslation( "from Zoo zoo" ); assertTranslation( "from Zoo zoo join zoo.mammals m" ); assertTranslation( "from Zoo" ); assertTranslation( "from Zoo zoo join zoo.mammals" );
public void testIndexFunction()
// Instead of doing the pre-processor trick like the existing QueryTranslator, this // is handled by MethodNode. // steve (2005.10.06) - this works perfectly for me on Oracle8i //TODO: broken on dialects with theta-style outerjoins: assertTranslation( "from Zoo zoo join zoo.mammals dog where index(dog) = 'dog'" ); assertTranslation( "from Zoo zoo join zoo.animals an where index(an) = '1234'" );
public void testIndexNode()
IndexNode n = new IndexNode(); Exception ex = null; try { n.setScalarColumnText( 0 ); } catch ( UnsupportedOperationException e ) { ex = e; } assertNotNull( ex );
public void testIndexWithExplicitJoin()
//TODO: broken on dialects with theta-style outerjoins: // steve (2005.10.06) - this works perfectly for me on Oracle8i assertTranslation( "from Zoo zoo join zoo.animals an where zoo.mammals[ index(an) ] = an" ); assertTranslation( "from Zoo zoo join zoo.mammals dog where zoo.mammals[ index(dog) ] = dog" ); assertTranslation( "from Zoo zoo join zoo.mammals dog where dog = zoo.mammals[ index(dog) ]" );
public void testIndicesInWhere()
assertTranslation( "from Zoo zoo where 4 in indices(zoo.animals)" ); assertTranslation( "from Zoo zoo where exists indices(zoo.animals)" );
public void testInvalidCollectionDereferencesFail()
// should fail with the same exceptions (because of the DotNode.ILLEGAL_COLL_DEREF_EXCP_BUILDER) assertTranslation( "from Animal a where a.offspring.description = 'xyz'" ); assertTranslation( "from Animal a where a.offspring.father.description = 'xyz'" );
public void testInvalidHql()
Exception newException = compileBadHql( "from Animal foo where an.bodyWeight > 10", false ); assertTrue( "Wrong exception type!", newException instanceof QuerySyntaxException ); newException = compileBadHql( "select an.name from Animal foo", false ); assertTrue( "Wrong exception type!", newException instanceof QuerySyntaxException ); newException = compileBadHql( "from Animal foo where an.verybogus > 10", false ); assertTrue( "Wrong exception type!", newException instanceof QuerySyntaxException ); newException = compileBadHql( "select an.boguspropertyname from Animal foo", false ); assertTrue( "Wrong exception type!", newException instanceof QuerySyntaxException ); newException = compileBadHql( "select an.name", false ); assertTrue( "Wrong exception type!", newException instanceof QuerySyntaxException ); newException = compileBadHql( "from Animal an where (((an.bodyWeight > 10 and an.bodyWeight < 100)) or an.bodyWeight is null", false ); assertTrue( "Wrong exception type!", newException instanceof QuerySyntaxException ); newException = compileBadHql( "from Animal an where an.bodyWeight is null where an.bodyWeight is null", false ); assertTrue( "Wrong exception type!", newException instanceof QuerySyntaxException ); newException = compileBadHql( "from where name='foo'", false ); assertTrue( "Wrong exception type!", newException instanceof QuerySyntaxException ); newException = compileBadHql( "from NonexistentClass where name='foo'", false ); assertTrue( "Wrong exception type!", newException instanceof QuerySyntaxException ); newException = compileBadHql( "select new FOO_BOGUS_Animal(an.description, an.bodyWeight) from Animal an", false ); assertTrue( "Wrong exception type!", newException instanceof QuerySyntaxException ); newException = compileBadHql( "select new Animal(an.description, an.bodyWeight, 666) from Animal an", false ); assertTrue( "Wrong exception type!", newException instanceof QuerySyntaxException );
public void testJavaConstant()
assertTranslation( "from org.hibernate.test.legacy.Category c where c.name = org.hibernate.test.legacy.Category.ROOT_CATEGORY" ); assertTranslation( "from org.hibernate.test.legacy.Category c where c.id = org.hibernate.test.legacy.Category.ROOT_ID" ); // todo : additional desired functionality //assertTranslation( "from Category c where c.name = Category.ROOT_CATEGORY" ); //assertTranslation( "select c.name, Category.ROOT_ID from Category as c");
public void testJoinFetchCollectionOfValues()
assertTranslation( "select h from Human as h join fetch h.nickNames" );
public void testJoinInSubselect()
//new parser uses ANSI-style inner join syntax DotNode.useThetaStyleImplicitJoins = true; assertTranslation( "from Animal a where a in (select m from Animal an join an.mother m)" ); assertTranslation( "from Animal a where a in (select o from Animal an join an.offspring o)" ); DotNode.useThetaStyleImplicitJoins = false;
public void testJoinPathEndingInValueCollection()
assertTranslation( "select h from Human as h join h.nickNames as nn where h.nickName=:nn1 and (nn=:nn2 or nn=:nn3)" );
public void testJoinedSubclassImplicitJoin()
// From MultiTableTest.testQueries() // TODO: This produces the proper from clause now, but the parens in the where clause are different. assertTranslation( "from org.hibernate.test.legacy.Lower s where s.yetanother.name='name'" );
public void testJoinedSubclassProduct()
assertTranslation( "from PettingZoo, PettingZoo" ); //product of two subclasses
public void testJoinedSubclassWithOrCondition()
assertTranslation( "from Animal an where (an.bodyWeight > 10 and an.bodyWeight < 100) or an.bodyWeight is null" );
public void testKeyManyToOneJoinFailureExpected()
//TODO: new parser generates unnecessary joins (though the query results are correct) assertTranslation( "from Order o left join fetch o.lineItems li left join fetch li.product p" ); assertTranslation( "from Outer o where o.id.master.id.sup.dudu is not null" ); assertTranslation( "from Outer o where o.id.master.id.sup.dudu is not null" );
public void testKeywordPropertyName()
assertTranslation( "from Glarch g order by g.order asc" ); assertTranslation( "select g.order from Glarch g where g.order = 3" );
public void testListElementFunctionInWhere()
assertTranslation( "from User u where 'read' in elements(u.permissions)" ); assertTranslation( "from User u where 'write' <> all elements(u.permissions)" );
public void testLiteralInFunction()
assertTranslation( "from Animal an where an.bodyWeight > abs(5)" ); assertTranslation( "from Animal an where an.bodyWeight > abs(-5)" );
public void testManyToAnyReferences()
assertTranslation( "from PropertySet p where p.someSpecificProperty.id is not null" ); assertTranslation( "from PropertySet p join p.generalProperties gp where gp.id is not null" );
public void testManyToMany()
assertTranslation( "from Human h join h.friends f where f.nickName = 'Gavin'" ); assertTranslation( "from Human h join h.friends f where f.bodyWeight > 100" );
public void testManyToManyElementFunctionInWhere()
assertTranslation( "from Human human where human in elements(human.friends)" ); assertTranslation( "from Human human where human = some elements(human.friends)" );
public void testManyToManyElementFunctionInWhere2()
assertTranslation( "from Human h1, Human h2 where h2 in elements(h1.family)" ); assertTranslation( "from Human h1, Human h2 where 'father' in indices(h1.family)" );
public void testManyToManyFetch()
assertTranslation( "from Human h left join fetch h.friends" );
public void testManyToManyInJoin()
assertTranslation( "select x.id from Human h1 join h1.family x" ); //assertTranslation("select index(h2) from Human h1 join h1.family h2");
public void testManyToManyInSubselect()
assertTranslation( "from Human h1, Human h2 where h2 in (select x.id from h1.family x)" ); assertTranslation( "from Human h1, Human h2 where 'father' in indices(h1.family)" );
public void testManyToManyIndexAccessor()
// From ParentChildTest.testCollectionQuery() assertTranslation( "select c from ContainerX c, Simple s where c.manyToMany[2] = s" ); assertTranslation( "select s from ContainerX c, Simple s where c.manyToMany[2] = s" ); assertTranslation( "from ContainerX c, Simple s where c.manyToMany[2] = s" ); //would be nice to have: //assertTranslation( "select c.manyToMany[2] from ContainerX c" );
public void testManyToManyJoinInSubselect()
DotNode.useThetaStyleImplicitJoins = true; assertTranslation( "select foo from Foo foo where foo in (select elt from Baz baz join baz.fooArray elt)" ); DotNode.useThetaStyleImplicitJoins = false;
public void testManyToManyMaxElementFunctionInWhere()
//completely broken!! assertTranslation( "from Human human where 5 = maxelement(human.friends)" );
public void testManyToOneSubselect()
//TODO: the join in the subselect also shows up in the outer query! assertTranslation( "from Animal a where 'foo' in (select m.description from a.mother m)" );
public void testMapIndex()
assertTranslation( "from User u where u.permissions['hibernate']='read'" );
public void testMaxindexHqlFunctionInElementAccessorFailureExpected()
//TODO: broken SQL // steve (2005.10.06) - this is perfect SQL, but fairly different from the old parser // tested : HSQLDB (1.8), Oracle8i assertTranslation( "select c from ContainerX c where c.manyToMany[ maxindex(c.manyToMany) ].count = 2" ); assertTranslation( "select c from Container c where c.manyToMany[ maxIndex(c.manyToMany) ].count = 2" );
public void testMultibyteCharacterConstant()
Test for HHH-559
assertTranslation( "from Zoo zoo join zoo.animals an where an.description like '%\u4e2d%'" );
public void testMultipleElementAccessorOperatorsFailureExpected()
//TODO: broken SQL // steve (2005.10.06) - Yes, this is all hosed ;) assertTranslation( "select c from ContainerX c where c.oneToMany[ c.manyToMany[0].count ].name = 's'" ); assertTranslation( "select c from ContainerX c where c.manyToMany[ c.oneToMany[0].count ].name = 's'" );
public void testMultipleExplicitCollectionJoins()
assertTranslation( "from Animal an inner join an.offspring os join os.offspring gc" ); assertTranslation( "from Animal an left outer join an.offspring os left outer join os.offspring gc" );
public void testMultipleExplicitEntityJoins()
assertTranslation( "from Animal an inner join an.mother mo inner join mo.mother gm" ); assertTranslation( "from Animal an left outer join an.mother mo left outer join mo.mother gm" ); assertTranslation( "from Animal an inner join an.mother m inner join an.father f" ); assertTranslation( "from Animal an left join fetch an.mother m left join fetch an.father f" );
public void testMultipleExplicitJoins()
assertTranslation( "from Animal an inner join an.mother mo inner join an.offspring os" ); assertTranslation( "from Animal an left outer join an.mother mo left outer join an.offspring os" );
public void testNamedParameters()
assertTranslation( "from Animal an where an.mother.bodyWeight > :weight" );
public void testNestedCollectionImplicitJoins()
// HHH-770 assertTranslation( "select h.friends.offspring from Human h" );
public void testNestedComponent()
// From FooBarTest.testQuery() //an extra set of parens in new SQL assertTranslation( "from org.hibernate.test.legacy.Foo foo where foo.component.subcomponent.name='bar'" );
public void testNestedComponentIsNull()
// From MapTest... assertTranslation( "from Commento c where c.marelo.commento.mcompr is null" );
public void testNestedImplicitJoinsInSelect()
// NOTE: This test is not likely to generate the exact SQL because of the where clause. The synthetic // theta style joins come out differently in the new QT. // From FooBarTest.testQuery() // Missing the foo2_ join, and foo3_ should include subclasses, but it doesn't. // assertTranslation("select foo.foo.foo.foo.string from org.hibernate.test.legacy.Foo foo where foo.foo.foo = 'bar'"); assertTranslation( "select foo.foo.foo.foo.string from org.hibernate.test.legacy.Foo foo" );
public void testNotOrWhereClause()
assertTranslation( "from Simple s where 'foo'='bar' or not 'foo'='foo'" ); assertTranslation( "from Simple s where 'foo'='bar' or not ('foo'='foo')" ); assertTranslation( "from Simple s where not ( 'foo'='bar' or 'foo'='foo' )" ); assertTranslation( "from Simple s where not ( 'foo'='bar' and 'foo'='foo' )" ); assertTranslation( "from Simple s where not ( 'foo'='bar' and 'foo'='foo' ) or not ('x'='y')" ); assertTranslation( "from Simple s where not ( 'foo'='bar' or 'foo'='foo' ) and not ('x'='y')" ); assertTranslation( "from Simple s where not ( 'foo'='bar' or 'foo'='foo' ) and 'x'='y'" ); assertTranslation( "from Simple s where not ( 'foo'='bar' and 'foo'='foo' ) or 'x'='y'" ); assertTranslation( "from Simple s where 'foo'='bar' and 'foo'='foo' or not 'x'='y'" ); assertTranslation( "from Simple s where 'foo'='bar' or 'foo'='foo' and not 'x'='y'" ); assertTranslation( "from Simple s where ('foo'='bar' and 'foo'='foo') or 'x'='y'" ); assertTranslation( "from Simple s where ('foo'='bar' or 'foo'='foo') and 'x'='y'" ); assertTranslation( "from Simple s where not( upper( s.name ) ='yada' or 1=2 or 'foo'='bar' or not('foo'='foo') or 'foo' like 'bar' )" );
public void testNull()
assertTranslation( "from Human h where h.nickName is null" ); assertTranslation( "from Human h where h.nickName is not null" );
public void testNull2()
//old parser generates useless extra parens assertTranslation( "from Human h where not( h.nickName is null )" ); assertTranslation( "from Human h where not( h.nickName is not null )" );
public void testOneToManyElementFunctionInWhere()
assertTranslation( "from Zoo zoo where 'dog' in indices(zoo.mammals)" ); assertTranslation( "from Zoo zoo, Dog dog where dog in elements(zoo.mammals)" );
public void testOneToManyIndexAccess()
assertTranslation( "from Zoo zoo where zoo.mammals['dog'] is not null" );
public void testOneToManyMapIndex()
//TODO: this breaks on dialects with theta-style outerjoins: // steve (2005.10.06) - this works perfectly for me on Oracle8i assertTranslation( "from Zoo zoo where zoo.mammals['dog'].description like '%black%'" ); assertTranslation( "from Zoo zoo where zoo.mammals['dog'].father.description like '%black%'" ); assertTranslation( "from Zoo zoo where zoo.mammals['dog'].father.id = 1234" ); assertTranslation( "from Zoo zoo where zoo.animals['1234'].description like '%black%'" );
public void testOneToOne()
assertTranslation( "from User u where u.human.nickName='Steve'" ); assertTranslation( "from User u where u.human.name.first='Steve'" );
public void testOneToOneJoinedFetch()
// From OneToOneTest.testOneToOneOnSubclass assertTranslation( "from org.hibernate.test.onetoone.joined.Person p join fetch p.address left join fetch p.mailingAddress" );
public void testOrderBy()
assertTranslation( "from Animal an order by an.bodyWeight" ); assertTranslation( "from Animal an order by an.bodyWeight asc" ); assertTranslation( "from Animal an order by an.bodyWeight desc" ); assertTranslation( "from Animal an order by sqrt(an.bodyWeight*4)/2" ); assertTranslation( "from Animal an order by an.mother.bodyWeight" ); assertTranslation( "from Animal an order by an.bodyWeight, an.description" ); assertTranslation( "from Animal an order by an.bodyWeight asc, an.description desc" ); if ( getDialect() instanceof HSQLDialect || getDialect() instanceof DB2Dialect ) { assertTranslation( "from Human h order by sqrt(h.bodyWeight), year(h.birthdate)" ); }
public void testOrderByCount()
assertTranslation( "from Animal an group by an.zoo.id order by an.zoo.id, count(*)" );
public void testOuterAliasInSubselect()
assertTranslation( "from Human h where h = (from Animal an where an = h)" );
public void testParameterListExpansion()
assertTranslation( "from Animal as animal where animal.id in (:idList_1, :idList_2)" );
public void testPolymorphism()
Map replacements = buildTrueFalseReplacementMapForDialect(); assertTranslation( "from Mammal" ); assertTranslation( "from Dog" ); assertTranslation( "from Mammal m where m.pregnant = false and m.bodyWeight > 10", replacements ); assertTranslation( "from Dog d where d.pregnant = false and d.bodyWeight > 10", replacements );
public void testPositionalParameters()
assertTranslation( "from Animal an where an.bodyWeight > ?" );
public void testProduct()
Map replacements = buildTrueFalseReplacementMapForDialect(); assertTranslation( "from Animal, Animal" ); assertTranslation( "from Animal x, Animal y where x.bodyWeight = y.bodyWeight" ); assertTranslation( "from Animal x, Mammal y where x.bodyWeight = y.bodyWeight and not y.pregnant = true", replacements ); assertTranslation( "from Mammal, Mammal" );
public void testProjectProduct()
assertTranslation( "select x from Human x, Human y where x.nickName = y.nickName" ); assertTranslation( "select x, y from Human x, Human y where x.nickName = y.nickName" );
public void testProjectProductJoinedSubclass()
// TODO: The old QT generates the discriminator and the theta join in a strange order, and with two extra sets of parens, this is okay, right? assertTranslation( "select zoo from Zoo zoo, PettingZoo pz where zoo=pz" ); assertTranslation( "select zoo, pz from Zoo zoo, PettingZoo pz where zoo=pz" );
public void testReturnMetadata()
HQLQueryPlan plan = createQueryPlan( "from Animal a" ); check( plan.getReturnMetadata(), false, true ); plan = createQueryPlan( "select a as animal from Animal a" ); check( plan.getReturnMetadata(), false, false ); plan = createQueryPlan( "from java.lang.Object" ); check( plan.getReturnMetadata(), true, true ); plan = createQueryPlan( "select o as entity from java.lang.Object o" ); check( plan.getReturnMetadata(), true, false );
public void testSelectAssociatedEntityId()
assertTranslation( "select an.mother.id from Animal an" );
public void testSelectClauseImplicitJoin()
//assertTranslation( "select d.owner.mother from Dog d" ); //bug in old qt assertTranslation( "select d.owner.mother.description from Dog d" ); //assertTranslation( "select d.owner.mother from Dog d, Dog h" );
public void testSelectCollectionOfValues()
//TODO: broken on dialects with theta-style joins ///old parser had a bug where the collection element was not included in return types! // steve (2005.10.06) - this works perfectly for me on Oracle8i assertTranslation( "select baz, date from Baz baz join baz.stringDateMap date where index(date) = 'foo'" );
public void testSelectDialectFunction()
// From SQLFunctionsTest.testDialectSQLFunctions... if ( getDialect() instanceof HSQLDialect ) { assertTranslation( "select mod(s.count, 2) from org.hibernate.test.legacy.Simple as s where s.id = 10" ); //assertTranslation( "from org.hibernate.test.legacy.Simple as s where mod(s.count, 2) = 0" ); } assertTranslation( "select upper(human.name.first) from Human human" ); assertTranslation( "from Human human where lower(human.name.first) like 'gav%'" ); assertTranslation( "select upper(a.description) from Animal a" ); assertTranslation( "select max(a.bodyWeight) from Animal a" );
public void testSelectDistinctAll()
assertTranslation( "select distinct an.description, an.bodyWeight from Animal an" ); assertTranslation( "select all an from Animal an" );
public void testSelectDistinctComposite()
// This is from CompositeElementTest.testHandSQL. assertTranslation( "select distinct p from org.hibernate.test.compositeelement.Parent p join p.children c where c.name like 'Child%'" );
public void testSelectEntity()
assertTranslation( "select an from Animal an inner join an.mother mo where an.bodyWeight < mo.bodyWeight" ); assertTranslation( "select mo, an from Animal an inner join an.mother mo where an.bodyWeight < mo.bodyWeight" );
public void testSelectEntityProperty()
DotNode.useThetaStyleImplicitJoins = true; assertTranslation( "select an.mother from Animal an" ); assertTranslation( "select an, an.mother from Animal an" ); DotNode.useThetaStyleImplicitJoins = false;
public void testSelectExpressions()
DotNode.useThetaStyleImplicitJoins = true; assertTranslation( "select an.mother.mother from Animal an" ); assertTranslation( "select an.mother.mother.mother from Animal an" ); assertTranslation( "select an.mother.mother.bodyWeight from Animal an" ); assertTranslation( "select an.mother.zoo.id from Animal an" ); assertTranslation( "select user.human.zoo.id from User user" ); assertTranslation( "select u.userName, u.human.name.first from User u" ); assertTranslation( "select u.human.name.last, u.human.name.first from User u" ); assertTranslation( "select bar.baz.name from Bar bar" ); assertTranslation( "select bar.baz.name, bar.baz.count from Bar bar" ); DotNode.useThetaStyleImplicitJoins = false;
public void testSelectNew()
assertTranslation( "select new Animal(an.description, an.bodyWeight) from Animal an" ); assertTranslation( "select new org.hibernate.test.hql.Animal(an.description, an.bodyWeight) from Animal an" );
public void testSelectProperty()
assertTranslation( "select an.bodyWeight, mo.bodyWeight from Animal an inner join an.mother mo where an.bodyWeight < mo.bodyWeight" );
public void testSelectProperty2()
assertTranslation( "select an, mo.bodyWeight from Animal an inner join an.mother mo where an.bodyWeight < mo.bodyWeight" ); assertTranslation( "select an, mo, an.bodyWeight, mo.bodyWeight from Animal an inner join an.mother mo where an.bodyWeight < mo.bodyWeight" );
public void testSelectStandardFunctionsNoParens()
assertTranslation( "select current_date, current_time, current_timestamp from Animal" );
public void testSerialJoinPathEndingInValueCollection()
// HHH-242 assertTranslation( "select h from Human as h join h.friends as f join f.nickNames as nn where h.nickName=:nn1 and (nn=:nn2 or nn=:nn3)" );
public void testSimpleCorrelatedSubselect()
assertTranslation( "from Animal a where a.bodyWeight = (select o.bodyWeight from a.offspring o)" ); assertTranslation( "from Animal a where a = (from a.offspring o)" );
public void testSimpleCorrelatedSubselect2()
assertTranslation( "from Animal a where a = (select o from a.offspring o)" ); assertTranslation( "from Animal a where a in (select o from a.offspring o)" );
public void testSimpleUncorrelatedSubselect()
assertTranslation( "from Animal a where a.bodyWeight = (select an.bodyWeight from Animal an)" ); assertTranslation( "from Animal a where a = (from Animal an)" );
public void testSimpleUncorrelatedSubselect2()
assertTranslation( "from Animal a where a = (select an from Animal an)" ); assertTranslation( "from Animal a where a in (select an from Animal an)" );
public void testSizeFunctionAndProperty()
assertTranslation("from Animal a where a.offspring.size > 0"); assertTranslation("from Animal a join a.offspring where a.offspring.size > 1"); assertTranslation("from Animal a where size(a.offspring) > 0"); assertTranslation("from Animal a join a.offspring o where size(a.offspring) > 1"); assertTranslation("from Animal a where size(a.offspring) > 1 and size(a.offspring) < 100"); assertTranslation("from Human a where a.family.size > 0"); assertTranslation("from Human a join a.family where a.family.size > 1"); assertTranslation("from Human a where size(a.family) > 0"); assertTranslation("from Human a join a.family o where size(a.family) > 1"); assertTranslation("from Human a where a.family.size > 0 and a.family.size < 100");
public void testStandardFunctions()
assertTranslation( "from Animal where current_date = current_time" ); assertTranslation( "from Animal a where upper(a.description) = 'FAT'" ); assertTranslation( "select lower(a.description) from Animal a" );
public void testSubComponentReferences()
assertTranslation( "select c.address.zip.code from ComponentContainer c" ); assertTranslation( "select c.address.zip from ComponentContainer c" ); assertTranslation( "select c.address from ComponentContainer c" );
public void testSubclassAssociation()
assertTranslation( "from DomesticAnimal da join da.owner o where o.nickName = 'Gavin'" ); assertTranslation( "from DomesticAnimal da left join fetch da.owner" ); assertTranslation( "from Human h join h.pets p where p.pregnant = 1" ); assertTranslation( "from Human h join h.pets p where p.bodyWeight > 100" ); assertTranslation( "from Human h left join fetch h.pets" );
public void testSubclassExplicitJoin()
assertTranslation( "from DomesticAnimal da join da.owner o where o.nickName = 'gavin'" ); assertTranslation( "from DomesticAnimal da join da.owner o where o.bodyWeight > 0" );
public void testSubclassImplicitJoin()
assertTranslation( "from DomesticAnimal da where da.owner.nickName like 'Gavin%'" ); assertTranslation( "from DomesticAnimal da where da.owner.nickName = 'gavin'" ); assertTranslation( "from DomesticAnimal da where da.owner.bodyWeight > 0" );
public void testSubclassWhere()
// TODO: The classic QT generates lots of extra parens, etc. assertTranslation( "from PettingZoo pz1, PettingZoo pz2 where pz1.id = pz2.id" ); assertTranslation( "from PettingZoo pz1, PettingZoo pz2 where pz1.id = pz2" ); assertTranslation( "from PettingZoo pz where pz.id > 0 " );
public void testSubselectBetween()
assertTranslation("from Animal x where (select max(a.bodyWeight) from Animal a) between :min and :max"); assertTranslation("from Animal x where (select max(a.description) from Animal a) like 'big%'"); assertTranslation("from Animal x where (select max(a.bodyWeight) from Animal a) is not null"); assertTranslation("from Animal x where exists (select max(a.bodyWeight) from Animal a)"); assertTranslation("from Animal x where (select max(a.bodyWeight) from Animal a) in (1,2,3)");
public void testSubselectImplicitJoins()
// HHH-276 : Implied joins in a from in a subselect. assertTranslation( "from Simple s where s = some( select sim from Simple sim where sim.other.count=s.other.count )" );
public void testSubstitutions()
Map replacements = buildTrueFalseReplacementMapForDialect(); replacements.put("yes", "'Y'"); assertTranslation( "from Human h where h.pregnant = true", replacements ); assertTranslation( "from Human h where h.pregnant = yes", replacements ); assertTranslation( "from Human h where h.pregnant = foo", replacements );
public void testToOneToManyJoinSequence()
assertTranslation( "from Animal a join a.mother m join m.offspring" ); assertTranslation( "from Dog d join d.owner m join m.offspring" ); assertTranslation( "from Animal a join a.mother m join m.offspring o where o.bodyWeight > a.bodyWeight" );
public void testToOneToManyManyJoinSequence()
assertTranslation( "from Dog d join d.owner h join h.friends f where f.name.first like 'joe%'" );
public void testTokenReplacement()
Map replacements = buildTrueFalseReplacementMapForDialect(); assertTranslation( "from Mammal m where m.pregnant = false and m.bodyWeight > 10", replacements );
public void testTwoJoins()
assertTranslation( "from Human human join human.friends, Human h join h.mother" ); assertTranslation( "from Human human join human.friends f, Animal an join an.mother m where f=m" ); assertTranslation( "from Baz baz left join baz.fooToGlarch, Bar bar join bar.foo" );
public void testUncorrelatedSubselect2()
assertTranslation( "from Animal a where a.bodyWeight = (select max(an.bodyWeight) from Animal an)" );
public void testUnknownFailureFromMultiTableTest()
assertTranslation( "from Lower s where s.yetanother.name='name'" );
public void testValueAggregate()
assertTranslation( "select max(p), min(p) from User u join u.permissions p" );
public void testVectorSubselect()
assertTranslation( "from Animal a where ('foo', 'bar') in (select m.description, m.bodyWeight from a.mother m)" );
public void testWhere()
assertTranslation( "from Animal an where an.bodyWeight > 10" ); // 2004-06-26 [jsd] This one requires NOT GT => LE transform. assertTranslation( "from Animal an where not an.bodyWeight > 10" ); assertTranslation( "from Animal an where an.bodyWeight between 0 and 10" ); assertTranslation( "from Animal an where an.bodyWeight not between 0 and 10" ); assertTranslation( "from Animal an where sqrt(an.bodyWeight)/2 > 10" ); // 2004-06-27 [jsd] Recognize 'is null' properly. Generate 'and' and 'or' as well. assertTranslation( "from Animal an where (an.bodyWeight > 10 and an.bodyWeight < 100) or an.bodyWeight is null" );
public void testWhereBetween()
// 2004-08-31 [jsd] This "just worked"! Woohoo! assertTranslation( "from Animal an where an.bodyWeight between 1 and 10" );
public void testWhereIn()
assertTranslation( "from Animal an where an.description in ('fat', 'skinny')" );
public void testWhereLike()
assertTranslation( "from Animal a where a.description like '%black%'" ); assertTranslation( "from Animal an where an.description like '%fat%'" ); assertTranslation( "from Animal an where lower(an.description) like '%fat%'" );
public void testWierdSubselectImplicitJoinStuff()
//note that the new qt used to eliminate unnecessary join, but no more assertTranslation("from Simple s where s = some( select sim from Simple sim where sim.other.count=s.other.count ) and s.other.count > 0");