Don't try to lock reads when using any SQLite adapter, it's redundant

and may generate an invalid query.

1 files changed, 16 insertions, 2 deletions

diff --git a/spec/arel/engines/sql/unit/relations/lock_spec.rb b/spec/arel/engines/sql/unit/relations/lock_spec.rb
index 27239eb1a8..23f8a9f577 100644
--- a/spec/arel/engines/sql/unit/relations/lock_spec.rb
+++ b/spec/arel/engines/sql/unit/relations/lock_spec.rb
@@ -17,12 +17,19 @@ module Arel
           })
         end
 
-        adapter_is_not :mysql do
+        adapter_is :postgresql do
           sql.should be_like(%Q{
             SELECT "users"."id", "users"."name"
             FROM "users" FOR UPDATE
           })
         end
+
+        adapter_is :sqlite3 do
+          sql.should be_like(%Q{
+            SELECT "users"."id", "users"."name"
+            FROM "users"
+          })
+        end
       end
 
       it "manufactures a select query locking with a given lock" do
@@ -35,12 +42,19 @@ module Arel
           })
         end
 
-        adapter_is_not :mysql do
+        adapter_is :postgresql do
           sql.should be_like(%Q{
             SELECT "users"."id", "users"."name"
             FROM "users" LOCK IN SHARE MODE
           })
         end
+
+        adapter_is :sqlite3 do
+          sql.should be_like(%Q{
+            SELECT "users"."id", "users"."name"
+            FROM "users"
+          })
+        end
       end
     end
   end