Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Wrong result in TiKV of year comparsion #59001

Open
Dylan0222 opened this issue Jan 17, 2025 · 0 comments
Open

Wrong result in TiKV of year comparsion #59001

Dylan0222 opened this issue Jan 17, 2025 · 0 comments
Labels
sig/execution SIG execution type/bug The issue is confirmed as a bug.

Comments

@Dylan0222
Copy link

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

DROP TABLE IF EXISTS t0;
CREATE TABLE t0(c0 YEAR NOT NULL );
CREATE INDEX i0 ON t0(c0);
REPLACE INTO t0(c0) VALUES ('1935'), ('1982');
ALTER TABLE t0 SET TIFLASH REPLICA 1;
SELECT /*+ READ_FROM_STORAGE(tikv[t0]) */ t0.c0 FROM t0 WHERE 0.025 <= t0.c0;
SELECT /*+ READ_FROM_STORAGE(tiflash[t0]) */ t0.c0 FROM t0 WHERE 0.025 <= t0.c0;

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

see the following case: TiKV and Tiflash return different result

3. What did you see instead (Required)

mysql> SELECT /*+ READ_FROM_STORAGE(tiflash[t0]) */ t0.c0 FROM t0 WHERE 0.025 <= t0.c0;
+------+
| c0   |
+------+
| 1935 |
| 1982 |
+------+
2 rows in set (0.04 sec)

mysql> SELECT /*+ READ_FROM_STORAGE(tikv[t0]) */ t0.c0 FROM t0 WHERE 0.025 <= t0.c0;
Empty set (0.04 sec)

4. What is your TiDB version? (Required)

8.5.0

@Dylan0222 Dylan0222 added the type/bug The issue is confirmed as a bug. label Jan 17, 2025
@jebter jebter added the sig/execution SIG execution label Jan 17, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
sig/execution SIG execution type/bug The issue is confirmed as a bug.
Projects
None yet
Development

No branches or pull requests

2 participants