#42173 [NEW]: Query with "INTERVAL DAY TO SECOND" returns false

From: Date: Thu, 02 Aug 2007 05:23:20 +0000
Subject: #42173 [NEW]: Query with "INTERVAL DAY TO SECOND" returns false
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-115664@lists.php.net to get a copy of this message
From: sixd@php.net Operating system: n/a PHP version: 6CVS-2007-08-02 (CVS) PHP Bug Type: OCI8 related Bug description: Query with "INTERVAL DAY TO SECOND" returns false Description: ------------ Queries for INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND work in PHP5, but the latter returns a null value in PHP6 with unicode.semantics=On due to the outcol storage size being too short. A second issue with PHP5 and PHP6 is that oci_field_type() doesn't know these two types nor the type TIMESTAMP WITH LOCAL TIMEZONE. -- Edit bug report at http://bugs.php.net/?id=42173&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=42173&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=42173&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=42173&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=42173&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=42173&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=42173&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=42173&r=needscript Try newer version: http://bugs.php.net/fix.php?id=42173&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=42173&r=support Expected behavior: http://bugs.php.net/fix.php?id=42173&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=42173&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=42173&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=42173&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=42173&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=42173&r=dst IIS Stability: http://bugs.php.net/fix.php?id=42173&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=42173&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=42173&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=42173&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=42173&r=mysqlcfg

« previous php.bugs (#115664) next »