I have the following table structure:
Then I have the following query :
SELECT * FROM archived_items WHERE retail_price < factory_price
SELECT * FROM archived_items WHERE 30000 < factory_price (Cannot reverse the condition because it’s part of a formula to check overlapping price range)
Manticore throws out an error of “…unexpected IDENT, expecting CONST_INT or CONST_FLOAT or DOT_NUMBER”. I tested this out on MySQL and works perfectly fine.