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

Error For MPP Stream #46598

Closed
bajinsheng opened this issue Sep 1, 2023 · 5 comments
Closed

Error For MPP Stream #46598

bajinsheng opened this issue Sep 1, 2023 · 5 comments

Comments

@bajinsheng
Copy link

bajinsheng commented Sep 1, 2023

Bug Report

1. Minimal reproduce step (Required)

CREATE TABLE t0(c0 INT);
ALTER TABLE t0 SET TIFLASH REPLICA 1;
SELECT SLEEP(5);

SELECT /*+ READ_FROM_STORAGE(TIKV[t0])*/t0.c0 FROM t0 WHERE INET_NTOA(t0.c0); -- empty result
SELECT t0.c0 FROM t0 WHERE INET_NTOA(t0.c0); -- ERROR 1105 (HY000): other error for mpp stream: Code: 43, e.displayText() = DB::Exception: Illegal type Int32 of argument of function IPv4NumToString, expected UInt32, e.what() = DB::Exception,

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

No error

3. What did you see instead (Required)

Executing the exactly same query second time has an unexpected error.

4. What is your TiDB version? (Required)

| Release Version: v7.3.0
Edition: Community
Git Commit Hash: 40b72e7a9a4fc9670d4c5d974dd503a3c6097471
Git Branch: heads/refs/tags/v7.3.0
UTC Build Time: 2023-08-08 10:08:14
GoVersion: go1.20.7
Race Enabled: false
Check Table Before Drop: false
Store: tikv |

Startup command:

tiup playground 7.3.0
@bajinsheng bajinsheng added the type/bug The issue is confirmed as a bug. label Sep 1, 2023
@bajinsheng
Copy link
Author

/label fuzz/sqlancer

@jebter jebter added the sig/execution SIG execution label Sep 4, 2023
@ti-chi-bot ti-chi-bot bot added may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.1 may-affects-6.5 may-affects-7.1 labels Sep 4, 2023
@windtalker
Copy link
Contributor

A bug in FunctionIPv4NumToString in TiFlash, as it require uint32 as the input type.

@solotzg
Copy link
Contributor

solotzg commented Oct 19, 2023

Fixed in pingcap/tiflash#8210

@solotzg
Copy link
Contributor

solotzg commented Oct 20, 2023

@jebter @zanmato1984 Shall we close this issue?

@windtalker
Copy link
Contributor

close as fixed by pingcap/tiflash#8210

@windtalker windtalker added affects-5.4 This bug affects 5.4.x versions. affects-7.1 and removed may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.1 may-affects-7.1 labels Feb 2, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

6 participants