wrong behaviour with comparing operators over arrays

[silviucpp]

CREATE TABLE test_array (arr Array(Nullable(Float64))) ENGINE = Memory;
INSERT INTO test_array(arr) values ([1,2]),([3,4]),([5,6]),([7,8]);

select * from test_array where arr > [12.2] ;

Code: 43, e.displayText() = DB::Exception: Illegal types of arguments (Array(Nullable(Float64)), Array(Float64)) of function greater, e.what() = DB::Exception

select * from test_array where arr > [null, 12.2] 

OK

select * from test_array where arr > [null, 12] 

Code: 43, e.displayText() = DB::Exception: Illegal types of arguments (Array(Nullable(Float64)), Array(Nullable(UInt8))) of function greater, e.what() = DB::Exception

As you can see all 3 ops should work

Silviu

[silviucpp]

Of course using CAST will fix the problem but maybe clickhouse needs to be smart enough to allow this by default

[alexey-milovidov]

Yes, these operations should be supported.

[silviucpp]

@alexey-milovidov I see you worked on this .. is this bug a priority ?

[alexey-milovidov]

It's unfinished. This feature has low/medium priority.

[silviucpp]

Hello @alexey-milovidov also this one was partially fixed.

[silviucpp]

@alexey-milovidov I tested this on master and it's fine. You can close it !

Thanks,
Silviu