From: daviscabral at gmail dot com Operating system: Linux (Slackware) PHP version: 4.3.10 PHP Bug Type: InterBase related Bug description: time/timestamp return
Description: ------------ Yesterday, our systems was update. PHP that was 4.3.7 went to 4.3.10. After this, data from database returns wrong. I believe that is a problem with extension. My problem is exactly with the SQL instruction (the code is exctaly the same): SELECT MOD_ID, MOD_NOME, MOD_SIGLA, MOD_HRINIMANHA, MOD_HRFINMANHA, MOD_HRINITARDE, MOD_HRFINTARDE, MOD_TEMPOMAX FROM MODULO WHERE MOD_ID = 9999 Return in 4.3.7 9999 | 4 | Diversos | DIV | 09:00:00 | 12:00:00 | 13:30:00 | 18:00:00 | 06:00:00 Return in 4.3.10 9999 | 4 | Diversos | DIV | 17:39:24 | 17:39:24 | 17:39:24 | 17:39:24 | 17:39:24 Reproduce code: --------------- SELECT MOD_ID, MOD_NOME, MOD_SIGLA, MOD_HRINIMANHA, MOD_HRFINMANHA, MOD_HRINITARDE, MOD_HRFINTARDE, MOD_TEMPOMAX FROM MODULO WHERE MOD_ID = 9999 Expected result: ---------------- Return in 4.3.7 9999 | 4 | Diversos | DIV | 09:00:00 | 12:00:00 | 13:30:00 | 18:00:00 | 06:00:00 Actual result: -------------- Return in 4.3.10 9999 | 4 | Diversos | DIV | 17:39:24 | 17:39:24 | 17:39:24 | 17:39:24 | 17:39:24 -- Edit bug report at http://bugs.php.net/?id=32502&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=32502&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=32502&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=32502&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=32502&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=32502&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=32502&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=32502&r=needscript Try newer version: http://bugs.php.net/fix.php?id=32502&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=32502&r=support Expected behavior: http://bugs.php.net/fix.php?id=32502&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=32502&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=32502&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=32502&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=32502&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=32502&r=dst IIS Stability: http://bugs.php.net/fix.php?id=32502&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=32502&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=32502&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=32502&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=32502&r=mysqlcfg
