Operators >= and <= do not work with ANY and ALL in subquery
Example:
Ledger:
2024-01-01 open Assets:Bank
2024-01-01 open Expenses:Food
2024-01-01 open Expenses:Transport
2024-01-01 open Expenses:Books
2024-01-02 * "Groceries"
Expenses:Food 40 USD
Assets:Bank
2024-01-03 * "Groceries"
Expenses:Food 5 USD
Assets:Bank
2024-01-05 * "Restaurant"
Expenses:Food 60 USD
Assets:Bank
2024-01-09 * "Bus ticket"
Expenses:Transport 15 USD
Assets:Bank
2024-01-20 * "Novel"
Expenses:Books 25 USD
Assets:Bank
2024-01-22 * "Comic"
Expenses:Books 10 USD
Assets:Bank
This query works:
SELECT account, date, number
WHERE account ~ '^Expenses'
AND number > ALL (SELECT number WHERE account ~ 'Expenses:Books')
ORDER BY number
Result:
account date number
------------- ---------- ------
Expenses:Food 2024-01-02 40
Expenses:Food 2024-01-05 60
This one produces an error:
SELECT account, date, number
WHERE account ~ '^Expenses'
AND number >= ALL (SELECT number WHERE account ~ 'Expenses:Books')
ORDER BY number
error: AttributeError: 'EvalQuery' object has no attribute 'dtype'
Operators
>=and<=do not work with ANY and ALL in subqueryExample:
Ledger:
This query works:
Result:
This one produces an error:
error: AttributeError: 'EvalQuery' object has no attribute 'dtype'