[#ODBC-248] Query using IN with 1000+ varbinary bound parameters ignores trailing whitespace

When executing a query with 1000 or more bound parameters on a varbinary field such as:

SELECT c1 FROM table WHERE c1 IN (?,?....

Any record that happens to have a trailing space is not returned.
If you execute the query 999 bound parameters, all records are returned.

[MariaDB]

Description     = ODBC for MaridDB

Driver          = /usr/lib/libmaodbc.so

FileUsage       = 1

The perl test creates a table with a varbinary field, adds 999 records with every second one having a trailing space. Queries with 999 bound parameters, then repeats the query with 1000 bound parameters, of which the last one doesn't exist. It doesn't matter if I add another record and include it in the bound parameters, it's the fact that there are now 1000 that affects the results.

$ perl ./trim_in_test.pl -host=127.0.0.1 -driver={MariaDB} -user=test -passw

ord=password

Connecting to database

Creating table test_trim_in

Inserting 999 records

.......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................

Reading records

Records expected 999, Got 999

Reading records

Records expected 999, Got 499

Didn't get all rows from server (499) at ./trim_in_test.pl line 83.

The reason why I've logged this under ODBC is because the test script works with perl-DBD-MySQL

[ODBC-248] Query using IN with 1000+ varbinary bound parameters ignores trailing whitespace Created: 2019-05-10 Updated: 2020-05-12 Resolved: 2020-05-12
Status:	Closed
Project:	MariaDB Connector/ODBC
Component/s:	General
Affects Version/s:	2.0.14, 3.0.2, 3.1.1
Fix Version/s:	N/A

[ODBC-248] Query using IN with 1000+ varbinary bound parameters ignores trailing whitespace Created: 2019-05-10 Updated: 2020-05-12 Resolved: 2020-05-12