Using > LATEST doesn't produce result

[blaszta]

I have a strange issue where I can't use LATEST but the model actually made prediction. Here's the screen shot:

If I don't use WHERE t.sales_date > LATEST the model actually has the prediction.

But if I use WHERE t.sales_date > LATEST, it will give no result:

The model was created using this query:

CREATE MODEL mindsdb.forecast_SKU_qty_monthly_sales
FROM eth_db
  (
    SELECT * FROM vw_consecutive_sales
  )
PREDICT quantity
ORDER BY sales_date
GROUP BY commercial_code
WINDOW 12 
HORIZON 3;

Any idea how to solve it?

[blaszta]

Just an update, I decide to use different ML engine, and > LATEST works now. This is my query when creating the model:

CREATE MODEL mindsdb.forecast_SKU_qty_monthly_sfengine
FROM eth_db
  (
    SELECT * FROM vw_consecutive_sales
  )
PREDICT quantity
ORDER BY sales_date
GROUP BY commercial_code
HORIZON 3
USING 
ENGINE = 'statsforecast';

Not sure why the Lightwood ML engine doesn't work with my data. Maybe I need to re-create the model again, but looks like I stick with Nixtla ML engine for now.