I am getting an error detected by DataGrip that is not an error:
select top 10 * <-- squiggly here
The red squiggly line says: <expression> expected, got 'from'
When I execute, the query goes through and brings back results.
Lately I have been using SQL Workbench but I missed the static analysis capabilities of Microsoft SQL Server. So I was really excited about DataGrip when I heard about it. So it's really disheartening that such a simple snippet of code would falsely detect an error.
Does DataGrip always run queries regardless of potential detected errors? Or does DataGrip ever elect to not execute a statement that it deems to be "incorrect"? Because if it is the latter case, then that is a deal breaker.