Здравствуйте, я захотел задать вытаскиваемые поля при склейки таблиц в объявлении зависимостей:
public function relations() {
return array(
'user' => array(
self::BELONGS_TO, 'User', 'user_id',
'condition' => 'user.id=:uid',
'select' => 'user.id AS uid',
'params' => array(':uid' => Yii::app()->user->id),
),
);
}
В документации сказано что "select" по умолчанию выставлен в "", но при попытке задать только определенные поля он просто склеивает условия "" и новое "user.id AS uid".
Без “‘select’ => ‘user.id AS uid’” :
SELECT t
.gid
AS t0_c0
, t
.title
AS t0_c1
,t
.weight
AS t0_c2
, t
.user_id
AS t0_c3
,
[i]user
.id
AS t1_c0
, user
.username
AS t1_c1
, user
.email
AS
t1_c3
, user
.createtime
AS t1_c5
, user
.lastvisit
AS t1_c6
,
user
.superuser
AS t1_c7
, user
.status
AS t1_c8
[/i]
FROM tbl_groups
t
LEFT OUTER JOIN tbl_users
user
ON (t
.user_id
=user
.id
) WHERE (user.id=:uid) LIMIT 10
Вместе с “‘select’ => ‘user.id AS uid’” :
SELECT t
.gid
AS t0_c0
, t
.title
AS t0_c1
,t
.weight
AS t0_c2
, t
.user_id
AS t0_c3
,
[i]user.id AS uid,
user
.id
AS t1_c0
, user
.username
AS t1_c1
, user
.email
AS
t1_c3
, user
.createtime
AS t1_c5
, user
.lastvisit
AS t1_c6
,
user
.superuser
AS t1_c7
, user
.status
AS t1_c8
[/i]
FROM tbl_groups
t
LEFT OUTER JOIN tbl_users
user
ON (t
.user_id
=user
.id
) WHERE (user.id=:uid) LIMIT 10
Возможно ли сделать так так чтобы лишние поля (которые курсивом) не вытаскивались ?