Bug/feature? Code completion on INSERT INTO ... shows keywords, but not column name

[Claus Pedersen]

I am making an insert:

INSERT INTO bonus (ename,job,sal,

If I activate code completion after the last comma, the correct list with column names is shown.

If I write 'com' after the last comma, and then activate code completion, I would expect to get the column name 'comm', but only keywords from 'comment' to 'compute' are shown.

 

[Marco Kalter]

I would have expected "comm" too, so this seems like a bug. We'll fix it.

 

[Claus Pedersen]

Thanks

 

[Claus Pedersen]

Do you have an ETA for this bugfix?

 

[Marco Kalter]

It will be fixed in 8.0.

 

[Claus Pedersen]

Hello Marko,

it also seems that code completion for function and procedure parameters does not work when typing the first characters of a parameter, and then pressing code completion. Also here, only keywords and other names of public methods are shown, no parameters.

If you enter only the comma and code completion, it works.

 

[Marco Kalter]

That is indeed correct.

 

[Claus Pedersen]

Marco, this is still a bug in version 8, can it be corrected in patch 8.0.x?

It is a general problem in the editor: code completion on partly named parameters, attributes etc. (values after an opening paranthesis) does not work. The user has to delete the code until the last comma or opening paranthesis to see the parameters/atttributes for the function/table etc.

 

[Marco Kalter]

Thanks for all the Feedback Claus.

Some issues are still open, and others are new features, not for a patch release but for version 8.1.

 

[Claus Pedersen]

But since this has been a known bug for more than two years now and you have promised to fix it, couldn't this be fixed, say, during January 2010?

 

[Claus Pedersen]

Will this be fixed before version 10?

 

[Claus Pedersen]

This has not been fixed in version 10 Beta 1. Will it be fixed for the final release? (Yeah, 5 years anniversary since first post)