Parsing error with SQLite FILTER() without OVER Window
Answered
The following image shows a language parsing error related to the filter() function. The error appears when there is no accompanying OVER window function definition. The SQL executes fine,
An OVER window function is not required to used FILTER(). I could get the same result using a subquery, but FILTER() is so much more simplified.
Please sign in to leave a comment.
I should have demonstrated that by simply including the OVER, even if incomplete, removes the parse warning with the WHERE.
Hello, I've created bug report on our tracker, please follow and vote https://youtrack.jetbrains.com/issue/DBE-10328