[MDEV-6414] MariaDB-specific SQLSTATE Created: 2014-07-01  Updated: 2014-07-01  Resolved: 2014-07-01

Status: Closed
Project: MariaDB Server
Component/s: None
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Federico Razzoli Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None


 Description   

Looking at this page:
https://mariadb.com/kb/en/mariadb/mariadb-documentation/sql-language-structure/mariadb-error-codes/

most errors seems to use the 'HY000' SQLSTATE, which is also used by several MySQL errors.

I think it would be a bit more informative if such errors have a MariaDB-specific SQLSTATE. For two reasons:
1) Applications and stored procedures which must handle them, will have a small hint.
2) If MySQL will use your error codes in a future release, we can distinguish MariaDB errors using the SQLSTATE.

In case you agree, I have a suggestion: 'MARIA' is a valid SQLSTATE



 Comments   
Comment by Sergei Golubchik [ 2014-07-01 ]

Nice idea

But that's generally not possible. Sqlstate values come directly from the SQL standard, it specifies exactly what every sqlstate means. HY000 is "general error" and we use it when no more specific sqlstate code is prescribed by the standard.

Generated at Thu Feb 08 07:11:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.