[Nhibernate-commit] SF.net SVN: nhibernate:[4020] trunk/nhibernate/src/NHibernate.Test/Legacy/ FooBarTest.cs

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

Revision: 4020
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=4020&view=rev
Author:   fabiomaulo
Date:     2009-02-03 16:11:00 +0000 (Tue, 03 Feb 2009)

Log Message:
-----------
Ignore some test for Oracle (cast issue)

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.Test/Legacy/FooBarTest.cs

Modified: trunk/nhibernate/src/NHibernate.Test/Legacy/FooBarTest.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/Legacy/FooBarTest.cs	2009-02-03 13:55:19 UTC (rev 4019)
+++ trunk/nhibernate/src/NHibernate.Test/Legacy/FooBarTest.cs	2009-02-03 16:11:00 UTC (rev 4020)
@@ -2467,21 +2467,22 @@
 				s.CreateQuery("select count(*) from Bar as bar where 'abc' in elements(bar.Baz.FooArray)").List();
 				s.CreateQuery("select count(*) from Bar as bar where 1 in indices(bar.Baz.FooArray)").List();
 				s.CreateQuery(
-					"select count(*) from Bar as bar, bar.Component.Glarch.ProxyArray as g where cast(g.id as Int32) in indices(bar.Baz.FooArray)").
-					List();
-				s.CreateQuery(
-					"select max( elements(bar.Baz.FooArray) ) from Bar as bar, bar.Component.Glarch.ProxyArray as g where cast(g.id as Int32) in indices(bar.Baz.FooArray)")
-					.List();
-				s.CreateQuery(
 					"select count(*) from Bar as bar where '1' in (from bar.Component.Glarch.ProxyArray g where g.Name='foo')").List();
 				s.CreateQuery(
 					"select count(*) from Bar as bar where '1' in (from g in bar.Component.Glarch.ProxyArray.elements where g.Name='foo')")
 					.List();
 
 				// TODO: figure out why this is throwing an ORA-1722 error
-				if (!(Dialect is Oracle9Dialect))
+				// probably the conversion ProxyArray.id (to_number ensuring a not null value)
+				if (!(Dialect is Oracle9Dialect) && !(Dialect is Oracle8iDialect))
 				{
 					s.CreateQuery(
+						"select count(*) from Bar as bar, bar.Component.Glarch.ProxyArray as g where cast(g.id as Int32) in indices(bar.Baz.FooArray)").
+						List();
+					s.CreateQuery(
+						"select max( elements(bar.Baz.FooArray) ) from Bar as bar, bar.Component.Glarch.ProxyArray as g where cast(g.id as Int32) in indices(bar.Baz.FooArray)")
+						.List();
+					s.CreateQuery(
 						"select count(*) from Bar as bar left outer join bar.Component.Glarch.ProxyArray as pg where '1' in (from g in bar.Component.Glarch.ProxyArray)")
 						.List();
 				}


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