不需要expr,改成如下即可:
data=table(1..6 as id1,7..12 as id2) whereCodes = [<id1=2>,<id1=5>,<id2=12>] delCodes=unifiedExpr(whereCodes,take(or,whereCodes.size()-1)) sql(sqlCol("*"),data,delCodes).eval();
输出:
id1 id2 2 8 5 11 6 12
执行下列代码:
data=table(1..6 as id1,7..12 as id2) whereCodes = [<id1=2>,<id1=5>,<id2=12>] delCodes=unifiedExpr(whereCodes,take(expr{,or,},whereCodes.size()-1)) sql(sqlCol("*"),data,delCodes).eval();
报错:::evaluate(sql(sqlCol("*"), data, delCodes)) => Please use logical expressions to represent filtering criteria.