1981
MySQLERRORNotableUnsupported FeatureHIGH confidence
This feature is not supported yet
Production Risk
Low — statement is rejected; no data is modified.
What this means
The requested feature or syntax exists in the SQL standard or is planned, but has not yet been implemented in this version of MySQL.
Why it happens
- 1Using a SQL feature that is planned but not yet available.
- 2Running a statement valid in a newer MySQL version against an older server.
- 3Using a syntax construct recognised by the parser but not fully implemented.
How to reproduce
trigger — this will error
trigger — this will error
-- Example: certain subquery forms in older MySQL versions
expected output
ERROR 1981 (HY000): This version of MySQL doesn't yet support 'multiple triggers with the same action'.
Fix 1
Upgrade MySQL to a version that supports the feature
Upgrade MySQL to a version that supports the feature
-- Check version: SELECT VERSION();
Why this works
Newer MySQL releases progressively implement pending features.
Fix 2
Rewrite the query using supported syntax
Rewrite the query using supported syntax
-- Use equivalent supported constructs
Why this works
Work around the limitation using existing supported SQL.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 1981 ER_NOT_SUPPORTED_YET
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev