Re: Recreating a dated series from a change log

[Rick James]

With Handler_read_rnd_next = 45 for that query (2 puc_change rows; 30 T_day rows), I suspect the query is O(N*N), hence will not scale well?

The row for 2015-03-01, probably because of

SELECT d.T_day, p.units
    FROM T_days AS d JOIN puc_changes AS p ON p.T_day <= d.T_day  -- "<=" needed.
    WHERE d.T_day BETWEEN '2015-02-24' AND '2015-03-04'
      AND p.T_day = (SELECT MAX(T_day) FROM puc_changes WHERE T_day <= d.T_day);