MySQL Forums
Forum List  »  Install & Repo

Text interpolated in error messages
Posted by: Luis Gaido
Date: April 10, 2020 12:07PM

Hello people!
I searched a lot on the internet, in the environment variables and in the MySQL reference. You are my last hope.
It is about the text that is interpolated in MySQL error messages.

On my machine, I have MySQL 8.0.14. When I force error 1062 (ER_DUP_ENTRY), a message like this is displayed:

Duplicate entry 'luis' for key 'name'.

The same data, commands and table structure are on another machine running 8.0.19-0ubuntu0.19.10.3, and the message displayed is:

Duplicate entry 'luis' for key ''.

Note that the indicated field has the table name as a prefix in this second case.

How do I change this behavior of prefixing or not prefixing with the table name in error messages?

Thank you in advance!

Options: ReplyQuote

Written By
Text interpolated in error messages
April 10, 2020 12:07PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.