Title: [618] trunk/activerecord-jdbc: db2 correctly not-quoting decimal values
Revision
618
Author
stuarthalloway
Date
2007-06-08 11:07:53 -0400 (Fri, 08 Jun 2007)

Log Message

db2 correctly not-quoting decimal values

Modified Paths


Added Paths

Diff

Modified: trunk/activerecord-jdbc/lib/jdbc_adapter/jdbc_db2.rb (617 => 618)


--- trunk/activerecord-jdbc/lib/jdbc_adapter/jdbc_db2.rb	2007-06-08 01:46:01 UTC (rev 617)
+++ trunk/activerecord-jdbc/lib/jdbc_adapter/jdbc_db2.rb	2007-06-08 15:07:53 UTC (rev 618)
@@ -57,6 +57,9 @@
       if column && column.type == :primary_key
         return value.to_s
       end
+      if column && column.type == :decimal && value
+        return value.to_s
+      end
       case value
       when String                
         if column && column.type == :binary

Added: trunk/activerecord-jdbc/test/jdbc_adapter/jdbc_db2_test.rb (0 => 618)


--- trunk/activerecord-jdbc/test/jdbc_adapter/jdbc_db2_test.rb	                        (rev 0)
+++ trunk/activerecord-jdbc/test/jdbc_adapter/jdbc_db2_test.rb	2007-06-08 15:07:53 UTC (rev 618)
@@ -0,0 +1,21 @@
+require 'java'
+require 'lib/jdbc_adapter/jdbc_db2'
+require 'test/unit'
+
+class JdbcSpec::DB2Test < Test::Unit::TestCase
+  def setup
+    @inst = Object.new
+    @inst.extend JdbcSpec::DB2
+    @column = Object.new
+    class <<@column
+      attr_accessor :type
+    end
+  end
+  
+  def test_quote_decimal
+    assert_equal %q{'123.45'}, @inst.quote("123.45")
+    @column.type = :decimal
+    assert_equal %q{123.45}, @inst.quote("123.45", @column), "decimal columns should not have quotes"
+  end
+  
+end
_______________________________________________
Jruby-extras-devel mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/jruby-extras-devel

Reply via email to