# HG changeset patch # User jbe # Date 1448984634 -3600 # Node ID ebb3c5fa158d14f801959ceafa1ff53c474afa74 # Parent 97ca043d7c40fd8cfeb081a4c72d588d1d9bf27b Removed exhaustive GROUP BY list in Issue:get_search_selector(...) due to PRIMARY KEY (PostgreSQL 9.1 feature) diff -r 97ca043d7c40 -r ebb3c5fa158d model/issue.lua --- a/model/issue.lua Tue Dec 01 16:38:12 2015 +0100 +++ b/model/issue.lua Tue Dec 01 16:43:54 2015 +0100 @@ -220,27 +220,6 @@ :join('"draft"', nil, '"draft"."initiative_id" = "initiative"."id"') :add_where{ '"initiative"."text_search_data" @@ "text_search_query"(?) OR "draft"."text_search_data" @@ "text_search_query"(?)', search_string, search_string } :add_group_by('"issue"."id"') - :add_group_by('"issue"."area_id"') - :add_group_by('"issue"."policy_id"') - :add_group_by('"issue"."state"') - :add_group_by('"issue"."phase_finished"') - :add_group_by('"issue"."created"') - :add_group_by('"issue"."accepted"') - :add_group_by('"issue"."half_frozen"') - :add_group_by('"issue"."fully_frozen"') - :add_group_by('"issue"."closed"') - :add_group_by('"issue"."status_quo_schulze_rank"') - :add_group_by('"issue"."cleaned"') - :add_group_by('"issue"."snapshot"') - :add_group_by('"issue"."latest_snapshot_event"') - :add_group_by('"issue"."population"') - :add_group_by('"issue"."voter_count"') - :add_group_by('"issue"."admission_time"') - :add_group_by('"issue"."discussion_time"') - :add_group_by('"issue"."verification_time"') - :add_group_by('"issue"."voting_time"') - :add_group_by('"issue"."admin_notice"') - --:set_distinct() end function Issue:modify_selector_for_state(initiatives_selector, state)