Event Limitations

You are viewing an old version of this article. View the current version here.

The following restrictions apply to Events.

  • All of the restrictions listed in Stored Routine Limitations.
  • Events cannot return a resultset.
  • Event names are case insensitive, so it's not possible to define two events in the same database if their case insensitive names will match. This restriction has applied since MariaDB/MySQL 5.1.8. If you are upgrading from an older version of MySQL, and have events that could clash, these events need to be renamed before the upgrade.
  • Events do not support dates beyond the maximum that can be represented in the Unix epoch (2038-01-19).
  • Events cannot be created, dropped or altered by another stored program, trigger or event.
  • Events cannot create, drop or alter stored programs or triggers
  • Event timings cannot be strictly predicted. The intervals MONTH, YEAR_MONTH, QUARTER and YEAR are all resolved in months. All others are resolved in seconds. A delay of up to two seconds is possible in extreme cases, and events scheduled to run at the same second cannot be executed in a given order. The LAST_EXECUTED column in the INFORMATION_SCHEMA.EVENTS table will however always be accurate to within a second.
  • A new connection is used for each execution of statements within the body of an event, so the session counts for server status variables such as Com_delete and Com_select will not reflect these.
  • Because the Event Scheduler depends on grant tables for its functionality, it is automatically disabled when the server is running with --skip-grant-tables.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.