[MDEV-29945] COM_STMT_BULK_EXECUTE: Error message should be more verbose and contain information about row and column number. Created: 2022-11-04  Updated: 2022-11-04

Status: Open
Project: MariaDB Server
Component/s: Prepared Statements
Fix Version/s: None

Type: Task Priority: Major
Reporter: Georg Richter Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Original user question: https://stackoverflow.com/questions/74304246/how-to-have-specific-information-in-mariadb-error-python

If a bulk operation fails, the server returns the standard error message, e.g. "a foreign key constraint failed". Especially when dealing with large arrays it is very hard and painful to walk through all the values and check the reason for this error.

Since the server already knows which row and value ​​caused this error, a more verbose error message like "A foreign key constraint failed at row x, column y" would be helpful.


Generated at Thu Feb 08 10:12:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.