Given the MariaDB query SELECT LAG(value, 1) OVER (ORDER BY added_on) FROM transactions. I'm working in IntelliJ IDEA (could as well be PHPStorm anything JetBrains related), and my IDE gives me an error for the LAG function, namely:

LAG could not take such arguments

Removing the , 1 in the LAG function removes this warning, but why am I given this warning in the first place? According to

CodePudding user response：

Looks like we need to update our code assistance hints for MySQL. Here is issue on our tracker, please follow and vote.