Author: stliu Date: 2010-04-05 10:08:35 -0400 (Mon, 05 Apr 2010) New Revision: 19170 Modified: core/trunk/core/src/main/java/org/hibernate/dialect/Ingres9Dialect.java Log: HHH-5045 org.hibernate.test.hql.HQLTest failure running testConcatenation with Ingres Modified: core/trunk/core/src/main/java/org/hibernate/dialect/Ingres9Dialect.java =================================================================== --- core/trunk/core/src/main/java/org/hibernate/dialect/Ingres9Dialect.java 2010-04-05 14:08:04 UTC (rev 19169) +++ core/trunk/core/src/main/java/org/hibernate/dialect/Ingres9Dialect.java 2010-04-05 14:08:35 UTC (rev 19170) @@ -5,6 +5,7 @@ import org.hibernate.Hibernate; import org.hibernate.cfg.Environment; import org.hibernate.dialect.function.NoArgSQLFunction; +import org.hibernate.dialect.function.VarArgsSQLFunction; /** * A SQL dialect for Ingres 9.3 and later versions. @@ -17,6 +18,7 @@ * <li>Added support for pooled sequences</li> * <li>Added support for SELECT queries with limit and offset</li> * <li>Added getIdentitySelectString</li> + * <li>Modified concatination operator</li> * </ul> * * @author Enrico Schenk, Raymond Fan @@ -26,6 +28,7 @@ super(); registerDateTimeFunctions(); registerDateTimeColumnTypes(); + registerFunction( "concat", new VarArgsSQLFunction( Hibernate.STRING, "(", "||", ")" ) ); } /**