public void IfAll() { var statement = Sql.If(Sql.Scalar(3).Less(Sql.All(Sql.Select.From("foo").Output(Sql.Name("a"))))) .Then(Sql.Select.Output(Sql.Scalar(1))); var command = Utilities.GetCommand(statement); Assert.NotNull(command); Assert.Equal("IF 3 < ALL ( SELECT [a] FROM [foo] )\r\nBEGIN;\r\nSELECT 1;\r\nEND;", command.CommandText); }
public void AllToken() { var statement = Sql.Select.Output(Sql.Star()).From("Customers").Where(Sql.Name("rating").Greater(Sql.All(Sql.Select.Output("rating").From("Customers_new")))); var text = Provider.GenerateStatement(statement); Assert.NotNull(text); Assert.Equal("SELECT * FROM \"Customers\" WHERE \"rating\" > ALL ( SELECT \"rating\" FROM \"Customers_new\" );", text); }