Bug #71422 [Com]: Bogus ORA-01438: value larger than specified precision allowed for this column

Edit report at https://bugs.php.net/bug.php?id=71422&edit=1 ID: 71422 Comment by: alvaro at demogracia dot com Reported by: alvaro at demogracia dot com Summary: Bogus ORA-01438: value larger than specified precision allowed for this column Status: Open Type: Bug Package: OCI8 related Operating System: Windows 7 PHP Version: 5.6.17 Block user comment: N Private report: N New Comment: Related? Fix bug 68298 (PHP OCI8 OCI int overflow) https://github.com/php/php-src/commit/3060dfd92e0126e92b1501dba807bfcd44bef53a Previous Comments: ------------------------------------------------------------------------ [2016-01-21 11:41:54] alvaro at demogracia dot com PHP/7 branches are apparently not affected by this regression. ------------------------------------------------------------------------ [2016-01-20 16:46:15] alvaro at demogracia dot com Description: ------------ After upgrading from PHP/5.6.10 to 5.6.17 it's no longer possible to insert 3 (int) in a NUMBER(1,0) column because now it triggers: ORA-01438: value larger than specified precision allowed for this column Test script: --------------- CREATE TABLE TEST ( FORMATO_IMPORTACION_ID NUMBER(1,0) DEFAULT 1 NOT NULL ); <?php $value = 3; $conn = oci_connect('test', 'test', '//example.com/xe'); $stmt = oci_parse($conn, 'INSERT INTO TEST (FORMATO_IMPORTACION_ID) VALUES (:formato_importacion_id)'); oci_bind_by_name($stmt, ':formato_importacion_id', $value, -1, SQLT_INT); oci_execute($stmt); ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=71422&edit=1