Company or project name

Axis Communications

Describe what's wrong

This is with the default settings including enable_analyzer = 1. Reproduces on 25.12.3.21 and 25.11.1.1 but works as expected on 25.10.3.100.

Getting wrong results when selecting from url() or file().

Does it reproduce on the most recent release?

Yes

How to reproduce

CREATE VIEW view (
        col1 String,
        col2 String
)
AS (SELECT * FROM file('my_local_file.parquet', Parquet, 'col1 String,\n col2 String'))

SELECT DISTINCT col1 FROM view WHERE col1 = 'some_string'

returns exactly one row 'some_string' as expected. However if I do

SELECT DISTINCT col1, col2 FROM view WHERE col1 = 'some_string'

it returns 163 rows where col1 are all '' and col2 has some different values.

Expected behavior

I have checked with 25.10.3.100 where it works properly and there also get 163 rows with the same values for col2 but col1 all have the value 'some_string' as expected.

The same thing occurs if I select from a url() instead of file().

If I do

CREATE TABLE table ENGINE = Memory AS SELECT * FROM view

and then query 'table' instead of 'view' it also works as expected and I get the correct results.

Error message and/or stacktrace

None.

Additional context

No response