swoft-cloud / swoft

🚀 PHP Microservice Full Coroutine Framework
https://swoft.org
Apache License 2.0
5.58k stars 788 forks source link

DB组件leftJoin查询强制指定前缀。导致某些查询或者情况无法使用 #229

Closed ghost closed 6 years ago

ghost commented 6 years ago
$data = Query::table('wf_admin', ‘a')
            ->leftJoin('wf_admin_nexus_role',['b.admin_id' => 'a.id'], 'b')
            ->condition($where)
            ->one()
            ->getResult();

类似这样会强制给leftJoin的ON条件加上前缀,这让人很恶心。 建议能不能赶紧完善DB操作,或者移植TP,YII,medoo

_qviagm hz567xuuju8h5 8

stelin commented 6 years ago

这是一个bug,不是强制性的,我们尽快修复!

stelin commented 6 years ago

你语法使用不对,正确方式是

$data = Query::table('wf_admin', ‘a') ->leftJoin('wf_admin_nexus_role',['b.admin_id=a.id'], 'b') ->condition($where) ->one() ->getResult();