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.

https://sqlite.org/windowfunctions.html

2 comments
Comment actions Permalink

I should have demonstrated that by simply including the OVER, even if incomplete, removes the parse warning with the WHERE.

0
Comment actions Permalink

Hello, I've created bug report on our tracker, please follow and vote https://youtrack.jetbrains.com/issue/DBE-10328

0

Please sign in to leave a comment.