Datamapper DataMapper

All aggregate functions (count, min, max, avg) returns inappropriate values while connecting with oracle adapter.

Oracle OCI adapter returns values of all aggregate functions as BigDecimal.

    conn = OCI8.new('user','***','Oracle1')
    conn.exec('SELECT COUNT(*) FROM "SOME_TABLE"') {|r| puts r.first.inspect}
    #<BigDecimal:8e68fc0,'0.1224E4',4(8)>

Then the return values are internally converted by DataMapper to strings and then again to numbers.
So e.g. for count:

    SomeTable.aggregate(:all.count)
    #=> 0

    #<BigDecimal:8e68fc0,'0.1224E4',4(8)> (to_s) => "0.1224E4" => (to_i) => 0

At first BigDecimal gets converted to String ("0.1224E4") and then to Integer (0).

I don't know if the problem is with dm-aggregates itself or rather at oracle-adapter.

As a workaround for 'count' to get working i've made change in dm-aggregates/adapters/dm-do-adapter.rb
changing:

      def count(property, value)
        value.to_i
      end

to

      def count(property, value)
        value.to_f.to_i
      end

now i'm getting what i've expected:

    SomeTable.aggregate(:all.count)
    #=> 1224