Trigger doing "SET NEW.auctionStart = NOW();" on a timestamp kills MariaDB server.

Description

Issuing a query that triggers a trigger on a timestamp field makes the mysql server go away.
Query are inside file query.log and syslog.log contain a trace.

You need two databases JosmWeb and josm_web, load JosmWeb with JosmWeb.Auction.schema.sql and JosmWeb.AuctionHasAuctionItems.schema.sql. Load josm_web with objlistaJosm.sql, run the update query inside query.log.

The same update query works in Oracle mysql-server-5.6 (and even back to 5.0).
Tested on clean install of both MariaDB 10.1 and MySQL 5.6.

Environment

Ubuntu 14.04, 15.04. Up to data packages.

Assignee

Sergei Golubchik

Reporter

Jostein Martinsen

Components

Sprint

None

Fix versions

Affects versions

Priority

Major
Configure