id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
14657	Extra select fields are merged into 'GROUP BY'	Gregory	nobody	"Fields are merged into 'GROUP BY', when using some extra select fields and query.group_by attribute.

{{{
        fragments = Fragment.objects.all().extra(
            select = {'au_names': 'GROUP_CONCAT(lib_author.surnames ORDER BY names DESC SEPARATOR "", "")'},
        )
        fragments.query.group_by = ['lib_fragment.id']
        fragments.query.join((None, 'lib_fragment', None, None))

        connection = (
            'lib_fragment',
            'lib_fragment_authors',
            'id',
            'fragment_id',
        )
        fragments.query.join(connection, promote=True)

        connection = (
            'lib_fragment_authors',
            'lib_author',
            'author_id',
            'id',
        )
        fragments.query.join(connection, promote=True)
}}}


{{{
SELECT
    (GROUP_CONCAT(lib_author.surnames ORDER BY names DESC SEPARATOR "", "")) AS `au_ids`, 
FROM `lib_fragment` 
    LEFT OUTER JOIN `lib_fragment_authors` ON (`lib_fragment`.`id` = `lib_fragment_authors`.`fragment_id`) 
    LEFT OUTER JOIN `lib_author` ON (`lib_fragment_authors`.`author_id` = `lib_author`.`id`) 
GROUP BY (lib_fragment.id), (GROUP_CONCAT(lib_author.surnames ORDER BY names DESC SEPARATOR "", "")) 
ORDER BY `lib_fragment`.`id`
}}}
"		closed	Database layer (models, ORM)	1.2		invalid	extra_select,		Unreviewed	1	0	0	0	0	0