Weird behaviour of function IPv4CIDRToRange/IPv6CIDRToRange

[nvartolomei]

How to reproduce

• Which ClickHouse server version to use: version 20.4.4

DROP TABLE IF EXISTS test;
CREATE TABLE test Engine = Memory
AS SELECT '1.1.1.1/24' as address;

WITH '1.1.1.1' AS addr
SELECT
    address,
    splitByChar('/', address) AS prefix,
    prefix[1] AS base,
    toUInt8(prefix[2]) AS mask
FROM test
WHERE (IPv4CIDRToRange(toIPv4(addr), mask).1) = toIPv4(base)

Received exception from server (version 20.4.4):
Code: 44. DB::Exception: Received from localhost:9000. DB::Exception: Illegal column Const(UInt32) of argument of function IPv4CIDRToRange.

Expected behaviour is this (here mask is hard coded to 24.

WITH '1.1.1.1' AS addr
SELECT
    address,
    splitByChar('/', address) AS prefix,
    prefix[1] AS base,
    toUInt8(prefix[2]) AS mask
FROM test
WHERE (IPv4CIDRToRange(toIPv4(addr), 24).1) = toIPv4(base)

┌─address────┬─prefix───────────┬─base────┬─mask─┐
│ 1.1.1.0/24 │ ['1.1.1.0','24'] │ 1.1.1.0 │   24 │
└────────────┴──────────────────┴─────────┴──────┘

1 rows in set. Elapsed: 0.005 sec.

cc @lspgn

[qoega]

Can reproduce on master as well.

[alexey-milovidov]

Reproduced on

master
20.4
20.3
20.1
19.14

On 19.1 there is no such function.

[alexey-milovidov]

The bug was introduced here: #5095