diff options
author | Alexander Staubo <alex@bengler.no> | 2014-06-22 19:13:37 -0400 |
---|---|---|
committer | Alexander Staubo <alex@bengler.no> | 2014-06-22 19:13:37 -0400 |
commit | 4a72415555de19ca33c8ea16ee9ba26d1b73b078 (patch) | |
tree | a015fcbaf2ab27d88f79122889ee409940f02a73 /test | |
parent | d9347943a22076911155d9a56d9a3ef6e022994b (diff) | |
download | rails-4a72415555de19ca33c8ea16ee9ba26d1b73b078.tar.gz rails-4a72415555de19ca33c8ea16ee9ba26d1b73b078.tar.bz2 rails-4a72415555de19ca33c8ea16ee9ba26d1b73b078.zip |
Add test for window + partition + order.
Diffstat (limited to 'test')
-rw-r--r-- | test/test_select_manager.rb | 11 |
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 |