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