Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.1.11
-
Fix Version/s: 10.1.12
-
Component/s: Data Manipulation - Update
-
Environment:Ubuntu 14.04, 15.04. Up to data packages.
-
Sprint:10.1.12
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.