|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #65952 Invalid buffer position in Prepared Statement
Submitted: 2013-10-23 15:36 UTC Modified: 2014-01-01 12:27 UTC
Avg. Score:4.0 ± 0.9
Reproduced:4 of 4 (100.0%)
Same Version:1 (25.0%)
Same OS:1 (25.0%)
From: wils dot solutions at gmail dot com Assigned:
Status: Open Package: PDO ODBC
PHP Version: 5.4.21 OS: Centos6
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: wils dot solutions at gmail dot com
New email:
PHP Version: OS:


 [2013-10-23 15:36 UTC] wils dot solutions at gmail dot com
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);        

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


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2014-01-01 12:27 UTC]
-Package: PDO related +Package: PDO ODBC
PHP Copyright © 2001-2020 The PHP Group
All rights reserved.
Last updated: Wed Sep 23 19:01:39 2020 UTC