Author: stliu Date: 2010-02-06 01:33:14 -0500 (Sat, 06 Feb 2010) New Revision: 18709 Modified: core/trunk/core/src/main/java/org/hibernate/dialect/IngresDialect.java Log: HHH-4886 Merge minor change from IngresDialect.java from 3.3.2 for Ingres 9.2 compatibility Modified: core/trunk/core/src/main/java/org/hibernate/dialect/IngresDialect.java =================================================================== --- core/trunk/core/src/main/java/org/hibernate/dialect/IngresDialect.java 2010-02-05 23:33:28 UTC (rev 18708) +++ core/trunk/core/src/main/java/org/hibernate/dialect/IngresDialect.java 2010-02-06 06:33:14 UTC (rev 18709) @@ -33,11 +33,11 @@ import org.hibernate.dialect.function.VarArgsSQLFunction; /** - * An Ingres SQL dialect. + * An SQL dialect for Ingres 9.2. * <p/> * Known limitations: - * - only supports simple constants or columns on the left side of an IN, making (1,2,3) in (...) or (<subselect) in (...) non-supported - * - supports only 31 digits in decimal + * - only supports simple constants or columns on the left side of an IN, making (1,2,3) in (...) or (&lt;subselect&gt;) in (...) non-supported + * - supports only 39 digits in decimal * * @author Ian Booth, Bruce Lunsford, Max Rydahl Andersen */ @@ -100,6 +100,7 @@ registerFunction( "intextract", new StandardSQLFunction( "intextract", Hibernate.INTEGER ) ); registerFunction( "left", new StandardSQLFunction( "left", Hibernate.STRING ) ); registerFunction( "locate", new SQLFunctionTemplate( Hibernate.LONG, "locate(?1, ?2)" ) ); + registerFunction( "length", new StandardSQLFunction( "length", Hibernate.LONG ) ); registerFunction( "ln", new StandardSQLFunction( "ln", Hibernate.DOUBLE ) ); registerFunction( "log", new StandardSQLFunction( "log", Hibernate.DOUBLE ) ); registerFunction( "lower", new StandardSQLFunction( "lower" ) );