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

INET_NTOA support unsigned integer (size <= 4 bytes) #8211

Closed
solotzg opened this issue Oct 18, 2023 · 0 comments · Fixed by #8210
Closed

INET_NTOA support unsigned integer (size <= 4 bytes) #8211

solotzg opened this issue Oct 18, 2023 · 0 comments · Fixed by #8210
Labels
type/bug The issue is confirmed as a bug.

Comments

@solotzg
Copy link
Contributor

solotzg commented Oct 18, 2023

ref pingcap/tidb#46598

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,
@solotzg solotzg added the type/enhancement The issue or PR belongs to an enhancement. label Oct 18, 2023
@solotzg solotzg changed the title INET_NTOA support integer (size <= 4 bytes) INET_NTOA support unsigned integer (size <= 4 bytes) Oct 19, 2023
@solotzg solotzg added affects-7.5 type/bug The issue is confirmed as a bug. and removed type/enhancement The issue or PR belongs to an enhancement. labels Oct 20, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant