From 4a72415555de19ca33c8ea16ee9ba26d1b73b078 Mon Sep 17 00:00:00 2001 From: Alexander Staubo Date: Sun, 22 Jun 2014 19:13:37 -0400 Subject: Add test for window + partition + order. --- test/test_select_manager.rb | 11 +++++++++++ 1 file changed, 11 insertions(+) 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 -- cgit v1.2.3