So i have a problem on PHPStorm, i have 3 schemas under the same database connection. Lets call them S1, S2 and S3.
If i switch to S1, PHPStorm executes "use S1" in the background, and if i run a select query S1 data returns and i can edit it fine. All good there.
If i switch to S2, or S3 howerver, PHPStorm executes the "use" command fine, and it selects fine - yet, the data returned is 'Read-Only' and i cannot edit it.
However, if i specify the schema in the select query ("select * from s2.table;") - i can edit the data fine.
Anyone know if this is a bug, or perhaps a setting i need to change?
As i'm building queries based on a backup/snapshot schema i don't want to be specifying the schema within queries to place into my PHP code for live deployment, so this is a bit of a problem.