[5.3] Eloquent : withCount() overrides the $columns on get()

[shadoWalker89]

• Laravel Version: 5.3.6
• PHP Version: 5.6.15
• Database Driver & Version: Mysql 5.6.31

Description:

When using withCount() from eloquent Builder it ignores the $columns passed to the get() method and select all the columns.

Steps To Reproduce:

User::withCount('someRelation')->get(['id', 'name']);

[themsaid]

Ping @barryvdh

withCount() selects * on the parent query, it prevents any further column selection, is there a way around this?

[barryvdh]

That is what I mentioned in the PR as possible problem, which I don't have a nice solution for. We need to add a select, if we just add the new column, the default '*' gets ignored (which is more common). See replies from here: #13414 (comment)

I think it should work when you explicitly use a select() call before the count.

User::select(['id', 'name'])->withCount('someRelation')->get();

[themsaid]

Yes it works this way.
@shadoWalker89 Check the reply above.

[shadoWalker89]

Yes it works the way barryvdh said.
Maybe you could add the fix for this as 5.4 milestone ?

[barryvdh]

Or perhaps add this to a note to the withCount docs?

[Luis-Goncalves-Searchprof]

You could also use the "addSelect" instead of "select", that way you can put it after the "withCount".

User::withCount('someRelation')->addSelect(['id', 'name'])->get();

[clytras]

There should be a note regarding this. I spent over an hour trying to figure this out why get([fields]) isn't working with withCount.

@Luis-Goncalves-Searchprof addSelect is not working after withCount.

[driesvints]

@clytras we're always welcoming PR's that improve the docs 👍

[clytras]

@driesvints I'm not aware of the Notes Markdown format that I should use to add one in Counting Related Models.

If you do, please provide it here and I will make a PR for this.

[rpmcmurphy]

$query->paginate() overrides the select() method and brings everything. Any way around for paginated results?