# Issue #55191: With the same sql, the results on v6.5 are inconsistent with the results on v7.5/8.1

## Metadata
- Issue: https://github.com/pingcap/tidb/issues/55191
- Status: closed
- Type: type/bug
- Created At: 2024-08-05T09:04:34Z
- Closed At: 2024-08-07T02:53:47Z
- Labels: impact/wrong-result, may-affects-5.4, may-affects-6.1, may-affects-6.5, may-affects-7.1, may-affects-7.5, may-affects-8.1, report/customer, severity/major, sig/planner, type/bug

## Customer-Facing Phenomenon
- tidb version: 6.5.x & 8.1.0

## Linked PRs
- No linked PR was found from the issue timeline.

## Notes
- The issue is closed, but no merged PR was resolved automatically from the timeline. It may have been fixed by an internal branch, a batch PR, or manual closure.