spec/arel/engines/sql/unit/primitives/literal_spec.rb in arel-0.1.0 vs spec/arel/engines/sql/unit/primitives/literal_spec.rb in arel-0.1.2

@@ -1,6 +1,6 @@
-require File.join(File.dirname(__FILE__), '..', '..', '..', '..', '..', 'spec_helper')
+require 'spec_helper'
 
 module Arel
   describe SqlLiteral do
     before do
       @relation = Table.new(:users)
@@ -14,9 +14,21 @@
           sql.should be_like(%Q{SELECT COUNT(*) AS count_id FROM `users`})
         end
 
         adapter_is_not :mysql do
           sql.should be_like(%Q{SELECT COUNT(*) AS count_id FROM "users"})
+        end
+      end
+
+      it "manufactures expressions on literal SQL fragment" do
+        sql = @relation.project(SqlLiteral.new("2 * credit_limit").sum).to_sql
+
+        adapter_is :mysql do
+          sql.should be_like(%Q{SELECT SUM(2 * credit_limit) AS sum_id FROM `users`})
+        end
+
+        adapter_is_not :mysql do
+          sql.should be_like(%Q{SELECT SUM(2 * credit_limit) AS sum_id FROM "users"})
         end
       end
     end
   end
 end