DataSpell disable of 'Select *' with doubleclick on table name
Answered
Is there the option to prevent 'Select *' with doubleclick on tablename? Couldn't find it in settings, and it's quite critical for Google Big Query - the accident click could cost money if the tables are big enough
Please sign in to leave a comment.
It looks like as known issues https://youtrack.jetbrains.com/issue/DBE-14015 and https://youtrack.jetbrains.com/issue/DBE-12808 .
The problem is that the query is run with `LIMIT` but it doesn't take any affect and all data are fetched.
It's an issue in JDBC driver that needs to be reported to vendor
The problem is not in LIMIT, it doesn't matter because Big Query will anyway select all the data from the table and apply LIMIT only after that. So with or without LIMIT it would cost the same. The problem is in inability to turn off that functionality in IDE at all (or I just didn't find it) - I mean that doubleclick on table name in UI. I just don't want to be aware of double-clicks each time I expand the table columns and so.
The know issues you've mentioned is of course related but not the same. (However It would be nice if all of them will be solved as well).
I see, what do you expect for double-click then?
We solved this in zendesk ticket, by enabling old navi behavior with opening DDL by double-click.
Yea, thanks, opening DDL is much saver :)
Also I filed another issue https://youtrack.jetbrains.com/issue/DBE-14911