Example #1
0
        public void AnyToken()
        {
            var statement = Sql.Select.Output(Sql.Star()).From("Customers").Where(Sql.Name("rating").Greater(Sql.Any(Sql.Select.Output("rating").From("Customers_new"))));
            var text      = Provider.GenerateStatement(statement);

            Assert.NotNull(text);
            Assert.Equal("SELECT * FROM \"Customers\" WHERE \"rating\" > ANY ( SELECT \"rating\" FROM \"Customers_new\" );", text);
        }