SQL inspections shows a lot of false-positive errors in PHPStorm 6

The latest version of PHPStorm allows me to activate SQL Inspections.
The problem is that a lot of SQL strings are dynamically created with PHP variables or by concatenate different SQL lines (see attached picture).

In consequence, a lot of files are underlined in red even if they don't contain any error at all.
I can disable SQL inspections by setting SQL dialect to "keywords only" but then I will also lose autocomplete and other useful stuff.

Is there a way to turn SQL errors into simple warnings?

Thanks,
Fabio

screenshot.png

8 comments

Hi Fabio,

Try Alt+Enter on error, see which inspection is that, right arrow (to see submenu for that menu entry) and choose "Edit inspection..." -- you should be able to either disable that inspection .. or lower it's priority.

I'm not 100% sure, but I think that inspection will be "Settings | Inspections | SQL | Unresolved reference".

On related note: http://youtrack.jetbrains.com/issue/WI-2450

1

Thanks for your answer.
Apparently, there is no specifi inspection for those errors. So it seems impossible to disable them.

2

Similar call for help in PyCharm at https://intellij-support.jetbrains.com/hc/en-us/requests/622423

 

Some of the exotic, barely-googlable error messages I've seen with this problem:

 

<comma join expression> expected, unexpected end of file

'(', <reference>, GROUP, HAVING, UNION, WHERE or '{' expected, got '{'

'(', <reference>, or '{' expected, got '}'

1

I am pre-formating my SQL queries too and am constantly getting errors like "expression expected, got %s" instead. No way to turn it off via alt-enter or inspections.

0

Nicolaibiker, by default, %s should be considered a user parameter and should not be highlighted. Please check: https://youtrack.jetbrains.com/issue/WI-35847

Could you please share a code sample?

0

I managed to turn off the language injection to avoid this issue, but when it's turned on, it looks like this:

PhpStorm 2018.1.6
Build #PS-181.5281.35, built on June 14, 2018
JRE: 1.8.0_152-release-1136-b39 amd64
JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.o
Windows 10 10.0

0

It seems that in the latest version it works fine :) Thanks.

PhpStorm 2018.3.3
Build #PS-183.5153.36, built on January 9, 2019
JRE: 1.8.0_152-release-1343-b26 amd64
JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.o
Windows 10 10.0

1

Yeah, there was a number of improvements in this in latest updates.

0

Please sign in to leave a comment.