{"id":11562,"date":"2015-06-23T10:17:04","date_gmt":"2015-06-23T14:17:04","guid":{"rendered":"http:\/\/mjtsai.com\/blog\/?p=11562"},"modified":"2015-06-23T10:17:04","modified_gmt":"2015-06-23T14:17:04","slug":"10-year-old-mysql-bug","status":"publish","type":"post","link":"https:\/\/mjtsai.com\/blog\/2015\/06\/23\/10-year-old-mysql-bug\/","title":{"rendered":"10-Year-Old MySQL Bug"},"content":{"rendered":"<p><a href=\"https:\/\/bugs.mysql.com\/bug.php?id=11472\">Omer Barnir<\/a> (via <a href=\"https:\/\/twitter.com\/steipete\/status\/612739739985268736\">Peter Steinberger<\/a>):<\/p>\n<blockquote cite=\"https:\/\/bugs.mysql.com\/bug.php?id=11472\"><p>When rows of a table are updated\/deleted indirectly as a result of a foreign key definition on the table, triggers on that table are not executed as required[&#8230;]<\/p><\/blockquote>\n<p><a href=\"http:\/\/bugs.mysql.com\/bug.php?id=70380\">Wayne Chan<\/a>:<\/p>\n<blockquote cite=\"http:\/\/bugs.mysql.com\/bug.php?id=70380\"><p>There is no clean workaround that could achieve this functionality. I appreciate the work that the Mysql has put into this wonderful DBMS, but why not just go a little bit further to make this a complete product? I would really, really appreciate if someone can address this problem, which frankly, is a bug because this makes Mysql non-ACID compliant.<\/p><\/blockquote>","protected":false},"excerpt":{"rendered":"<p>Omer Barnir (via Peter Steinberger): When rows of a table are updated\/deleted indirectly as a result of a foreign key definition on the table, triggers on that table are not executed as required[&#8230;] Wayne Chan: There is no clean workaround that could achieve this functionality. I appreciate the work that the Mysql has put into [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"apple_news_api_created_at":"","apple_news_api_id":"","apple_news_api_modified_at":"","apple_news_api_revision":"","apple_news_api_share_url":"","apple_news_coverimage":0,"apple_news_coverimage_caption":"","apple_news_is_hidden":false,"apple_news_is_paid":false,"apple_news_is_preview":false,"apple_news_is_sponsored":false,"apple_news_maturity_rating":"","apple_news_metadata":"\"\"","apple_news_pullquote":"","apple_news_pullquote_position":"","apple_news_slug":"","apple_news_sections":"\"\"","apple_news_suppress_video_url":false,"apple_news_use_image_component":false,"footnotes":""},"categories":[2],"tags":[131,143,1189],"class_list":["post-11562","post","type-post","status-publish","format-standard","hentry","category-technology","tag-bug","tag-database","tag-mysql"],"apple_news_notices":[],"_links":{"self":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/11562","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/comments?post=11562"}],"version-history":[{"count":1,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/11562\/revisions"}],"predecessor-version":[{"id":11563,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/11562\/revisions\/11563"}],"wp:attachment":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/media?parent=11562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/categories?post=11562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/tags?post=11562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}