-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Unexpected return type from concat. Expected String. Got Nullable(String) #87016
Copy link
Copy link
Closed
Closed
Copy link
Labels
analyzerIssues and pull-requests related to new analyzerIssues and pull-requests related to new analyzerbugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official releasefuzzProblem found by one of the fuzzersProblem found by one of the fuzzers
Description
Describe the bug
Setting join_use_nulls=true triggers the exception for the query
How to reproduce
SELECT DISTINCT *
FROM numbers(2) AS n1, numbers(3) AS n2
RIGHT JOIN numbers(4) AS n3 ON n2.number = n3.number
ORDER BY
toUInt64(concat(0 IS NULL, materialize(12) - 0, toNullable(1) IS NULL, concat(intDiv(materialize(0), assumeNotNull(1)), *))) ASC,
1 DESC NULLS FIRST,
n1.number DESC NULLS FIRST
SETTINGS join_use_nulls = true
Error message and/or stacktrace
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
analyzerIssues and pull-requests related to new analyzerIssues and pull-requests related to new analyzerbugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official releasefuzzProblem found by one of the fuzzersProblem found by one of the fuzzers