I am still having issues with this test.
If I define concat template for HSQL as concat(?1 || ?2) the test
passes. But this template is wrong.
Unexpected token in statement [select * from Animal where description =
concat('1' || '2')]
java.sql.SQLException: Unexpected token in statement [select * from
Animal where description = concat('1' || '2')]
at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown
Source)
If I define the template as (?1 || ?2) the test fails.
(I am still using '?i'. I'll fix change it to whatever we agree on after
fixing some issues.)
1)
testExpressionInFunction(org.hibernate.test.hql.HQLTest)junit.framework.
ComparisonFailure: SQL is not the same as the old SQL (scalar=false)
expected:<...concat...> but was:<......>
at
org.hibernate.test.hql.QueryTranslatorTestCase.assertSQLEquals(QueryTran
slatorTestCase.java:224)
at
org.hibernate.test.hql.QueryTranslatorTestCase.checkSql(QueryTranslatorT
estCase.java:211)
at
org.hibernate.test.hql.QueryTranslatorTestCase.assertTranslation(QueryTr
anslatorTestCase.java:125)
at
org.hibernate.test.hql.QueryTranslatorTestCase.assertTranslation(QueryTr
anslatorTestCase.java:52)
at
org.hibernate.test.hql.QueryTranslatorTestCase.assertTranslation(QueryTr
anslatorTestCase.java:44)
at
org.hibernate.test.hql.HQLTest.testExpressionInFunction(HQLTest.java:90)
This is the query:
assertTranslation( "from Animal an where an.description =
concat('fat'||'skinny')" );
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://productguide.itmanagersjournal.com/
_______________________________________________
hibernate-devel mailing list
hibernate-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
