To reproduce

Executing following query

select split_part(x, '.', 3) from
(select 'a.b' as x
union select 'c.d' as x
union select 'e.f.g' as x
union select 'h.i.j' as x
union select 'k.l' as x
union select 'm.n' as x)

returns

Expected result would be

When executed in Web Console multiple times in a row, first two rows are also populated with data from previous execution.

QuestDB version:

7.4.2

OS, in case of Docker specify Docker and the Host OS:

Ubuntu 22.04 (Docker)

File System, in case of Docker specify Host File System:

ext4

Full Name:

Daniel Rod

Affiliation:

Second Foundation

Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?

• Yes, I have

Additional context