1 files changed, 52 insertions, 0 deletions
diff --git a/spec/engines/memory/integration/joins/cross_engine_spec.rb b/spec/engines/memory/integration/joins/cross_engine_spec.rb
new file mode 100644
index 0000000000..606f3154c7
--- /dev/null
+++ b/spec/engines/memory/integration/joins/cross_engine_spec.rb
@@ -0,0 +1,52 @@
+require 'spec_helper'
+
+module Arel
+  describe Join do
+    before do
+      @users = Array.new([
+        [1, 'bryan' ],
+        [2, 'emilio' ],
+        [3, 'nick']
+      ], [[:id, Attributes::Integer], [:name, Attributes::String]])
+      @photos = Table.new(:photos)
+      @photos.delete
+      @photos.insert(@photos[:id] => 1, @photos[:user_id] => 1, @photos[:camera_id] => 6)
+      @photos.insert(@photos[:id] => 2, @photos[:user_id] => 2, @photos[:camera_id] => 42)
+      # Oracle adapter returns database integers as Ruby integers and not strings
+      @adapter_returns_integer = false
+      adapter_is :oracle do
+        @adapter_returns_integer = true
+      end
+    end
+
+    describe 'when the in memory relation is on the left' do
+      it 'joins across engines' do
+        @users                                         \
+          .join(@photos)                               \
+            .on(@users[:id].eq(@photos[:user_id]))     \
+          .project(@users[:name], @photos[:camera_id]) \
+        .let do |relation|
+          relation.call.should == [
+            Row.new(relation, ['bryan', @adapter_returns_integer ? 6 : '6']),
+            Row.new(relation, ['emilio', @adapter_returns_integer ? 42 : '42'])
+          ]
+        end
+      end
+    end
+
+    describe 'when the in memory relation is on the right' do
+      it 'joins across engines' do
+        @photos                                        \
+          .join(@users)                                \
+            .on(@users[:id].eq(@photos[:user_id]))     \
+          .project(@users[:name], @photos[:camera_id]) \
+        .let do |relation|
+          relation.call.should == [
+            Row.new(relation, ['bryan', @adapter_returns_integer ? 6 : '6']),
+            Row.new(relation, ['emilio', @adapter_returns_integer ? 42 : '42'])
+          ]
+        end
+      end
+    end
+  end
+end