[MDEV-11434] POW, EXP, other functions error out with floating point exponents whereas MySQL handles correctly Created: 2016-12-01  Updated: 2016-12-26  Resolved: 2016-12-26

Status: Closed
Project: MariaDB Server
Component/s: Parser
Affects Version/s: 5.5.50
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Lenny Grover Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: need_feedback
Environment:

CentOS 7



 Description   

The POW, EXP and other built-in functions do not accept floating point values as exponents. Whereas the older version of MySQL that we were using correctly calculating floating point powers, the newer MariaDB version does not. Ideally, the functions would be updated to support floating point exponents.



 Comments   
Comment by Sergei Golubchik [ 2016-12-09 ]

Could you show an example of a query that doesn't work?

Comment by Lenny Grover [ 2016-12-09 ]

Strangely, the issue appears to have resolved itself; a query that had been generating an error is now working properly under the same configuration. I will continue to monitor the issue, but it may be the result of a different problem than I initially expected.

Comment by Elena Stepanova [ 2016-12-26 ]

Closing for now. If you observe the problem again, or have any new information regarding it, please comment and the report will be re-opened.

Generated at Thu Feb 08 07:49:55 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.