Parsing error with SQLite FILTER() without OVER Window
已回答
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.
请先登录再写评论。
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