public void Concat()
{
IAlias person = sql.Alias("person");
IFunction func = SqlFn.Concat(person["Name"], person["SurName"]);
QueryResult result = engine.Compile(func);
Assert.Equal("CONCAT(\"person\".\"name\", \"person\".\"surname\")", result.Sql);
Assert.Equal(new Dictionary <string, object>(), result.Parameters);
}
public void Concat()
{
IAlias person = sql.Alias("person");
IFunction func = SqlFn.Concat(person["Name"], person["SurName"]);
QueryResult result = engine.Compile(func);
Assert.Equal("\"PERSON\".\"NAME\" || \"PERSON\".\"SURNAME\"", result.Sql);
Assert.Equal(new Dictionary <string, object>(), result.Parameters);
}
public void Concat_With_Or()
{
engine.AddFunction(FunctionName.Concat, FunctionHelper.ConcatOr);
IAlias person = sql.Alias("person");
IFunction func = SqlFn.Concat(person["Name"], person["SurName"]);
QueryResult result = engine.Compile(func);
Assert.Equal("\"person\".\"Name\" || \"person\".\"SurName\"", result.Sql);
Assert.Equal(new Dictionary <string, object>(), result.Parameters);
}