float precision

Hello,

It seems like everything is working fine.

I have defined one field in class as
'fees':fields.float('Fees',digits=(13,12)),

In database I am getting
 fees | numeric(13,12) |

and in database table value is

 select * from student_student;
| address_id | name | roll_no | fees
----+------------+--------------------------+----------------------------+-----------+------------+-------+---------+----------------
| 2 | husen | 1 | 1.111111111110

can you please check it again by creating new database?

Thanks.

Have you inserted the value of fees directly with sql command or using pooler with create method ??, OpenERP defines well the field in the database, but float precision in the insertion method is 6...

You can try in a python console:

'%f' %0.000125430123 (precision 6: 0.000125)

'%.12f' %0.000125430123 (precision 12: 0.000125430123)

For more information you can see in the Python Documentation Page[1], under string formatting operations section, the note number 3, which says exactly:
"The alternate form causes the result to always contain a decimal point, even if no digits follow it.
The precision determines the number of digits after the decimal point and defaults to 6."

[1] http://docs.python.org/library/stdtypes.html#string-formatting-operations

I think 'Invalid' status should be set when the discussion was finished.

Any news about this issue?

applied in branches/5.0
we periodically merge fixes from branches/5.0 to trunk

Your fix is invalid. It makes the system crash (tested on tasks creation).
Hda seems to be right, it currently works with high precisions.

%f is not anymore used in openerp server, psycopg2 requires %s.