We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
The query: SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b) FROM t1 WHERE (a>b-2 AND a<b+2) OR c>d ORDER BY 1; return wrong result when select from tiflash: +-----------------------------------------------+ | (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b) | +-----------------------------------------------+ | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | +-----------------------------------------------+
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b) FROM t1 WHERE (a>b-2 AND a<b+2) OR c>d ORDER BY 1;
When select from tikv, it's result is +-----------------------------------------------+ | (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b) | +-----------------------------------------------+ | 0 | | 2 | | 3 | | 4 | | 6 | | 7 | | 8 | | 11 | | 13 | | 14 | | 16 | | 17 | | 18 | | 19 | | 20 | | 21 | | 22 | | 24 | | 25 | | 28 | +-----------------------------------------------+
The text was updated successfully, but these errors were encountered:
Seems caused by this pr: pingcap/tidb#17232
Sorry, something went wrong.
hanfei1991
Successfully merging a pull request may close this issue.
The query:
SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b) FROM t1 WHERE (a>b-2 AND a<b+2) OR c>d ORDER BY 1;
return wrong result when select from tiflash:+-----------------------------------------------+
| (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b) |
+-----------------------------------------------+
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
+-----------------------------------------------+
When select from tikv, it's result is
+-----------------------------------------------+
| (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b) |
+-----------------------------------------------+
| 0 |
| 2 |
| 3 |
| 4 |
| 6 |
| 7 |
| 8 |
| 11 |
| 13 |
| 14 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22 |
| 24 |
| 25 |
| 28 |
+-----------------------------------------------+
The text was updated successfully, but these errors were encountered: