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