Resolving temporary sql table
I've got some code in my PHP as follows
$query = "create temporary table _reference as select Id, Code, count(SomeOtherID) as SomeCount
from `_another_table`
group by Id, Code";
$db->queryExec($query);
$query = "Select * from _reference where Id = 1";
// _reference above does not get resolved
Is there any way to get PHPStorm to resolve something like the above?
Please sign in to leave a comment.
It works just fine in .sql files, but doesn't work with SQL injected in other languages. Could you please submit it as a bug?
https://youtrack.jetbrains.com/newIssue?project=WI
Thank you!
It's been filed as https://youtrack.jetbrains.com/issue/WI-45968.