spec/arel/engines/sql/integration/joins/with_compounds_spec.rb in arel-0.2.1 vs spec/arel/engines/sql/integration/joins/with_compounds_spec.rb in arel-0.3.0

@@ -24,12 +24,21 @@
                 INNER JOIN `photos`
                   ON `users`.`id` = `photos`.`user_id` AND asdf
               })
             end
 
-            adapter_is_not :mysql do
+            adapter_is :oracle do
               sql.should be_like(%Q{
+                SELECT "USERS"."ID", "USERS"."NAME", "PHOTOS"."ID", "PHOTOS"."USER_ID", "PHOTOS"."CAMERA_ID"
+                FROM "USERS"
+                INNER JOIN "PHOTOS"
+                  ON "USERS"."ID" = "PHOTOS"."USER_ID" AND asdf
+              })
+            end
+
+            adapter_is_not :mysql, :oracle do
+              sql.should be_like(%Q{
                 SELECT "users"."id", "users"."name", "photos"."id", "photos"."user_id", "photos"."camera_id"
                 FROM "users"
                 INNER JOIN "photos"
                   ON "users"."id" = "photos"."user_id" AND asdf
               })
@@ -57,12 +66,23 @@
                 WHERE `users`.`id` = 1
                   AND `users`.`id` = 1
               })
             end
 
-            adapter_is_not :mysql do
+            adapter_is :oracle do
               sql.should be_like(%Q{
+                SELECT "USERS"."ID", "USERS"."NAME", "PHOTOS"."ID", "PHOTOS"."USER_ID", "PHOTOS"."CAMERA_ID"
+                FROM "USERS"
+                INNER JOIN "PHOTOS"
+                  ON "USERS"."ID" = "PHOTOS"."USER_ID"
+                WHERE "USERS"."ID" = 1
+                  AND "USERS"."ID" = 1
+              })
+            end
+
+            adapter_is_not :mysql, :oracle do
+              sql.should be_like(%Q{
                 SELECT "users"."id", "users"."name", "photos"."id", "photos"."user_id", "photos"."camera_id"
                 FROM "users"
                 INNER JOIN "photos"
                   ON "users"."id" = "photos"."user_id"
                 WHERE "users"."id" = 1
@@ -88,10 +108,20 @@
                   ON `users`.`id` = `photos`.`user_id`
                 GROUP BY `users`.`id`
               })
             end
 
-            adapter_is_not :mysql do
+            adapter_is :oracle do
+              sql.should be_like(%Q{
+                SELECT "USERS"."ID", "USERS"."NAME", "PHOTOS"."ID", "PHOTOS"."USER_ID", "PHOTOS"."CAMERA_ID"
+                FROM "USERS"
+                INNER JOIN "PHOTOS"
+                  ON "USERS"."ID" = "PHOTOS"."USER_ID"
+                GROUP BY "USERS"."ID"
+              })
+            end
+
+            adapter_is_not :mysql, :oracle do
               sql.should be_like(%Q{
                 SELECT "users"."id", "users"."name", "photos"."id", "photos"."user_id", "photos"."camera_id"
                 FROM "users"
                 INNER JOIN "photos"
                   ON "users"."id" = "photos"."user_id"