1418 MySQL Origin: Data Last updated 15 Oct 2026

MySQL ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled

Creating a stored function failed because binary logging requires it to declare its data access characteristics.

Exact message you may see none of DETERMINISTIC, NO SQL, or READS SQL DATAbinary logging is enabled
Explore the map of this error Full error map →
Seen on: MySQL

Meaning

With binlog enabled, MySQL needs functions marked DETERMINISTIC / READS SQL DATA, or log_bin_trust_function_creators=1.

Common causes

  • Function missing characteristics
  • Importing routines on a replicated/managed server

⚡ Quick fix

  1. Add DETERMINISTIC / READS SQL DATA to the function
  2. Set log_bin_trust_function_creators=1 (parameter group on RDS)

Detailed fix by platform

MySQL

  1. CREATE FUNCTION f(x INT) RETURNS INT DETERMINISTIC RETURN x * 2;

How to diagnose

  1. Function — Declared characteristics?
  2. Recent change — Did it start after a deploy, upgrade, or configuration change? Compare with the last working version.

🔧 Still not fixed?

Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:

Where this error sits

Origin: Data. Errors that are often confused with or caused by this one (click to open):

1005 — MySQL ERROR 1005 (HY000): Can't create table (errno: 150 "Foreign key constraint is incorrectly formed") (MySQL)10051007 — MySQL ERROR 1007 (HY000): Can't create database 'x'; database exists (MySQL)10071008 — MySQL ERROR 1008 (HY000): Can't drop database 'x'; database doesn't exist (MySQL)10081022 — MySQL ERROR 1022 (23000): Can't write; duplicate key in table (MySQL)10221040 — MySQL ERROR 1040 (08004): Too many connections (MySQL)10401044 — MySQL ERROR 1044 (42000): Access denied for user to database (MySQL)10441045 — MySQL ERROR 1045 (28000): Access denied for user (MySQL)1045READONLY You can't write against a read only replica — Redis: READONLY You can't write against a read only replica (Redis)READONLY You can't wr…1418

Explore the map of this error Full error map →

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.

💬 What worked for others

No tips yet — did something else fix this for you?

Share what worked for you

Tips are checked by an editor before they appear. Links are removed.