# Bug fb\_adapter / fb

**URL:** <https://www.ruby-forum.com/t/bug-fb-adapter-fb/168133>\
**Category:** IT\
**Created:** [May 16, 2009, 3:33pm UTC](https://www.ruby-forum.com/t/bug-fb-adapter-fb/168133 "2009-05-16T15:33:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mariarosaria](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/e19b73/32.png) [@mariarosaria](https://www.ruby-forum.com/u/mariarosaria)\
**Post date:** [May 16, 2009, 3:33pm UTC](https://www.ruby-forum.com/t/bug-fb-adapter-fb/168133/1 "2009-05-16T15:33:38Z")

</div>

s.o.linux ubuntu server 9.0.4  
firebird version 2.1.2.18118  
rails 2.3.2  
ruby 1.8.7 patchlevel 72  
rake 0.8.5  
fb\_adapter 0.5.8  
fb 0.5.9  
passenger 2.2.2  
nginx 0.6.36

query from isql  
select sum(val\_emessi) from g1\_items where licence\_id = 6 and tipogioco  
= ‘SPORT QF’ AND TIPO = ‘A’ AND DATA \>= ‘2009/01/02’ AND DATA \<=  
‘2009/01/02’

result =\> 2837.00 …giusto

query from rails

condizioni = “data \>= ‘#{from\_date}’ and  
data \<= ‘#{to\_date}’ and  
licence\_id = ‘#{session[:licence\_id]}’ and  
tipogioco = ‘#{tipogioco}’ and  
tipo = ‘#{modo}’”  
@emessi = G1Item.sum(‘val\_emessi’, :conditions =\> condizioni)

result =\> 283700.00 … errato

In windows  
activerecord-firebird-adapter (1.0.0.9250)  
fireruby (0.4.3)  
rails 2.3.2  
firebird version 2.0.3.12981  
funziona bene

Le gems per firebird version 2.1.2.18118  
ci sono solo per linux quindi non posso provare firebird version  
2.1.2.18118  
su windows.  
Suppongo che il problema sia di fb o fb\_adapter.  
Qualcuno ha qualche notizia in merito?  
Dove posso inviare la segnalazione di errore?

Ciao e grazie per le eventuali risposte.

---

<div class="post-metadata">

**Author:** ![mariarosaria](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/e19b73/32.png) [@mariarosaria](https://www.ruby-forum.com/u/mariarosaria)\
**Post date:** [May 25, 2009, 8:39am UTC](https://www.ruby-forum.com/t/bug-fb-adapter-fb/168133/2 "2009-05-25T08:39:40Z")

</div>

Confermato:  
Data: 23/05/2009 11:33  
Mittente: Brent R.

I can confirm there is a bug interpreting the results of aggregate  
operators such as SUM and AVG. I suggest performing these operations  
in code, rather than in the database, until a fix can be made.

Brent  
[http://rubyforge.org/tracker/index.php?func=detail&aid=25938&group\_id=1774&atid=6946](http://rubyforge.org/tracker/index.php?func=detail&aid=25938&group_id=1774&atid=6946)