"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.
Please sign in to leave a comment.
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.