aboutsummaryrefslogtreecommitdiffstats
path: root/spec/arel/visitors/oracle_spec.rb
diff options
context:
space:
mode:
Diffstat (limited to 'spec/arel/visitors/oracle_spec.rb')
-rw-r--r--spec/arel/visitors/oracle_spec.rb12
1 files changed, 12 insertions, 0 deletions
diff --git a/spec/arel/visitors/oracle_spec.rb b/spec/arel/visitors/oracle_spec.rb
index 784f4b24e1..cdf0e3427f 100644
--- a/spec/arel/visitors/oracle_spec.rb
+++ b/spec/arel/visitors/oracle_spec.rb
@@ -31,6 +31,18 @@ module Arel
check sql.should == sql2
end
+ it 'splits orders with commas' do
+ # *sigh*
+ select = "DISTINCT foo.id, FIRST_VALUE(projects.name) OVER (foo) AS alias_0__"
+ stmt = Nodes::SelectStatement.new
+ stmt.cores.first.projections << Nodes::SqlLiteral.new(select)
+ stmt.orders << Nodes::SqlLiteral.new('foo, bar')
+ sql = @visitor.accept(stmt)
+ sql.should be_like %{
+ SELECT #{select} ORDER BY alias_0__, alias_1__
+ }
+ end
+
describe 'Nodes::SelectStatement' do
describe 'limit' do
it 'adds a rownum clause' do