RFloat returns wrong value

[atarkowska]

DB lensNA = 1.4

_lensNA = object #37 (::omero::RFloat)
           {
               _val = 1.39999997616
           }

[jmoore]

r3436 has failing tests. This issue shows up as soon as you query the db via jdbc:

  SELECT lensna FROM objective

Note how this is not the case for doubles.

[jmoore]

r3494 and r3496 convert all float fields to doubles. No changes were needed to the database since that conversion took place in #803

[atarkowska]

This time RDouble return wrong val

DB Pixel.physicalsizex = 0.31415

object #0 (::omero::RDouble)
{
    _val = 0.314150005579
}

[jmoore]

I have this in my db:

omero4.0.1=# select id, lensna from objective order by id desc;
  id  | lensna  
------+---------
 1354 | 1.03333
 1353 |  1.1125
 1352 |   1.225
 1351 |    1.35
 1350 |     1.4
 1322 |        

created in unit tests. Ola's db looks like this:

ola=# select id, physicalsizex, physicalsizey, physicalsizez from pixels;
 id  |   physicalsizex   |   physicalsizey   |   physicalsizez   
-----+-------------------+-------------------+-------------------
  50 | 0.125793963670731 | 0.125793963670731 |              0.25
  51 | 0.125789999961853 | 0.125789999961853 |              0.25
  52 | 0.125793963670731 | 0.125793963670731 |              0.25
  53 | 0.132620006799698 | 0.132620006799698 | 0.200000002980232
  54 | 0.157076463103294 | 0.157076463103294 |  1.04999995231628
  55 | 0.314152926206589 | 0.314152926206589 |  4.19999980926514
  56 | 0.314152926206589 | 0.314152926206589 |  4.19999980926514
  59 |                 0 |                 0 |                 0
  60 |                 0 |                 0 |                 0
  61 |                 0 |                 0 |                 0
  58 |                 0 |                 0 |                 0
 100 | 0.314150005578995 | 0.314150005578995 |  1.04999995231628
  57 | 0.314150005578995 | 0.314152926206589 |  4.19999980926514

[cxallan]

Fixed in r3696.