Bug #81799 After running Log() function, it stops MySQL service and shows error message.
Submitted: 10 Jun 2016 7:30 Modified: 23 Jun 2016 7:20
Reporter: sunil kumar Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Compiling Severity:S1 (Critical)
Version:5.7.11.0 OS:Windows (Windows 2008 R2 Enterprize)
Assigned to: CPU Architecture:Any
Tags: Log() function causes error, Stops service after using Log()

[10 Jun 2016 7:30] sunil kumar
Description:
I have used Log10() function in my query, after running the query it stops the service and shows error message as mentioned below. It takes about 5-6 second before showing the error message:

"SQL Error (2013): Lost connection to MySQL during query"

I tried to run a simple query "Select Log10(1000);" and it also causes to stop service and shows error message.

I have verified the same in 5.6.X and it works fine and takes about 1-2 Sec.

Note: I have run the query in HeidiSQL 9.2.04947 64 Bit) and Navicat Lite (10.0.5 Non commercial). 

How to repeat:
Just type below query to replicate it in 5.7.11.0 version:

select Log10(1000);

Suggested fix:
It should work and show the result in relevant time as in previous versions.
[10 Jun 2016 7:45] MySQL Verification Team
I'd be willing to bet this is a duplicate of:
http://bugs.mysql.com/bug.php?id=81197
[10 Jun 2016 11:10] MySQL Verification Team
Please check if in the err log file was printed the call stack and then print it here (the log err file generally is on data directory host_name.err). Thanks.
[23 Jun 2016 7:16] sunil kumar
Thanks shane Bester and Miguel Solorzano,
I have installed windows 2008 SP1 and the issue got resolved.
[23 Jun 2016 7:20] MySQL Verification Team
Thank you for confirming.
Marking as duplicate of Bug #81197