子查询sql创建错误:select(false)

浏览:2746 发布日期:2014/12/05
3.2.2 - 致命 - 未处理
// 版本信息
const THINK_VERSION = '3.2.3beta';

$query0 =
$model->alias('m')
->join('left join __DOCUMENT__ d on m.uid=d.uid')
->where('id>2')
->field('m.uid,m.nickname,d.name docname,d.title as doctitle')
->buildSql();
$query =
$model->alias('m')
->join('left join __DOCUMENT__ d on m.uid=d.uid')
->where('id>2')
->field('m.uid,m.nickname,d.name docname,d.title as doctitle')
->select(false);

var_dump($query0,$query);

string '( SELECT m.uid,m.nickname,d.name docname,d.title as doctitle FROM ot_member m left join ot_document d on m.uid=d.uid WHERE ( id>2 ) )' (length=135)

string '( SELECT m.uid,m.nickname,d.name docname,d.title as doctitle FROM ot_member m m left join ot_document d on m.uid=d.uid WHERE ( id>2 ) )' (length=137)

select(false) 多了个表别名
评论(
后面还有条评论,点击查看>>