#48324 [NEW]: oci_bind_by_name returning wrong id value

From: roger dot robins at det dot nsw dot edu dot au Operating system: Linux Redhat ES 3.0 PHP version: 5.2.9 PHP Bug Type: OCI8 related Bug description: oci_bind_by_name returning wrong id value Description: ------------ When INSERTing a record into a table that has a database sequence for calculating the table id (unique identifier) and that sequence's next_val has reached double figures; and you use oci_bind_by_name to return the id of the inserted row; then only the first digit of the two digit row id is returned. Code: $sql = "INSERT INTO {$this->prefix}$table ($fields) VALUES($values) $returning"; $id = null; $this->query_start($sql, $params, SQL_QUERY_INSERT); $stmt = $this->parse_query($sql); $descriptors = $this->bind_params($stmt, $params, $table); if ($returning) { oci_bind_by_name($stmt, ":oracle_id", $id, -1, SQLT_LNG); } $result = oci_execute($stmt); $this->free_descriptors($descriptors); $this->query_end($result, $stmt); oci_free_statement($stmt); Reproduce code: --------------- Environment: PHP 5.2.9 compiled again Oracle 10.2 or 11.1 client, connecting to Oracle 10.2 database. './configure' '--with-apxs2=/usr/local/apache/bin/apxs' '--with-mysql=/usr/bin' '--enable-soap' '--with-curl' '--with-xmlrpc' '--enable-mbstring' '--with-openssl' '--enable-zip' '--with-ldap' '--with-oci8=/apps/oraoid/app/oraoid/product/11.1.0/client_1' Expected result: ---------------- When the database table sequence reaches double figures, the correct table (seed) id should be returned as a result of sql INSERT command and calling oci_bind_by_name. Actual result: -------------- The id returned is only the first digit of the real row id. -- Edit bug report at http://bugs.php.net/?id=48324&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=48324&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=48324&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=48324&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=48324&r=fixedcvs Fixed in CVS and need be documented: http://bugs.php.net/fix.php?id=48324&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=48324&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=48324&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=48324&r=needscript Try newer version: http://bugs.php.net/fix.php?id=48324&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=48324&r=support Expected behavior: http://bugs.php.net/fix.php?id=48324&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=48324&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=48324&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=48324&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=48324&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=48324&r=dst IIS Stability: http://bugs.php.net/fix.php?id=48324&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=48324&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=48324&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=48324&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=48324&r=mysqlcfg