php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #73447 Floats written to character fields are truncated to integer
Submitted: 2016-11-02 18:42 UTC Modified: 2016-11-02 19:08 UTC
From: cmb@php.net Assigned: cmb (profile)
Status: Closed Package: dbase (PECL)
PHP Version: 5.6.27 OS: *
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
7 + 12 = ?
Subscribe to this entry?

 
 [2016-11-02 18:42 UTC] cmb@php.net
Description:
------------
If a float value is written to a character field ('C') all decimals are
discarded, and only the integral part of the number is written. Also,
the number is right padded to the field length. This regression has been
introduced by fixing bug #39305.


Test script:
---------------
<?php

$filename = __DIR__ . DIRECTORY_SEPARATOR . 'dbase-trunc.dbf';

$db = dbase_create($filename, [['FLOAT', 'C', 15]]);

dbase_add_record($db, [123.45]);
var_dump(dbase_get_record_with_names($db, 1));


Expected result:
----------------
array(2) {
  ["FLOAT"]=>
  string(15) "123.45         "
  ["deleted"]=>
  int(0)
}


Actual result:
--------------
array(2) {
  ["FLOAT"]=>
  string(15) "            123"
  ["deleted"]=>
  int(0)
}

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2016-11-02 18:42 UTC] cmb@php.net
-Assigned To: +Assigned To: cmb
 [2016-11-02 18:55 UTC] cmb@php.net
Automatic comment from SVN on behalf of cmb
Revision: http://svn.php.net/viewvc/?view=revision&amp;revision=340846
Log: Fix #73447: Floats written to character fields are truncated to integer

We must not apply _php_math_number_format_ex() on fields where db_fdc
doesn't have a meaningful value. Instead we can rely on normal to string
conversion for these cases.
 [2016-11-02 19:08 UTC] cmb@php.net
-Status: Assigned +Status: Closed
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Wed Jul 24 18:01:29 2024 UTC