Show columns in completion proposal pop-up without table alias

[expired user #8841]'s profile image [expired user #8841] posted 8 years ago in Feature discussion Permalink

Hi there,

Heidi seem to require a table alias for showing the column names of a table in the completion proposal pop-up. This seems reasonable when writing complex queries but i think Heidi should be smart enough to recognize a simple query whereas an alias is not needed.

For example, it would be nice to have the columns displayed in the pop-up when typing:

SELECT * FROM foo WHERE 
-> CTRL + SPACE -> no columns of foo displayed

If i want the columns to be displayed in the completion proposal pop-up i need to type

SELECT * FROM foo f WHERE f.
-> CTRL + SPACE -> columns of foo are now displayed

So lonG

Daniel

[expired user #6833]'s profile image [expired user #6833] posted 8 years ago Permalink

Agreed, it would also be nice to have table name completion based on the currently selected database.

BubikolRamios's profile image BubikolRamios posted 8 years ago Permalink
SELECT * FROM foo WHERE 
-> CTRL + SPACE -> no columns of foo displayed

nope, not logical

SELECT * FROM foo join foo1 on foo.f = foo1.f
WHERE 
-> CTRL + SPACE -> What would you want there ? All columns from both tables

besides using 'foo f' is very useful, I doubt I do ay query without it.

Agreed, it would also be nice to have table name completion based on the currently selected database.

try Select * from -> CTRL + SPACE

BubikolRamios's profile image BubikolRamios posted 8 years ago Permalink

To mention, if focused to db1

select * from db1.table t1 join db.table t on ...
where t.-> CTRL + SPACE

Does not work, mybe it should. Of course t1.-> CTRL + SPACE woks

[expired user #8841]'s profile image [expired user #8841] posted 8 years ago Permalink

@Bubiko

What part of the word "smart" don't you understand? Heidi should be smart enough to recognize a simple query in the form of SELECT * FROM table. This question has nothing to do with joins or other complex queries. My example is in fact logical, just try SQL Studio or other software, they all can do it, so what are you mumbling about.

BubikolRamios's profile image BubikolRamios posted 8 years ago Permalink
Heidi should be smart enough

Nope, it is free so you can't expect anything, you can only be grateful that it does what it does for free. Chill, if you would understand coplexity of programming that arises from your suggestion to my extension which can't be ignored, you would not use the tone that you do.

Or that would not affect your tone at all ?

[expired user #8841]'s profile image [expired user #8841] posted 8 years ago Permalink

I thought ansgar is the master chief here? Yeah tone was a bit rough, i'm sorry for that. In fact i don't expect anything hence i wrote should instead of shall. It's a proposal after all to make Heidi even better.

Please login to leave a reply, or register at first.