diff options
author | Aaron Patterson <aaron.patterson@gmail.com> | 2015-07-14 10:19:28 -0700 |
---|---|---|
committer | Aaron Patterson <aaron.patterson@gmail.com> | 2015-07-14 10:19:28 -0700 |
commit | 935796f4fd7d75950db87156d6540028a9044fdf (patch) | |
tree | 6b762a2ee2bbef21c58c696f25acd83de0381662 /test/visitors | |
parent | 76694a9b9994428838a81746a37e26f698aa4c67 (diff) | |
parent | 0e1427e917a4e47dce9f02ad9309600073622c73 (diff) | |
download | rails-935796f4fd7d75950db87156d6540028a9044fdf.tar.gz rails-935796f4fd7d75950db87156d6540028a9044fdf.tar.bz2 rails-935796f4fd7d75950db87156d6540028a9044fdf.zip |
Merge pull request #337 from yahonda/support_oracle12_top_n_2
Support Oracle 12c top-N query
Diffstat (limited to 'test/visitors')
-rw-r--r-- | test/visitors/test_oracle12.rb | 47 |
1 files changed, 47 insertions, 0 deletions
diff --git a/test/visitors/test_oracle12.rb b/test/visitors/test_oracle12.rb new file mode 100644 index 0000000000..cfa130fcab --- /dev/null +++ b/test/visitors/test_oracle12.rb @@ -0,0 +1,47 @@ +require 'helper' + +module Arel + module Visitors + describe 'the oracle visitor' do + before do + @visitor = Oracle12.new Table.engine.connection_pool + end + + def compile node + @visitor.accept(node, Collectors::SQLString.new).value + end + + it 'modified except to be minus' do + left = Nodes::SqlLiteral.new("SELECT * FROM users WHERE age > 10") + right = Nodes::SqlLiteral.new("SELECT * FROM users WHERE age > 20") + sql = compile Nodes::Except.new(left, right) + sql.must_be_like %{ + ( SELECT * FROM users WHERE age > 10 MINUS SELECT * FROM users WHERE age > 20 ) + } + end + + it 'generates select options offset then limit' do + stmt = Nodes::SelectStatement.new + stmt.offset = Nodes::Offset.new(1) + stmt.limit = Nodes::Limit.new(Nodes.build_quoted(10)) + sql = compile(stmt) + sql.must_be_like "SELECT OFFSET 1 ROWS FETCH FIRST 10 ROWS ONLY" + end + + describe 'locking' do + it 'removes limit when locking' do + stmt = Nodes::SelectStatement.new + stmt.limit = Nodes::Limit.new(Nodes.build_quoted(10)) + stmt.lock = Nodes::Lock.new(Arel.sql('FOR UPDATE')) + sql = compile(stmt) + sql.must_be_like "SELECT FOR UPDATE" + end + + it 'defaults to FOR UPDATE when locking' do + node = Nodes::Lock.new(Arel.sql('FOR UPDATE')) + compile(node).must_be_like "FOR UPDATE" + end + end + end + end +end |