"Please Provide Missing Values" box not showing up when running injected sql statement with parameters

Hi there,

In a PHP file, following the documentationhttps://www.jetbrains.com/phpstorm/help/running-injected-sql-statements-from-the-editor.html, i'm trying to run an injected sql statement with parameters for PostgreSQL.
Pressing either ctrl+enter or alt+enter then selecting "Run Query in Console" run the query without prompting the "Please Provide Missing Values" box.
This produce, logically, the following error "[08P01] ERROR: bind message supplies 0 parameters, but prepared statement "" requires 1".

The query is like:
$query = "SELECT foo FROM foo.bar WHERE id = $1";

In the Settings > Tools > Database > Custom SQL parameters "\$\w+" is configured for "Everywhere".
This part seems to works as the query parameter is not highlighted with the error message "unable to resolve column name '$1'".

Any idea ?

Thanks.

1 comment
Comment actions Permalink

Hi there,

Seems like it's broken since 9.0.2 but was working in 9.0.1 -- try downgrading (if you have older version somewhere) and see if it works there.

https://youtrack.jetbrains.com/issue/WI-28440 -- watch this ticket (star/vote/comment) to get notified on progress.

0

Please sign in to leave a comment.