#19364 [NEW]: OCIFetch() is returning garbage on empty resultsets

From: walovaton@yahoo.com.mx Operating system: Linux Mandrake 8.2 PHP version: 4.2.3 PHP Bug Type: OCI8 related Bug description: OCIFetch() is returning garbage on empty resultsets Hello, This bug seems to be happening in any 4.2.x series, in my case 4.2.3... but not in 4.1.x series When I executed a query that returns an empty recordset (0 records), the value returned by OCIFetch() (or may be OCIResult()) is random garbage. Some times strange characters, sometimes filed names of the SELECT statement. :-S The sql query is all right, if I print the $sql and copy/paste it in sqlplus... it returns the well known message "no rows selected". Let's see a little example: $conn = OCILogon("user", "pass", "dbstring"); // the id '200' doesn't exists $sql = "select name from customers where id = '200'"; $stmt = OCIParse($conn, $sql); OCIExecute($stmt); OCIFetch($stmt); // $name should be empty, but it contains garbage $name = OCIResult($stmt, "name"); So, like in PHP 4.1.x, I was expecting a null value or something that represents an empty value... not garbage or even important information like a fragment of the SELECT statement. I tried this in both ways: (a) compiling OCI8 as a shared module and (b) compiling OCI8 as part of the php shared object, I got the same result. This is my configure string for php 4.2.3: the (b) way ./configure --with-apxs --disable-static --disable-debug --enable-inline-optimization --prefix=/usr/local/php-4.2.3 --with-config-file-path=/usr/local/php-4.2.3/etc --enable-magic-quotes --with-pear --enable-safe-mode --with-zlib=shared --with-mysql=shared,/usr --with-oci8=/opt/OraHome81 --with-pgsql=shared,/usr --with-gettext=shared --with-regex=system --enable-sysvsem --enable-sysvshm --with-mod_charset --enable-trans-sid --enable-ftp=shared and this is my configure string for php 4.1.2: (works fine) ./configure --with-apxs --disable-static --disable-debug --enable-pic --enable-inline-optimization --prefix=/usr/local --with-zlib --with-config-file-path=/usr/local/etc --enable-magic-quotes --enable-track-vars --enable-safe-mode --with-exec-dir=/usr/bin --with-regex=system --enable-sysvsem --enable-sysvshm --with-mod_charset --enable-force-cgi-redirect --enable-trans-sid --enable-ftp --with-gettext --with-freetype-dir --with-oci8=/opt/OraHome81 --with-mysql=/usr --with-pgsql=/usr I'm using gcc 3.2 (should I use gcc 2.95.X???) I was expecting to make the upgrade to php 4.2.x soon but this strange bug makes me think it twice. I hope this bug report helps you to fix the problem. If you need more information, just ask for it and I'll give you what you need. William. -- Edit bug report at http://bugs.php.net/?id=19364&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=19364&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=19364&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=19364&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=19364&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=19364&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=19364&r=support Expected behavior: http://bugs.php.net/fix.php?id=19364&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=19364&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=19364&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=19364&r=globals