18.10.3. Something is broken with String columns in tables with engine=Dictionary

[SaltTan]

1. Join with a memory table does not work when selecting a string column

$ clickhouse-client
ClickHouse client version 18.10.3.
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 18.10.3 revision 54405.

:) show create table dict_table

SHOW CREATE TABLE dict_table

┌─statement────────────────────────────────────────────────────────────────────────────────────┐
│ CREATE TABLE test.dict_table ( key UInt64,  source String) ENGINE = Dictionary(dim_netspeed) │
└──────────────────────────────────────────────────────────────────────────────────────────────┘
:) show create table test.mem_table

SHOW CREATE TABLE test.mem_table

┌─statement─────────────────────────────────────────────────┐
│ CREATE TABLE test.mem_table ( key UInt64) ENGINE = Memory │
└───────────────────────────────────────────────────────────┘

:) SELECT key, source FROM test.dict_table  ALL INNER JOIN test.mem_table USING (key)

SELECT
    key,
    source
FROM test.dict_table
ALL INNER JOIN test.mem_table USING (key)

Received exception from server (version 18.10.3):
Code: 9. DB::Exception: Received from localhost:9000, ::1. DB::Exception: Size of offsets doesn't match size of column..

:) SELECT key FROM test.dict_table  ALL INNER JOIN test.mem_table USING (key)

SELECT key
FROM test.dict_table
ALL INNER JOIN test.mem_table USING (key)

Ok.

2. Select of a string column from a dictionary table does not work (clickhouse-client only, works fine through HTTP)

:) SELECT key, source FROM test.dict_table

SELECT
    key,
    source
FROM test.dict_table


Exception on client:
Code: 89. DB::Exception: Unknown compression method: 105: while receiving packet from localhost:9000, ::1

:) SELECT source FROM test.dict_table

SELECT source
FROM test.dict_table

┌─source───┐
│ NULL     │
│ contype  │
│ contype  │
│ contype  │
│ contype  │
│ contype  │
│ contype  │
│ lookup   │
│ lookup   │
│ lookup   │
│ lookup   │
│ lookup   │
│ lookup   │
│ netspeed │
│ netspeed │
│ netspeed │
│ netspeed │
│ netspeed │
│ netspeed │
└──────────┘
┌─source───┐
│ NULL     │
│ contype  │
│ contype  │
│ contype  │
│ contype  │
│ contype  │
│ contype  │
│ lookup   │
│ lookup   │
│ lookup   │
│ lookup   │
│ lookup   │
│ lookup   │
│ netspeed │
│ netspeed │
│ netspeed │
│ netspeed │
│ netspeed │
│ netspeed │
└──────────┘

38 rows in set. Elapsed: 0.002 sec.

3. Distinct on a string column does not work (clickhouse-client only, works fine through HTTP)

:) select distinct source from test.dict_table

SELECT DISTINCT source
FROM test.dict_table

┌─source───┐
│ NULL     │
│ contype  │
│ contype  │
│ contype  │
│ contype  │
│ contype  │
│ contype  │
│ lookup   │
│ lookup   │
│ lookup   │
│ lookup   │
│ lookup   │
│ lookup   │
│ netspeed │
│ netspeed │
│ netspeed │
│ netspeed │
│ netspeed │
│ netspeed │
└──────────┘
┌─source───┐
│ NULL     │
│ contype  │
│ lookup   │
│ netspeed │
└──────────┘

23 rows in set. Elapsed: 0.002 sec.

$ wget -O- -q 'http://localhost:8123/?query=select distinct source from test.dict_table'
NULL
contype
lookup
netspeed

[alexey-milovidov]

Fixed in master.