Sphinxql: syntax error, unexpected IDENT, expecting CONST_INT or CONST_FLOAT or DOT_NUMBER

I have the following table structure:

archived_items
name
factory_price
retail_price

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.

might be better to create ticket at Github as looks like filter parser constrain or error

Ticket can be found in Sphinxql: syntax error, unexpected IDENT, expecting CONST_INT or CONST_FLOAT or DOT_NUMBER · Issue #349 · manticoresoftware/manticoresearch · GitHub