MindsDB does predict when user WERE t.column > LATEST

[calebeaires]

System: MacOS
MindsDB 23.3.5.0

The first run at MindsDB the query above works very well, but after I turned off MindsDB and turn it on again, the same queries, not changes, give the error (the same approach of the MindsDB tutorial)

CREATE DATABASE bucket_67
WITH ENGINE = "clickhouse",
PARAMETERS = {
    "user": "default",
    "password": "som_host",
    "host": "some_ip",
    "port": "0000",
    "database": "bucket_67"
    };

SELECT * FROM bucket_67.venda_agregada;

DROP MODEL mindsdb.house_sales_predictor;

CREATE MODEL mindsdb.house_sales_predictor
FROM bucket_67
  (SELECT * FROM venda_agregada)
PREDICT venda
WINDOW 8    
HORIZON 4;  

SELECT p.mes, p.venda, t.mes as old_mes, t.venda as old_venda
FROM mindsdb.house_sales_predictor p
JOIN bucket_67.venda_agregada t
WHERE t.mes > LATEST
LIMIT 4;

Error in bucket_67: Orig exception: Code: 47.
DB::Exception: Missing columns: 'LATEST' while processing query: 'SELECT mes_ref_cancel_implant, venda_old, mes, venda FROM venda_agregada AS t WHERE mes > LATEST LIMIT 4', required columns: 'mes_ref_cancel_implant' 'venda_old' 'mes' 'venda' 'LATEST', maybe you meant: ['mes_ref_cancel_implant','venda_old','mes','venda']. Stack trace:

0. DB::Exception::Exception(DB::Exception::MessageMasked const&, int, bool) @ 0xe74c47a in /usr/bin/clickhouse
1. ? @ 0x7eb1f2d in /usr/bin/clickhouse
2. DB::TreeRewriterResult::collectUsedColumns(std::__1::shared_ptr<DB::IAST> const&, bool, bool) @ 0x145dccaa in /usr/bin/clickhouse
3. DB::TreeRewriter::analyzeSelect(std::__1::shared_ptr<DB::IAST>&, DB::TreeRewriterResult&&, DB::SelectQueryOptions const&, std::__1::vector<DB::TableWithColumnNamesAndTypes, std::__1::allocator<DB::TableWithColumnNamesAndTypes>> const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>>, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>>>> const&, std::__1::shared_ptr<DB::TableJoin>) const @ 0x145e1bfd in /usr/bin/clickhouse
4. ? @ 0x1401736f in /usr/bin/clickhouse
5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context> const&, std::__1::optional<DB::Pipe>, std::__1::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>>, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>>>> const&, std::__1::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::__1::shared_ptr<DB::PreparedSets>) @ 0x14013f29 in /usr/bin/clickhouse
6. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::__1::shared_ptr<DB::IAST> const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>>, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>>>> const&) @ 0x143808e2 in /usr/bin/clickhouse
7. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>>, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>>>> const&) @ 0x1437e082 in /usr/bin/clickhouse
8. DB::InterpreterFactory::get(std::__1::shared_ptr<DB::IAST>&, std::__1::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x13fd1b9d in /usr/bin/clickhouse
9. ? @ 0x1468bf40 in /usr/bin/clickhouse
10. DB::executeQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>> const&, std::__1::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x1468980d in /usr/bin/clickhouse
11. DB::TCPHandler::runImpl() @ 0x15381e0f in /usr/bin/clickhouse
12. DB::TCPHandler::run() @ 0x153956d9 in /usr/bin/clickhouse
13. Poco::Net::TCPServerConnection::start() @ 0x1820feb4 in /usr/bin/clickhouse
14. Poco::Net::TCPServerDispatcher::run() @ 0x1821185b in /usr/bin/clickhouse
15. Poco::PooledThread::run() @ 0x183a0947 in /usr/bin/clickhouse
16. Poco::ThreadImpl::runnableEntry(void*) @ 0x1839e37d in /usr/bin/clickhouse
17. ? @ 0x7f3df8642609 in ?
18. __clone @ 0x7f3df8567133 in ?

[skoleli]

could you find a solution for this?

[calebeaires]

Nope!