This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "FusionForge".
The branch, master has been updated
via 718321344faae292b3690cf3c64425a456372d86 (commit)
from 017d2a5e8ad702cfcd8301de84bbc31ddcd16f76 (commit)
Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.
- Log -----------------------------------------------------------------
https://scm.fusionforge.org/anonscm/gitweb/?p=fusionforge/fusionforge.git;a=commitdiff;h=718321344faae292b3690cf3c64425a456372d86
commit 718321344faae292b3690cf3c64425a456372d86
Author: Franck Villaume <[email protected]>
Date: Sun Mar 24 18:35:44 2019 +0100
search: fix SQL query, missing group by column
diff --git a/src/common/search/TrackersSearchQuery.class.php
b/src/common/search/TrackersSearchQuery.class.php
index 2340f81..ac73c01 100644
--- a/src/common/search/TrackersSearchQuery.class.php
+++ b/src/common/search/TrackersSearchQuery.class.php
@@ -75,7 +75,7 @@ class TrackersSearchQuery extends SearchQuery {
array
(db_int_array_to_any_clause ($this->sections)));
}
- $qpa = db_construct_qpa($qpa, ' AND
artifact.artifact_id = artifact_idx.artifact_id AND vectors @@ to_tsquery($1)
GROUP BY artifact.artifact_id, artifact.group_artifact_id, artifact.summary,
artifact.open_date, users.realname, artifact.details, vectors) AS x WHERE ',
+ $qpa = db_construct_qpa($qpa, ' AND
artifact.artifact_id = artifact_idx.artifact_id AND vectors @@ to_tsquery($1)
GROUP BY artifact.artifact_id, artifact.group_artifact_id, artifact.summary,
artifact.open_date, users.realname, artifact.details, vectors,
artifact_group_list.name) AS x WHERE ',
array($words));
$qpa = $this->addMatchCondition($qpa,
'full_string_agg');
$qpa = db_construct_qpa($qpa, ' ORDER BY
ts_rank(vectors, to_tsquery($1)) DESC',
-----------------------------------------------------------------------
Summary of changes:
src/common/search/TrackersSearchQuery.class.php | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
hooks/post-receive
--
FusionForge
_______________________________________________
Fusionforge-commits mailing list
[email protected]
http://lists.fusionforge.org/cgi-bin/mailman/listinfo/fusionforge-commits
