diff options
author | Rodrigo Castro <rodrigocastro@id.uff.br> | 2016-10-07 11:53:47 -0300 |
---|---|---|
committer | Rodrigo Castro <rodrigocastro@id.uff.br> | 2016-10-07 11:53:47 -0300 |
commit | 9d6e569ddfed10b437494ecb6e995048737beb44 (patch) | |
tree | d20255ace6a58aa83104f7fe387889fdbc790102 /test | |
parent | 44d2ef9623847dea5cbf6208ae7b5168b374c720 (diff) | |
download | rails-9d6e569ddfed10b437494ecb6e995048737beb44.tar.gz rails-9d6e569ddfed10b437494ecb6e995048737beb44.tar.bz2 rails-9d6e569ddfed10b437494ecb6e995048737beb44.zip |
Fix issue #438 when oracle visitor gets BindParams
Diffstat (limited to 'test')
-rw-r--r-- | test/visitors/test_oracle.rb | 16 |
1 files changed, 15 insertions, 1 deletions
diff --git a/test/visitors/test_oracle.rb b/test/visitors/test_oracle.rb index e9ed9d76b3..4c22be5cbb 100644 --- a/test/visitors/test_oracle.rb +++ b/test/visitors/test_oracle.rb @@ -124,6 +124,21 @@ module Arel } end + it 'creates a subquery when there is limit and offset with BindParams' do + stmt = Nodes::SelectStatement.new + stmt.limit = Nodes::Limit.new(Nodes::BindParam.new) + stmt.offset = Nodes::Offset.new(Nodes::BindParam.new) + sql = compile stmt + sql.must_be_like %{ + SELECT * FROM ( + SELECT raw_sql_.*, rownum raw_rnum_ + FROM (SELECT ) raw_sql_ + WHERE rownum <= (:a1 + :a2) + ) + WHERE raw_rnum_ > :a1 + } + end + it 'is idempotent with different subquery' do stmt = Nodes::SelectStatement.new stmt.limit = Nodes::Limit.new(10) @@ -148,7 +163,6 @@ module Arel } end end - end it 'modified except to be minus' do |