public override string GetBooleanSqlQuery() { var rq = RightValue.GetSetSqlQuery(); if (LeftValue.SupportedTypes.Contains(FilterExpressionType.Numeric)) { return(LeftValue.GetNumericSqlQuery() + " IN " + rq); } var lq = LeftValue.GetSetSqlQuery(); // check intersection return("exists (" + lq.Unparenthesis() + " intersect " + rq.Unparenthesis() + ")"); }
public override string GetNumericSqlQuery() { return(LeftValue.GetNumericSqlQuery() + " + " + RightValue.GetNumericSqlQuery()); }
public override string GetBooleanSqlQuery() { return(BuildEvaluatorSql(LeftValue.GetNumericSqlQuery(), RightValue.GetNumericSqlQuery())); }