Why doesn't this mariadb subquery work?

Question

SQL

people tell me on mariadb.
Doing a delete with a nested subquery
DELETE FROM b_catalog_product
WHERE ID IN (SELECT PRODUCT_ID FROM b_catalog_price WHERE PRICE >=0 and PRICE <= 1)
produces
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line
2

Answer 1

There don't seem to be any problems. Runs successfully.
And the checkers say - ok https://www.eversql.com/sql-syntax-check-validator/

Answer 2

MySQL and its cousin MariaDB have always been pretty bad at dealing with subqueries.
It might have been fixed in the latest versions.
But if you have an old version of MariaDB, then why not have this jamb.