Author: gbadner Date: 2008-09-29 17:36:27 -0400 (Mon, 29 Sep 2008) New Revision: 15225 Modified: core/branches/Branch_3_2/test/org/hibernate/test/hql/ASTParserLoadingTest.java Log: HHH-3501 : ASTParserLoadingTest testing unsupported queries for DB2 Modified: core/branches/Branch_3_2/test/org/hibernate/test/hql/ASTParserLoadingTest.java =================================================================== --- core/branches/Branch_3_2/test/org/hibernate/test/hql/ASTParserLoadingTest.java 2008-09-29 15:35:13 UTC (rev 15224) +++ core/branches/Branch_3_2/test/org/hibernate/test/hql/ASTParserLoadingTest.java 2008-09-29 21:36:27 UTC (rev 15225) @@ -125,7 +125,12 @@ assertEquals( 1, results.size() ); results = s.createQuery( "from Human where name is not null" ).list(); assertEquals( 3, results.size() ); - s.createQuery( "from Human where ? is null" ).setParameter( 0, null ).list(); + String query = + getDialect() instanceof DB2Dialect ? + "from Human where cast(? as string) is null" : + "from Human where ? is null" + ; + s.createQuery( query ).setParameter( 0, null ).list(); s.getTransaction().commit(); s.close(); @@ -202,13 +207,29 @@ s.beginTransaction(); s.createQuery( "from Animal a where abs(a.bodyWeight-:param) < 2.0" ).setLong( "param", 1 ).list(); s.createQuery( "from Animal a where abs(:param - a.bodyWeight) < 2.0" ).setLong( "param", 1 ).list(); - if ( ! ( getDialect() instanceof HSQLDialect ) ) { - // HSQLDB does not like the abs(? - ?) syntax... + if ( ( getDialect() instanceof HSQLDialect ) || ( getDialect() instanceof DB2Dialect ) ) { + // HSQLDB and DB2 don't like the abs(? - ?) syntax. bit work if at least one parameter is typed... + s.createQuery( "from Animal where abs(cast(:x as long) - :y) < 2.0" ).setLong( "x", 1 ).setLong( "y", 1 ).list(); + s.createQuery( "from Animal where abs(:x - cast(:y as long)) < 2.0" ).setLong( "x", 1 ).setLong( "y", 1 ).list(); + s.createQuery( "from Animal where abs(cast(:x as long) - cast(:y as long)) < 2.0" ).setLong( "x", 1 ).setLong( "y", 1 ).list(); + } + else { s.createQuery( "from Animal where abs(:x - :y) < 2.0" ).setLong( "x", 1 ).setLong( "y", 1 ).list(); } - s.createQuery( "from Animal where lower(upper(:foo)) like 'f%'" ).setString( "foo", "foo" ).list(); + + if ( getDialect() instanceof DB2Dialect ) { + s.createQuery( "from Animal where lower(upper(cast(:foo as string))) like 'f%'" ).setString( "foo", "foo" ).list(); + } + else { + s.createQuery( "from Animal where lower(upper(:foo)) like 'f%'" ).setString( "foo", "foo" ).list(); + } s.createQuery( "from Animal a where abs(abs(a.bodyWeight - 1.0 + :param) * abs(length('ffobar')-3)) = 3.0" ).setLong( "param", 1 ).list(); - s.createQuery( "from Animal where lower(upper('foo') || upper(:bar)) like 'f%'" ).setString( "bar", "xyz" ).list(); + if ( getDialect() instanceof DB2Dialect ) { + s.createQuery( "from Animal where lower(upper('foo') || upper(cast(:bar as string))) like 'f%'" ).setString( "bar", "xyz" ).list(); + } + else { + s.createQuery( "from Animal where lower(upper('foo') || upper(:bar)) like 'f%'" ).setString( "bar", "xyz" ).list(); + } if ( ! ( getDialect() instanceof PostgreSQLDialect || getDialect() instanceof MySQLDialect ) ) { s.createQuery( "from Animal where abs(cast(1 as float) - cast(:param as float)) = 1.0" ).setLong( "param", 1 ).list(); }