Can you no longer execute SQL scripts from a scratch file in PhpStorm9?

In PhpStorm 8, you can choose a single query or statement in a .SQL or MySQL scratch file, press Alt+Enter to popup the intentions menu, then execute it via "Run Query in Console." .SQL files still have this ability in PhpStorm 9, but scratch files set to MySQL don't offer the intentions menu any longer, and I also can't find a command to execute all the queries in the file.

Am I missing a setting somewhere to bring this functionality back?

Comment actions Permalink

Please try File | Invalidate Caches and restart.
I can not reproduce the issue, unfortunately. If issue remains, please provide the info about your setup (OS/JDK version).

Comment actions Permalink

Thanks for following up, Liubov.

I've restarted the entire machine since this, and performed two cache invalidations and restarts. It still won't bring up the intentions menu in a MySQL scratch file. Intentions work in other scratch files just fine.

This is on Fedora 22 running Linux 4.0.6-300.fc22.x86_64.

[eric@schwarz ~]$ java -version
java version "1.8.0_45"
Java(TM) SE Runtime Environment (build 1.8.0_45-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.45-b02, mixed mode)

PhpStorm 8 wouldn't work (the agonizingly-slow-under-Java-8 bug that I found OSX users suffering from in your bug tracker, I think) with whatever lame version of Java the Fedora project ships. I had to manually install the official Oracle version after upgrading from Fedora 20 to Fedora 22.

[eric@schwarz ~]$ alternatives --list
java_sdk_openjdk auto /usr/lib/jvm/java-1.8.0-openjdk-
java_sdk_1.8.0 auto /usr/lib/jvm/java-1.8.0-openjdk-
java_sdk_1.8.0_openjdk auto /usr/lib/jvm/java-1.8.0-openjdk-
jre_1.8.0_openjdk auto /usr/lib/jvm/jre-1.8.0-openjdk-

Attached is a useless image of the scratch file failing to trigger intentions right aboe a SQL file with the intentions triggering like normal.


Please sign in to leave a comment.