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?
0
2 comments

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!

0

Please sign in to leave a comment.