From 538faf2ebc0e0e52a876f3be59c6219f620c780b Mon Sep 17 00:00:00 2001 From: Raimonds Simanovskis Date: Wed, 29 Sep 2010 11:56:54 +0300 Subject: added missing require 'spec_helper' in crud_spec.rb --- spec/crud_spec.rb | 2 ++ 1 file changed, 2 insertions(+) (limited to 'spec') diff --git a/spec/crud_spec.rb b/spec/crud_spec.rb index 3485df6685..36b2a0b4e4 100644 --- a/spec/crud_spec.rb +++ b/spec/crud_spec.rb @@ -1,3 +1,5 @@ +require 'spec_helper' + module Arel class FakeCrudder < SelectManager class FakeEngine -- cgit v1.2.3 From e619462165bfab5bee85f9761df7f48a6b8f30f0 Mon Sep 17 00:00:00 2001 From: Raimonds Simanovskis Date: Wed, 29 Sep 2010 13:10:17 +0300 Subject: use subquery for limit when DISTINCT is used (in Oracle) --- spec/visitors/oracle_spec.rb | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'spec') diff --git a/spec/visitors/oracle_spec.rb b/spec/visitors/oracle_spec.rb index cdf0e3427f..93ade3ef3c 100644 --- a/spec/visitors/oracle_spec.rb +++ b/spec/visitors/oracle_spec.rb @@ -71,6 +71,16 @@ module Arel } end + it 'creates a subquery when there is DISTINCT' do + stmt = Nodes::SelectStatement.new + stmt.cores.first.projections << Nodes::SqlLiteral.new('DISTINCT id') + stmt.limit = 10 + sql = @visitor.accept stmt + sql.should be_like %{ + SELECT * FROM (SELECT DISTINCT id) WHERE ROWNUM <= 10 + } + end + it 'creates a different subquery when there is an offset' do stmt = Nodes::SelectStatement.new stmt.limit = 10 -- cgit v1.2.3