Bug #65952 [Opn->Fbk]: Invalid buffer position in Prepared Statement

Edit report at https://bugs.php.net/bug.php?id=65952&edit=1 ID: 65952 Updated by: cmb@php.net Reported by: wils dot solutions at gmail dot com Summary: Invalid buffer position in Prepared Statement -Status: Open +Status: Feedback Type: Bug Package: PDO ODBC Operating System: Centos6 PHP Version: 5.4.21 -Assigned To: +Assigned To: cmb Block user comment: N Private report: N New Comment: Can anybody reproduce this with any of the actively supported PHP versions[1]? [1] <https://www.php.net/supported-versions.php> Previous Comments: ------------------------------------------------------------------------ [2013-10-23 15:36:45] wils dot solutions at gmail dot com Description: ------------ I was trying to use PDO_ODBC with HP Vertica but it returns the "Invalid buffer position" error. I don't have this problem using ODBC Functions and I am using it now instead of PDO_ODBC but decided to report the issue anyways... By looking at the ODBC trace files, I see that when pdo_odbc binds parameter, it always sets the BufferLength argument of the SQLBindParameter() function to 0. I believe this is wrong, since the input is a character type, and as a result there is a buffer overrun. Test script: --------------- $query = "select * from category where name = :nome"; $sth = $this->_lnk->prepare($query); $category = 'Hardcore'; $sth->bindParam(':nome', $category); $sth->execute(); Expected result: ---------------- The query result Actual result: -------------- Fails with error: Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 50240 [Vertica][Support] (50240) Invalid buffer position. (SQLExecute[50240] at /builddir/build/BUILD/php-5.4.21/ext/pdo_odbc/odbc_stmt.c:254)' in /admin_vertica_report.class.php on line 39 ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=65952&edit=1