liquid_feedback_frontend
changeset 1225:ebb3c5fa158d
Removed exhaustive GROUP BY list in Issue:get_search_selector(...) due to PRIMARY KEY (PostgreSQL 9.1 feature)
author | jbe |
---|---|
date | Tue Dec 01 16:43:54 2015 +0100 (2015-12-01) |
parents | 97ca043d7c40 |
children | b79085a2f92e |
files | model/issue.lua |
line diff
1.1 --- a/model/issue.lua Tue Dec 01 16:38:12 2015 +0100 1.2 +++ b/model/issue.lua Tue Dec 01 16:43:54 2015 +0100 1.3 @@ -220,27 +220,6 @@ 1.4 :join('"draft"', nil, '"draft"."initiative_id" = "initiative"."id"') 1.5 :add_where{ '"initiative"."text_search_data" @@ "text_search_query"(?) OR "draft"."text_search_data" @@ "text_search_query"(?)', search_string, search_string } 1.6 :add_group_by('"issue"."id"') 1.7 - :add_group_by('"issue"."area_id"') 1.8 - :add_group_by('"issue"."policy_id"') 1.9 - :add_group_by('"issue"."state"') 1.10 - :add_group_by('"issue"."phase_finished"') 1.11 - :add_group_by('"issue"."created"') 1.12 - :add_group_by('"issue"."accepted"') 1.13 - :add_group_by('"issue"."half_frozen"') 1.14 - :add_group_by('"issue"."fully_frozen"') 1.15 - :add_group_by('"issue"."closed"') 1.16 - :add_group_by('"issue"."status_quo_schulze_rank"') 1.17 - :add_group_by('"issue"."cleaned"') 1.18 - :add_group_by('"issue"."snapshot"') 1.19 - :add_group_by('"issue"."latest_snapshot_event"') 1.20 - :add_group_by('"issue"."population"') 1.21 - :add_group_by('"issue"."voter_count"') 1.22 - :add_group_by('"issue"."admission_time"') 1.23 - :add_group_by('"issue"."discussion_time"') 1.24 - :add_group_by('"issue"."verification_time"') 1.25 - :add_group_by('"issue"."voting_time"') 1.26 - :add_group_by('"issue"."admin_notice"') 1.27 - --:set_distinct() 1.28 end 1.29 1.30 function Issue:modify_selector_for_state(initiatives_selector, state)