Incompatible Results for GREATEST Function #53694
Labels
compatibility-mysql8
This is a compatibility issue with MySQL 8.0(but NOT 5.7)
severity/minor
sig/execution
SIG execution
type/bug
The issue is confirmed as a bug.
Bug Report
There is a compatibility issue between TiDB and MySQL 8 when using the GREATEST function.
1. Minimal reproduce step (Required)
Set up the table:
Execute the following query:
Observed Results:
MySQL8 returns 8.127934079803597e27 and TiDB returns 8127934079803597000000000000
2. What did you expect to see? (Required)
The query returns the same result in both MySQL 8 and TiDB.
3. What did you see instead (Required)
See part 1.
4. What is your TiDB version? (Required)
Release Version: v7.5.1
Edition: Community
Git Commit Hash: 7d16cc7
Git Branch: heads/refs/tags/v7.5.1
UTC Build Time: 2024-02-27 14:30:59
GoVersion: go1.21.6
Race Enabled: false
Check Table Before Drop: false
Store: tikv
The text was updated successfully, but these errors were encountered: