CloneSet185

src/NHibernate.Test/SqlCommandTest/SqlStringFixture.cs

src/NHibernate.Test/SqlCommandTest/SqlStringFixture.cs

src/NHibernate.Test/SqlCommandTest/SqlStringFixture.cs

src/NHibernate.Test/SqlCommandTest/SqlStringFixture.cs

src/NHibernate.Test/SqlCommandTest/SqlStringFixture.cs

src/NHibernate.Test/SqlCommandTest/SqlStringFixture.cs

src/NHibernate.Test/SqlCommandTest/SqlStringFixture.cs

src/NHibernate.Test/SqlCommandTest/SqlStringFixture.cs

src/NHibernate.Test/SqlCommandTest/SqlStringFixture.cs

src/NHibernate.Test/SqlCommandTest/SqlStringFixture.cs

                [Test]
                public void GetSubselectStringSimple()
                {
                        SqlString sql = SqlString.Parse("select col from table where col = test order by col");
                        Assert.AreEqual(" from table where col = test ", sql.GetSubselectString().ToString());
                }

                [Test]
                public void GetSubselectStringParameterInOrderBy()
                {
                        SqlString sql = SqlString.Parse("select col from table where col = test order by ? asc");
                        Assert.AreEqual(" from table where col = test ", sql.GetSubselectString().ToString());
                }

                [Test]
                public void GetSubselectStringSimpleEndsWithParameter()
                {
                        SqlString sql = SqlString.Parse("select col from table where col = ? order by col");
                        Assert.AreEqual(" from table where col = ? ", sql.GetSubselectString().ToString());
                }

                [Test]
                public void GetSubselectStringSimpleParameterInMiddle()
                {
                        SqlString sql = SqlString.Parse("select col from table where col = ? and foo = bar order by col");
                        Assert.AreEqual(" from table where col = ? and foo = bar ", sql.GetSubselectString().ToString());
                }

                [Test]
                public void GetSubselectStringWithFormulaProperty()
                {
                        SqlString sql =
                                SqlString.Parse("select (select foo from bar where foo=col order by foo) from table where col = ? order by col");
                        Assert.AreEqual(" from table where col = ? ", sql.GetSubselectString().ToString());
                }

                [Test]
                public void GetSubselectStringWithSubselectInWhere()
                {
                        SqlString sql =
                                SqlString.Parse(
                                        "select (select foo from bar where foo=col order by foo) from table where col = (select yadda from blah where yadda=x order by yadda) order by col");
                        Assert.AreEqual(" from table where col = (select yadda from blah where yadda=x order by yadda) ",
                                        sql.GetSubselectString().ToString());
                }

                [Test]
                public void GetSubselectStringWithFormulaPropertyWithSubselect()
                {
                        SqlString sql =
                                SqlString.Parse(
                                        "select (select (select blah from yadda where blah=foo order by blah) from bar where foo=col order by foo) from table where col = ? order by col");
                        Assert.AreEqual(" from table where col = ? ", sql.GetSubselectString().ToString());
                }

                [Test]
                public void GetSubselectStringWithParenthesisOnlyInWhere()
                {
                        SqlString sql = SqlString.Parse("select col from table where (col = test) order by col");
                        Assert.AreEqual(" from table where (col = test) ", sql.GetSubselectString().ToString());
                }

                [Test]
                public void GetSubselectStringWithTwoFormulas()
                {
                        SqlString sql =
                                SqlString.Parse(
                                        "select (select foo from bar where foo=col order by foo), (select foo from bar where foo=col order by foo) from table where col = ? order by col");
                        Assert.AreEqual(" from table where col = ? ", sql.GetSubselectString().ToString());
                }

                [Test]
                public void GetSubselectStringWithOrderByInSubselect()
                {
                        SqlString sql = SqlString.Parse("select col from table where (col = test) and id in (select id from foo order by bar)");
                        Assert.AreEqual(" from table where (col = test) and id in (select id from foo order by bar)", sql.GetSubselectString().ToString());
                }

[Test]
public void [[#variable5e470380]]()
{
   SqlString sql = SqlString.Parse( [[#variable5e470280]]);
   Assert.AreEqual( [[#variable5e4701e0]], sql.GetSubselectString().ToString());
}

 

GetSubselectStringSimple 

GetSubselectStringWithFormulaProperty 

GetSubselectStringSimpleParameterInMiddle 

GetSubselectStringWithSubselectInWhere 

GetSubselectStringWithParenthesisOnlyInWhere 

GetSubselectStringWithOrderByInSubselect 

GetSubselectStringWithFormulaPropertyWithSubselect 

GetSubselectStringParameterInOrderBy 

GetSubselectStringWithTwoFormulas 

GetSubselectStringSimpleEndsWithParameter 

"select col from table where col = test order by col" 

"select (select foo from bar where foo=col order by foo) from table where col = ? order by col" 

"select col from table where col = ? and foo = bar order by col" 

"select (select foo from bar where foo=col order by foo) from table where col = (select yadda from blah where yadda=x order by yadda) order by col" 

"select col from table where (col = test) order by col" 

"select col from table where (col = test) and id in (select id from foo order by bar)" 

"select (select (select blah from yadda where blah=foo order by blah) from bar where foo=col order by foo) from table where col = ? order by col" 

"select col from table where col = test order by ? asc" 

"select (select foo from bar where foo=col order by foo), (select foo from bar where foo=col order by foo) from table where col = ? order by col" 

"select col from table where col = ? order by col" 

" from table where col = test " 

" from table where col = ? " 

" from table where col = ? and foo = bar " 

" from table where col = (select yadda from blah where yadda=x order by yadda) " 

" from table where (col = test) " 

" from table where (col = test) and id in (select id from foo order by bar)" 

" from table where col = ? " 

" from table where col = test " 

" from table where col = ? " 

" from table where col = ? "