[Nhibernate-commit] SF.net SVN: nhibernate:[5194] trunk/nhibernate/src/NHibernate/Dialect/ Function/AnsiTrimEmulationFunction.cs

[<fab...@us...>]

Revision: 5194
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5194&view=rev
Author:   fabiomaulo
Date:     2010-09-19 21:45:33 +0000 (Sun, 19 Sep 2010)

Log Message:
-----------
Apply NH-2336

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate/Dialect/Function/AnsiTrimEmulationFunction.cs

Modified: trunk/nhibernate/src/NHibernate/Dialect/Function/AnsiTrimEmulationFunction.cs
===================================================================
--- trunk/nhibernate/src/NHibernate/Dialect/Function/AnsiTrimEmulationFunction.cs	2010-09-19 20:34:17 UTC (rev 5193)
+++ trunk/nhibernate/src/NHibernate/Dialect/Function/AnsiTrimEmulationFunction.cs	2010-09-19 21:45:33 UTC (rev 5194)
@@ -31,11 +31,11 @@
 
 		private static readonly ISQLFunction LeadingTrim =
 			new SQLFunctionTemplate(NHibernateUtil.String,
-			                        "replace( replace( rtrim( replace( replace( ?1, ' ', '${space}$' ), ?2, ' ' ) ), ' ', ?2 ), '${space}$', ' ' )");
+			                        "replace( replace( ltrim( replace( replace( ?1, ' ', '${space}$' ), ?2, ' ' ) ), ' ', ?2 ), '${space}$', ' ' )");
 
 		private static readonly ISQLFunction TrailingTrim =
 			new SQLFunctionTemplate(NHibernateUtil.String,
-			                        "replace( replace( ltrim( replace( replace( ?1, ' ', '${space}$' ), ?2, ' ' ) ), ' ', ?2 ), '${space}$', ' ' )");
+			                        "replace( replace( rtrim( replace( replace( ?1, ' ', '${space}$' ), ?2, ' ' ) ), ' ', ?2 ), '${space}$', ' ' )");
 
 		private static readonly ISQLFunction BothTrim =
 			new SQLFunctionTemplate(NHibernateUtil.String,


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.