From 4fe6bdf195336d54b082ca26b96c5294d8aae3d1 Mon Sep 17 00:00:00 2001 From: Emilio Tagua Date: Mon, 28 Dec 2009 10:45:11 -0300 Subject: Don't try to lock reads when using any SQLite adapter, it's redundant and may generate an invalid query. --- spec/arel/engines/sql/unit/relations/lock_spec.rb | 18 ++++++++++++++++-- 1 file changed, 16 insertions(+), 2 deletions(-) (limited to 'spec/arel') 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 -- cgit v1.2.3