Skip to content

01710_projection_aggregation_in_order flacks (disabled) #49552

@CheSema

Description

@CheSema
2023-05-04 23:48:33 [ff2a49c0f54d] 2023.05.04 23:48:33.221812 [ 5467 ] {92219ad3-93d6-44f6-b8a0-9ae55edd7300} <Error> executeQuery: Code: 584. DB::Exception: No projection is used when allow_experimental_projection_optimization = 1 and force_optimize_projection = 1. (PROJECTION_NOT_USED) (version 23.5.1.1 (official build)) (from [::1]:37520) (comment: 01710_projection_aggregation_in_order.sql) (in query: WITH toStartOfHour(ts) AS a SELECT sum(value) v FROM agg WHERE ts > '2021-12-06 22:00:00' GROUP BY a ORDER BY v LIMIT 5;), Stack trace (when copying this message, always include the lines below):

Stats
https://play.clickhouse.com/play?user=play#c2VsZWN0IAp0b1N0YXJ0T2ZIb3VyKGNoZWNrX3N0YXJ0X3RpbWUpIGFzIGQsCmNvdW50KCksICBncm91cFVuaXFBcnJheShwdWxsX3JlcXVlc3RfbnVtYmVyKSwgIGFueShyZXBvcnRfdXJsKQpmcm9tIGNoZWNrcyB3aGVyZSAnMjAyMi0wNi0wMScgPD0gY2hlY2tfc3RhcnRfdGltZSBhbmQgdGVzdF9uYW1lIGxpa2UgJyUwMTcxMF9wcm9qZWN0aW9uX2FnZ3JlZ2F0aW9uX2luX29yZGVyJScgYW5kIHRlc3Rfc3RhdHVzIGluICgnRkFJTCcsICdGTEFLWScpIGdyb3VwIGJ5IGQgb3JkZXIgYnkgZCBkZXNj

fails at master
https://s3.amazonaws.com/clickhouse-test-reports/0/38b2f94bfa225b21749d0ffab0185b03f9fec417/stateless_tests__asan__[2_4].html

Metadata

Metadata

Assignees

No one assigned

    Labels

    flaky testflaky test found by CI

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions