think icon indicating copy to clipboard operation
think copied to clipboard

关于查询构造器的问题

Open rxrddd opened this issue 4 years ago • 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

rxrddd avatar Apr 12 '20 03:04 rxrddd