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

From: Date: Thu, 21 Jan 2016 11:41:56 +0000
Subject: Bug #71422 [Opn]: Bogus ORA-01438: value larger than specified precision allowed for this column
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-198814@lists.php.net to get a copy of this message 
Edit report at https://bugs.php.net/bug.php?id=71422&edit=1

 ID:                 71422
 User updated 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:

PHP/7 branches are apparently not affected by this regression.


Previous Comments:
------------------------------------------------------------------------
[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

Thread (10 messages)

« previous php.bugs (#198814) next »