Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

flaky ci: basic_r_cte.test:265 #17287

Open
TCeason opened this issue Jan 15, 2025 · 0 comments
Open

flaky ci: basic_r_cte.test:265 #17287

TCeason opened this issue Jan 15, 2025 · 0 comments
Assignees
Labels
C-bug Category: something isn't working

Comments

@TCeason
Copy link
Collaborator

TCeason commented Jan 15, 2025

Summary

https://github.com/databendlabs/databend/actions/runs/12780164800/job/35626574682?pr=17262

0: query result mismatch:
[SQL] with
t0 as (
select
        train_id,
        seat_count,
        sum(seat_count) over (
        partition by departure_station, arrival_station order by train_id
      ) ::int sum_sid
from
        train
)
select
    sum(case when n=1 then sum_sid+1 else 0  end::int),
    sum(sum_sid),
    sum(seat_count)
from
        t0,(select 1 n union all select 2);
[Diff] (-expected|+actual)
-   261700 523200 210000
+   236700 473200 210000
at tests/sqllogictests/suites/query/cte/basic_r_cte.test:265
@TCeason TCeason added C-feature Category: feature C-bug Category: something isn't working and removed C-feature Category: feature labels Jan 15, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-bug Category: something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants