[Nhibernate-commit] SF.net SVN: nhibernate:[4018] trunk/nhibernate/src/NHibernate.Test/HQL/ HQLFunctions.cs

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

Revision: 4018
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=4018&view=rev
Author:   fabiomaulo
Date:     2009-02-03 13:35:19 +0000 (Tue, 03 Feb 2009)

Log Message:
-----------
Ignore some "cast" test for Oracle

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.Test/HQL/HQLFunctions.cs

Modified: trunk/nhibernate/src/NHibernate.Test/HQL/HQLFunctions.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/HQL/HQLFunctions.cs	2009-02-03 12:45:32 UTC (rev 4017)
+++ trunk/nhibernate/src/NHibernate.Test/HQL/HQLFunctions.cs	2009-02-03 13:35:19 UTC (rev 4018)
@@ -590,17 +590,23 @@
 				Assert.AreEqual(7f + 123f - 5f * 1.3f, l[0]);
 
 				// Rendered in SELECT using a property and nested functions
-				hql = "select cast(cast(a.BodyWeight as string) as Double) from Animal a";
-				l = s.CreateQuery(hql).List();
-				Assert.AreEqual(1, l.Count);
-				Assert.AreEqual(1.3F, l[0]);
+				if (!(Dialect is Oracle8iDialect))
+				{
+					hql = "select cast(cast(a.BodyWeight as string) as Double) from Animal a";
+					l = s.CreateQuery(hql).List();
+					Assert.AreEqual(1, l.Count);
+					Assert.AreEqual(1.3F, l[0]);
+				}
 
 				// TODO: Rendered in SELECT using string costant assigned with critic chars (separators)
 
 				// Rendered in WHERE using a property 
-				hql = "from Animal a where cast(a.BodyWeight as string) like '1.%'";
-				result = (Animal)s.CreateQuery(hql).UniqueResult();
-				Assert.AreEqual("abcdef", result.Description);
+				if (!(Dialect is Oracle8iDialect))
+				{
+					hql = "from Animal a where cast(a.BodyWeight as string) like '1.%'";
+					result = (Animal) s.CreateQuery(hql).UniqueResult();
+					Assert.AreEqual("abcdef", result.Description);
+				}
 
 				// Rendered in WHERE using a property in an operation with costants
 				hql = "from Animal a where cast(7+123-2*a.BodyWeight as Double)>0";
@@ -615,9 +621,12 @@
 				Assert.AreEqual("abcdef", result.Description);
 
 				// Rendered in WHERE using a property and nested functions
-				hql = "from Animal a where cast(cast(cast(a.BodyWeight as string) as double) as int) = 1";
-				result = (Animal)s.CreateQuery(hql).UniqueResult();
-				Assert.AreEqual("abcdef", result.Description);
+				if (!(Dialect is Oracle8iDialect))
+				{
+					hql = "from Animal a where cast(cast(cast(a.BodyWeight as string) as double) as int) = 1";
+					result = (Animal) s.CreateQuery(hql).UniqueResult();
+					Assert.AreEqual("abcdef", result.Description);
+				}
 
 				// Rendered in GROUP BY using a property 
 				hql = "select cast(a.BodyWeight as Double) from Animal a group by cast(a.BodyWeight as Double)";
@@ -632,10 +641,14 @@
 				Assert.AreEqual(7f + 123f - 5f * 1.3f, l[0]);
 
 				// Rendered in GROUP BY using a property and nested functions
-				hql = "select cast(cast(a.BodyWeight as string) as Double) from Animal a group by cast(cast(a.BodyWeight as string) as Double)";
-				l = s.CreateQuery(hql).List();
-				Assert.AreEqual(1, l.Count);
-				Assert.AreEqual(1.3F, l[0]);
+				if (!(Dialect is Oracle8iDialect))
+				{
+					hql =
+						"select cast(cast(a.BodyWeight as string) as Double) from Animal a group by cast(cast(a.BodyWeight as string) as Double)";
+					l = s.CreateQuery(hql).List();
+					Assert.AreEqual(1, l.Count);
+					Assert.AreEqual(1.3F, l[0]);
+				}
 
 				// Rendered in HAVING using a property 
 				hql = "select cast(a.BodyWeight as Double) from Animal a group by cast(a.BodyWeight as Double) having cast(a.BodyWeight as Double)>0";
@@ -664,21 +677,32 @@
 				}
 				catch (ADOException ex)
 				{
-					// This test raises an exception in SQL Server because named 
-					// parameters internally are always positional (@p0, @p1, etc.)
-					// and named differently hence they mismatch between GROUP BY and HAVING clauses.
-					if (!ex.InnerException.Message.Equals(
-						"Column 'Animal.BodyWeight' is invalid in the HAVING clause " +
-						"because it is not contained in either an aggregate function or the GROUP BY clause."))
-						throw;
+					if (Dialect is Oracle8iDialect)
+					{
+						if (!ex.InnerException.Message.StartsWith("ORA-00979"))
+							throw;
+					}
+					else
+					{
+						string msgToCheck =
+							"Column 'Animal.BodyWeight' is invalid in the HAVING clause because it is not contained in either an aggregate function or the GROUP BY clause.";
+						// This test raises an exception in SQL Server because named 
+						// parameters internally are always positional (@p0, @p1, etc.)
+						// and named differently hence they mismatch between GROUP BY and HAVING clauses.
+						if (!ex.InnerException.Message.Equals(msgToCheck))
+							throw;
+					}
 				}
 
 				// Rendered in HAVING using a property and nested functions
-				string castExpr = "cast(cast(cast(a.BodyWeight as string) as double) as int)";
-				hql = string.Format("select {0} from Animal a group by {0} having {0} = 1", castExpr);
-				l = s.CreateQuery(hql).List();
-				Assert.AreEqual(1, l.Count);
-				Assert.AreEqual(1, l[0]);
+				if (!(Dialect is Oracle8iDialect))
+				{
+					string castExpr = "cast(cast(cast(a.BodyWeight as string) as double) as int)";
+					hql = string.Format("select {0} from Animal a group by {0} having {0} = 1", castExpr);
+					l = s.CreateQuery(hql).List();
+					Assert.AreEqual(1, l.Count);
+					Assert.AreEqual(1, l[0]);
+				}
 			}
 		}
 


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