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 ) );
+ }
+
}
}
|
