Bug #118489 The number of attributes is larger than the number of attribute values provided

• Submitted: 19 Jun 12:09
• Modified: 19 Jul 13:31
• Reporter: ΕΜΜΑΝΟΥΗΛ ΣΙΓΑΛΑΣ
• Status: No Feedback
• Category: Connector / ODBC
• Severity: S3 (Non-critical)
• Version: 9.1.0
• OS: Windows (10 Pro 64bit)
• Assigned to: MySQL Verification Team
• CPU Architecture: x86

[19 Jun 12:09] ΕΜΜΑΝΟΥΗΛ ΣΙΓΑΛΑΣ

Description:
Using MS Access form connected to MySQL via ODBC, attempt to delete record

DELETE operations via ODBC 9.x fail with 'The number of attributes is larger than the number of attribute values provided' error

Full error message : 
ODBC-Η διαγραφή σε συνδεδεμένο πίνακα 'parmtkeid' απέτυχε
[MySQL][ODBC 9.1(w) Driver][mysqld-5.7.40-log]The number of attributes is larger than the number of attribute values provided(#0)

How to repeat:
Connect a table from MySQL to an Access 365 file via ODBC 9.1.0 or 9.2.0
Then try to delete a record from the table

Suggested fix:
There is no problem if I use ODBC 8.3.0

[19 Jun 13:31] MySQL Verification Team

Hello ΕΜΜΑΝΟΥΗΛ ΣΙΓΑΛΑΣ,

Thank you for the bug report.
Could you please provide DDL for the table and sample data to reproduce this issue at our end?

Regards,
Ashwini Patil

[20 Jul 1:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".