Select 'aaa' || 'bbbb' bug

Dremio University
1

Dremio query bug
select ‘1111’ || nullif(‘a’,‘a’) as test1
result is null , Correct results is ‘1111’
the code com/dremio/exec/expr/fn/impl/StringFunctions.java

@FunctionTemplate(name = “concatOperator”, scope = FunctionScope.SIMPLE, nulls = NullHandling.NULL_IF_NULL)
public static class ConcatOperator implements SimpleFunction {
Param VarCharHolder left; ---------changeto------------> NullableVarCharHolder
Param VarCharHolder right; ----------changeto-----------> NullableVarCharHolder
Output VarCharHolder out;
Inject ArrowBuf buffer;

2

@kkkk

I see Postgres also returns null, which database returned 1111?

select '1111'||nullif(1,1)                                    ;
 ?column? 
----------
 
(1 row)
3

1
1987×373 30.4 KB

That should be why my version is old。 :grinning:

4

2

5

@kkkk Sorry, do not follow. Which application’s version is old?

6

I mean, the Postgres version is older 9.5.17.23

7

Hi @kkkk In which version of PG, do you see the right results?