User: dsundstrom
Date: 02/04/09 08:43:27
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Fixed bug [ 541507 ] Wrong PostgreSQL function mapping for locate.
Revision Changes Path
1.21 +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.20
retrieving revision 1.21
diff -u -r1.20 -r1.21
--- standardjbosscmp-jdbc.xml 24 Mar 2002 21:44:33 -0000 1.20
+++ standardjbosscmp-jdbc.xml 9 Apr 2002 15:43:21 -0000 1.21
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.20 2002/03/24 21:44:33 d_jencks Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.21 2002/04/09 15:43:21 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -510,7 +510,7 @@
</function-mapping>
<function-mapping>
<function-name>locate</function-name>
- <function-sql>(position(?2 in substring(?1 from ?3))+?3)</function-sql>
+ <function-sql>(coalesce(nullif(position(?1 in substring(?2 from ?3)),
0) + ?3 -1, 0)) </function-sql>
</function-mapping>
<function-mapping>
<function-name>abs</function-name>
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
