Skip to content

fix(sql): fix sample by with only one fill option#6437

Merged
bluestreak01 merged 2 commits intomasterfrom
sample_by_one_fill
Nov 24, 2025
Merged

fix(sql): fix sample by with only one fill option#6437
bluestreak01 merged 2 commits intomasterfrom
sample_by_one_fill

Conversation

@kafka1991
Copy link
Collaborator

@kafka1991 kafka1991 commented Nov 24, 2025

When a SAMPLE BY query specifies only one fill option, current implemation implies that this option should apply to all aggregation columns. This PR ensures that when we need to reorganize the fill values based on the positional relationship between TopDownColumns and BottomUpColumns, the logic remains consistent.

close #6436

@coderabbitai
Copy link

coderabbitai bot commented Nov 24, 2025

Important

Review skipped

Auto reviews are disabled on this repository.

Please check the settings in the CodeRabbit UI or the .coderabbit.yaml file in this repository. To trigger a single review, invoke the @coderabbitai review command.

You can disable this status message by setting the reviews.review_status to false in the CodeRabbit configuration file.

✨ Finishing touches
🧪 Generate unit tests (beta)
  • Create PR with unit tests
  • Post copyable unit tests in a comment
  • Commit unit tests in branch sample_by_one_fill

Thanks for using CodeRabbit! It's free for OSS, and your support helps us grow. If you like it, consider giving us a shout-out.

❤️ Share

Comment @coderabbitai help to get the list of available commands and usage tips.

@glasstiger
Copy link
Contributor

[PR Coverage check]

😍 pass : 1 / 1 (100.00%)

file detail

path covered line new line coverage
🔵 io/questdb/griffin/SqlCodeGenerator.java 1 1 100.00%

@bluestreak01 bluestreak01 merged commit 555f6d4 into master Nov 24, 2025
41 checks passed
@bluestreak01 bluestreak01 deleted the sample_by_one_fill branch November 24, 2025 02:44
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Unconsistent missing rows when using SAMPLE BY + FILL in subquery

3 participants