ast-project/part1/results/3/bug_056b5a96-8f2c-4a2f-9047-51757e7aa8b2_logic.md

Summary

**No review yet**

Minimized query

CREATE TABLE T (
  a TEXT,
  b TEXT,
  c REAL
);
INSERT INTO T VALUES ('a','b',x'682f554feb092cde0c4f302c570051'), ('a','c',5.0), ('b','d',-8.25);
SELECT a,b,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;

Actual output

a|b|h/UOë	,ÞO0,W|1
a|c|5.0|2
b|d|-8.25|1

Expectation

a|b|h/UOë	,Þ^LO0,W|1
a|c|5.0|2
b|d|-8.25|1

Flag