[Nhibernate-commit] SF.net SVN: nhibernate:[5466] trunk/nhibernate/src/NHibernate

[<pa...@us...>]

Revision: 5466
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5466&view=rev
Author:   patearl
Date:     2011-03-13 04:50:20 +0000 (Sun, 13 Mar 2011)

Log Message:
-----------
Implement Left function for SQLite and PostgreSQL.

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate/Dialect/PostgreSQLDialect.cs
    trunk/nhibernate/src/NHibernate/Dialect/SQLiteDialect.cs
    trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1280/NH1280Fixture.cs

Modified: trunk/nhibernate/src/NHibernate/Dialect/PostgreSQLDialect.cs
===================================================================
--- trunk/nhibernate/src/NHibernate/Dialect/PostgreSQLDialect.cs	2011-03-13 04:07:31 UTC (rev 5465)
+++ trunk/nhibernate/src/NHibernate/Dialect/PostgreSQLDialect.cs	2011-03-13 04:50:20 UTC (rev 5466)
@@ -66,6 +66,7 @@
 			
 			RegisterFunction("substring", new AnsiSubstringFunction());
 			RegisterFunction("replace", new StandardSQLFunction("replace", NHibernateUtil.String));
+			RegisterFunction("left", new SQLFunctionTemplate(NHibernateUtil.String, "substr(?1,1,?2)"));
 
 			RegisterFunction("mod", new SQLFunctionTemplate(NHibernateUtil.Int32, "((?1) % (?2))"));
 

Modified: trunk/nhibernate/src/NHibernate/Dialect/SQLiteDialect.cs
===================================================================
--- trunk/nhibernate/src/NHibernate/Dialect/SQLiteDialect.cs	2011-03-13 04:07:31 UTC (rev 5465)
+++ trunk/nhibernate/src/NHibernate/Dialect/SQLiteDialect.cs	2011-03-13 04:50:20 UTC (rev 5466)
@@ -63,6 +63,7 @@
 			RegisterFunction("date", new SQLFunctionTemplate(NHibernateUtil.Date, "datetime(date(?1))"));
 
 			RegisterFunction("substring", new StandardSQLFunction("substr", NHibernateUtil.String));
+			RegisterFunction("left", new SQLFunctionTemplate(NHibernateUtil.String, "substr(?1,1,?2)"));
 			RegisterFunction("trim", new AnsiTrimEmulationFunction());
 
 			RegisterFunction("mod", new SQLFunctionTemplate(NHibernateUtil.Int32, "((?1) % (?2))"));

Modified: trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1280/NH1280Fixture.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1280/NH1280Fixture.cs	2011-03-13 04:07:31 UTC (rev 5465)
+++ trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1280/NH1280Fixture.cs	2011-03-13 04:50:20 UTC (rev 5466)
@@ -224,8 +224,6 @@
 		[Test]
 		public void SubstringShouldUseAllParameters()
 		{
-			if(Dialect is PostgreSQLDialect) Assert.Ignore("The dialect {0} doesn't support LEFT function",Dialect.GetType().Name);
-	
 			using (ISession s = OpenSession())
 			{
 				using (ITransaction tx = s.BeginTransaction())


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