https://www.percona.com/blog/uncommon-sense-mysql-when-explain-can-trash-your-database/ Tue, 24 Nov 2020 17:03:53 +0000 hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/uncommon-sense-mysql-when-explain-can-trash-your-database/#comment-10972854 Tue, 24 Nov 2020 17:03:53 +0000 https://www.percona.com/blog/?p=72794#comment-10972854 I agree. In practice through people do not always follow best practices and we need to care about behavior for such people too.

]]> https://www.percona.com/blog/uncommon-sense-mysql-when-explain-can-trash-your-database/#comment-10972853 Tue, 24 Nov 2020 16:52:03 +0000 https://www.percona.com/blog/?p=72794#comment-10972853 Nope. But there is a test case right in the blog post so you can test it and let us know!

]]> https://www.percona.com/blog/uncommon-sense-mysql-when-explain-can-trash-your-database/#comment-10972852 Tue, 24 Nov 2020 07:07:54 +0000 https://www.percona.com/blog/?p=72794#comment-10972852 Did you have a chance to test if it affects MariaDB too?

]]> https://www.percona.com/blog/uncommon-sense-mysql-when-explain-can-trash-your-database/#comment-10972850 Tue, 24 Nov 2020 00:12:18 +0000 https://www.percona.com/blog/?p=72794#comment-10972850 It is a bad idea to create functions that change data, in a best practices sense. Stored routines should modify data, and stored functions should just display it. Obviously, the SQL standard and MySQL allow stored functions to modify data, but because this side effect is well known, that is not a best practice, and it should be avoided.

]]>