ODBC HY010 when binding parameter that is larger than the column definition

[jfowler8708]

Description

The following code:

<?php
$connection = new \PDO("odbc:DRIVER={ODBC Driver 17 for SQL Server};host=<host>", "<username>", "<password>");
$query = "select itm_code from item where itm_number = :itemNumber";
$parameters = [":itemNumber" => "123456"]; // itm_number column defined as varchar(5) parameter is char(6)
$prepared = $connection->prepare($query);
$results = $prepared->execute($parameters);
?>

Resulted in this output:

SQLSTATE[HY010]: Function sequence error: [unixODBC][Driver Manager]Function sequence error (SQLExecute[0] at /build/php8.1-8.1.9/ext/pdo_odbc/odbc_stmt.c:254)

The error only happens when the bound parameter is larger than the column as defined. Does not happen when using literals within the query string. I would expect to just receive 0 results not an error.

PHP Version

PHP 8.1.9

Operating System

Debain 10.11

[cmb69]

Yeah, that is a known issue. We definitely need to fix the error handling. I'm not sure about actually trying to fix this issue, especially since apparently only some drivers have an issue with binding such overlong values.

[cmb69]

I'm not sure about actually trying to fix this issue, especially since apparently only some drivers have an issue with binding such overlong values.

After some further investigation, I don't think that we can silently truncate overlong parameters, since this would break the behavior for drivers not reporting failure on SQLPutData(), because they now might yield different results; e.g. the MySQL ODBC driver would have an empty result for the given script (without any reported error), but could have a non-empty result if we used "12345" as parameter. As such, we're stuck with fixing the error handling.