Connect with us

More

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

Published

on

CREATE FUNCTION printDate ()
RETURNS varchar(45)
  BEGIN RETURN
    DATE(DW)+ ' , ' +
    DATE(DAY)+ ' , ' +
    DATE(MONTH)+ ' , ' +
    DATE(YEAR);
END;

AT first was showing ERROR 1418 & failed applied. Then showing successfully applied but showing “Error getting DDL for object” “FUNCTION printDate does not exist”

and no function showing in the database

Continue Reading

Copyright © 2020 CDI Europe