Skip to content

multiple ORDER BY .. WITH FILL ignored field orders in ORDER BY and use field order from SELECT ... #12291

@Slach

Description

@Slach

ORDER BY f1 WITH FILL, f2 WITH FILL always fills data only for one field which first in SELECT order and ignore fields order in ORDER BY clasue

How to reproduce

SELECT toDate(number*10*86400) AS d1, toDate(number*86400) AS d2, 'original' AS source
FROM numbers(10) WHERE number % 3 = 1
ORDER BY d2 WITH FILL, d1 WITH FILL;

have same result as

SELECT toDate(number*10*86400) AS d1, toDate(number*86400) AS d2, 'original' AS source
FROM numbers(10) WHERE number % 3 = 1
ORDER BY d1 WITH FILL, d2 WITH FILL,;

Expected behavior:
filled by d1 or by d2 according to ORDER BY field order

Actual behavior
always only d1 filled, and d2 always have default valu

  • Which ClickHouse server version to use:
    docker 20.5.2.7
  • Which interface to use, if matters
    Native

Metadata

Metadata

Assignees

Labels

bugConfirmed user-visible misbehaviour in official release

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions