aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--test/test_select_manager.rb11
1 files changed, 11 insertions, 0 deletions
diff --git a/test/test_select_manager.rb b/test/test_select_manager.rb
index 8840d40d8f..0b9756709d 100644
--- a/test/test_select_manager.rb
+++ b/test/test_select_manager.rb
@@ -736,6 +736,17 @@ module Arel
}
end
+ it 'takes a partition and an order' do
+ table = Table.new :users
+ manager = Arel::SelectManager.new Table.engine
+ manager.from table
+ manager.window('a_window').partition(table['foo']).order(table['foo'].asc)
+ manager.to_sql.must_be_like %{
+ SELECT FROM "users" WINDOW "a_window" AS (PARTITION BY "users"."foo"
+ ORDER BY "users"."foo" ASC)
+ }
+ end
+
it 'takes a partition with multiple columns' do
table = Table.new :users
manager = Arel::SelectManager.new Table.engine