Bug #119905 after changing SUM(tbk63.col_3) to -SUM(-tbk63.col_3) the col_2's value unexpectedly changes

• Submitted: 12 Feb 4:37
• Modified: 12 Feb 19:26
• Reporter: cl hl
• Status: Unsupported
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 9.5.0
• OS: Any
• CPU Architecture: Any

[12 Feb 4:37] cl hl

Description:
https://jira.mariadb.org/browse/MDEV-38739
In this mariadb bug.I use mysql client to connect maariadb.Because of the mysql client ,the results is inconsistent unexpectedly.Mysql unexpectedly try to transform DATE value to BIT value.

How to repeat:
enter the url:https://jira.mariadb.org/browse/MDEV-38739

[12 Feb 19:26] Roy Lyseng

Thank you for the bug report.
However, we only accept reports against products that we support.
In any case, the SUM of a DATE value (whatever that would be) is represented as an integer and not another DATE.