SQL completion in query window
I sometimes work with temporary tables alongside the main table
I would have for example a table called _l which has an id column which is going to get joined with the table learner which also has an id column. At this point it is not known by phpstorm in the schema
If I then start typing _l and then type a full stop to add the id field, the schema might have a known to phpstorm table called _logbook which it then uses to autocomplete, which is a tad annoying, unless I refresh the schema. Is there a way to stop this? I'm certain this started on a recent update
These are my current options
Please sign in to leave a comment.
Please specify your database, IDE version, and provide a screenshot with the join statements where the temporary table is not getting resolved / and resolved in the query console.
We'll have a look.
It's mariadb 10.5.31, IDE 2024.1.1
At this point I want to type .learner_id, but as soon as I hit ., the autocomplete completes to _logbook_lt if it hasn't refreshed the schema yet.
May I know if you had the schema refreshed (it is selected for introspection under Schemas tab in data source properties) before you are typing this table and it is resolved / not being resolved? Or do you have to refresh the schema every time you want to autocomplete this table? If the table in question is not correctly detected by the autocompletion, you may want to switch to Suggest Objects From - All available schemas. If this is a new table, you may want to turn on the Auto Sync option in the Options tab of your data source properties.
In the meantime, I have tested the autocompletion of temporary tables in MariaDB 10 in 2024.1 and haven't come across the behavior you described above.