greptimedb/tests/compatibility/cases/uddsketch_legacy_state/verify.sql

-- (1) direct uddsketch_calc of each persisted legacy row
SELECT grp, uddsketch_calc(0.5, state) AS p50
FROM uddsketch_states
ORDER BY grp;

-- (2) direct uddsketch_rank of each persisted legacy row
SELECT grp,
       ROUND(uddsketch_rank(30.0, state), 4) AS rank_at_30,
       ROUND(uddsketch_rank(70.0, state), 4) AS rank_at_70,
       ROUND(uddsketch_rank(100.0, state), 4) AS rank_at_100
FROM uddsketch_states
ORDER BY grp;

-- (3) uddsketch_merge over the persisted legacy rows, then calc.
--    Succeeds only if every legacy row decodes to the exact declared
--    parameters (128, 0.01); the merge parameter check is the guard.
SELECT uddsketch_calc(0.5, uddsketch_merge(128, 0.01, state)) AS p50
FROM uddsketch_states;

-- (4) generate fresh canonical states with the new binary and merge mixed legacy + canonical rows
CREATE TABLE uddsketch_new_states (
  state BINARY,
  grp INT PRIMARY KEY,
  ts TIMESTAMP TIME INDEX DEFAULT now()
);

INSERT INTO uddsketch_new_states (state, grp)
SELECT uddsketch_state(128, 0.01, val), seq_id / 5 * 5 AS grp
FROM uddsketch_values
GROUP BY grp;

SELECT uddsketch_calc(0.5, uddsketch_merge(128, 0.01, state)) AS p50
FROM (
  SELECT state FROM uddsketch_states
  UNION ALL
  SELECT state FROM uddsketch_new_states
) AS all_states;

-- (5) canonical-only control
SELECT uddsketch_calc(0.5, uddsketch_merge(128, 0.01, state)) AS p50
FROM uddsketch_new_states;