[Nhibernate-commit] nhibernate/src/NHibernate.Test/SqlCommandTest TemplateFixture.cs,1.3,1.4

[Michael D. <mik...@us...>]

Update of /cvsroot/nhibernate/nhibernate/src/NHibernate.Test/SqlCommandTest
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv21627/NHibernate.Test/SqlCommandTest

Modified Files:
	TemplateFixture.cs 
Log Message:
Fixed problem caused by order-by attribute with multicolumns generating
incorrect sql.

Index: TemplateFixture.cs
===================================================================
RCS file: /cvsroot/nhibernate/nhibernate/src/NHibernate.Test/SqlCommandTest/TemplateFixture.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** TemplateFixture.cs	26 Apr 2004 03:46:45 -0000	1.3
--- TemplateFixture.cs	21 Oct 2004 00:21:07 -0000	1.4
***************
*** 33,36 ****
--- 33,58 ----
  		}
  
+ 		[Test]
+ 		public void OrderBySingleColumn() 
+ 		{
+ 			Dialect.Dialect dialect = new Dialect.MsSql2000Dialect();
+ 
+ 			string orderBy = "col1 asc";
+ 			string expectedOrderBy = "$PlaceHolder.col1 asc";
+ 
+ 			Assert.AreEqual( expectedOrderBy, Template.RenderOrderByStringTemplate( orderBy, dialect ) );
+ 		}
+ 
+ 		[Test]
+ 		public void OrderByMultiColumn() 
+ 		{
+ 			Dialect.Dialect dialect = new Dialect.MsSql2000Dialect();
+ 
+ 			string orderBy = "col1 asc, col2 desc, col3";
+ 			string expectedOrderBy = "$PlaceHolder.col1 asc, $PlaceHolder.col2 desc, $PlaceHolder.col3";
+ 
+ 			Assert.AreEqual( expectedOrderBy, Template.RenderOrderByStringTemplate( orderBy, dialect ) );
+ 		}
+ 
  	}
  }