Fix: Arel Postgresql visitor generates invalid SQL for GROUPING SETS.

2 files changed, 5 insertions, 5 deletions

diff --git a/activerecord/lib/arel/visitors/postgresql.rb b/activerecord/lib/arel/visitors/postgresql.rb
index 108ee431ee..c5110fa89c 100644
--- a/activerecord/lib/arel/visitors/postgresql.rb
+++ b/activerecord/lib/arel/visitors/postgresql.rb
@@ -5,7 +5,7 @@ module Arel # :nodoc: all
     class PostgreSQL < Arel::Visitors::ToSql
       CUBE = "CUBE"
       ROLLUP = "ROLLUP"
-      GROUPING_SET = "GROUPING SET"
+      GROUPING_SETS = "GROUPING SETS"
       LATERAL = "LATERAL"
 
       private
@@ -67,7 +67,7 @@ module Arel # :nodoc: all
         end
 
         def visit_Arel_Nodes_GroupingSet(o, collector)
-          collector << GROUPING_SET
+          collector << GROUPING_SETS
           grouping_array_or_grouping_element o, collector
         end
 
diff --git a/activerecord/test/cases/arel/visitors/postgres_test.rb b/activerecord/test/cases/arel/visitors/postgres_test.rb
index ba37afecfb..ba9cfcfc64 100644
--- a/activerecord/test/cases/arel/visitors/postgres_test.rb
+++ b/activerecord/test/cases/arel/visitors/postgres_test.rb
@@ -229,7 +229,7 @@ module Arel
         it "should know how to visit with array arguments" do
           node = Arel::Nodes::GroupingSet.new([@table[:name], @table[:bool]])
           compile(node).must_be_like %{
-            GROUPING SET( "users"."name", "users"."bool" )
+            GROUPING SETS( "users"."name", "users"."bool" )
           }
         end
 
@@ -237,7 +237,7 @@ module Arel
           group = Arel::Nodes::GroupingElement.new([@table[:name], @table[:bool]])
           node = Arel::Nodes::GroupingSet.new(group)
           compile(node).must_be_like %{
-            GROUPING SET( "users"."name", "users"."bool" )
+            GROUPING SETS( "users"."name", "users"."bool" )
           }
         end
 
@@ -246,7 +246,7 @@ module Arel
           group2 = Arel::Nodes::GroupingElement.new([@table[:bool], @table[:created_at]])
           node = Arel::Nodes::GroupingSet.new([group1, group2])
           compile(node).must_be_like %{
-            GROUPING SET( ( "users"."name" ), ( "users"."bool", "users"."created_at" ) )
+            GROUPING SETS( ( "users"."name" ), ( "users"."bool", "users"."created_at" ) )
           }
         end
       end