[jboss-cvs] jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

[Dain S. <dsu...@us...>]

  User: dsundstrom
  Date: 02/09/21 11:12:21

  Modified:    src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Fixed sqrt mapping for postgres.
  
  Revision  Changes    Path
  1.47      +3 -3      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.46
  retrieving revision 1.47
  diff -u -r1.46 -r1.47
  --- standardjbosscmp-jdbc.xml	19 Sep 2002 16:36:25 -0000	1.46
  +++ standardjbosscmp-jdbc.xml	21 Sep 2002 18:12:20 -0000	1.47
  @@ -7,7 +7,7 @@
   <!--                                                                       -->
   <!-- ===================================================================== -->
   
  -<!-- $Id: standardjbosscmp-jdbc.xml,v 1.46 2002/09/19 16:36:25 loubyansky Exp $ -->
  +<!-- $Id: standardjbosscmp-jdbc.xml,v 1.47 2002/09/21 18:12:20 dsundstrom Exp $ -->
   
   <jbosscmp-jdbc>
      
  @@ -876,7 +876,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>
  @@ -998,7 +998,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>