top-think/think

关于查询构造器的问题

Opened this issue · 0 comments

环境:tp5.24
1.whereNotNull如果传的空 生成的sql是AND  IS NOT NULL
2.Db::name(xxx)->where(['name'=>"xx"])->whereNotNull('name')
where条件和whereNotNull 同时限定一个字段 会报表达式错误
示例:
   Db::table('goods')->alias('g')->where(['g.name'=>"xx"])->whereNotNull('g.name')->select();
结果是异常
[0] Exception in Builder.php line 347
查询表达式错误:xx