Skip to content

EXCEPT returns non-empty result for identical floating-point division queries with INT columns #63238

@momoway

Description

@momoway

Bug Report

1. Minimal reproduce step (Required)

CREATE TABLE t1(c INT);
INSERT INTO t1 VALUES (1);
SELECT c / 3 FROM t1 EXCEPT SELECT c / 3 FROM t1;

2. What did you expect to see? (Required)

Empty set

3. What did you see instead (Required)

+--------+
| c / 3  |
+--------+
| 0.3333 |
+--------+

4. What is your TiDB version? (Required)

tiup playground nightly --host 0.0.0.0 --kv 3 --tiflash 3
8.0.11-TiDB-v9.0.0-beta.2.pre-384-g5fab436

Metadata

Metadata

Assignees

No one assigned

    Labels

    contributionThis PR is from a community contributor.first-time-contributorIndicates that the PR was contributed by an external member and is a first-time contributor.fuzz/sqlancersig/executionSIG executiontype/bugThe issue is confirmed as a bug.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions