From: Dain S. <dsu...@us...> - 2002-09-18 03:05:51
|
User: dsundstrom Date: 02/09/17 20:05:51 Modified: src/etc/conf/default Tag: Branch_3_0 standardjbosscmp-jdbc.xml Log: Fixed sqrt mapping for postgres. Revision Changes Path No revision No revision 1.23.2.19 +2 -2 jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml Index: standardjbosscmp-jdbc.xml =================================================================== RCS file: /cvsroot/jboss/jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml,v retrieving revision 1.23.2.18 retrieving revision 1.23.2.19 diff -u -r1.23.2.18 -r1.23.2.19 --- standardjbosscmp-jdbc.xml 16 Sep 2002 20:35:36 -0000 1.23.2.18 +++ standardjbosscmp-jdbc.xml 18 Sep 2002 03:05:50 -0000 1.23.2.19 @@ -783,7 +783,7 @@ </function-mapping> <function-mapping> <function-name>sqrt</function-name> - <function-sql>sqrt(?1)</function-sql> + <function-sql>sqrt(CAST(?1 AS double precision))</function-sql> </function-mapping> <function-mapping> <function-name>ucase</function-name> @@ -905,7 +905,7 @@ </function-mapping> <function-mapping> <function-name>sqrt</function-name> - <function-sql>sqrt(?1)</function-sql> + <function-sql>sqrt(CAST(?1 AS double precision))</function-sql> </function-mapping> <function-mapping> <function-name>ucase</function-name> |