[11.5.362 Pro] - Autocompleting ON for JOINs glitch

[11.5.362 Pro] - Autocompleting ON for JOINs glitch

You get a popup for picking column pairs for JOIN ON criteria whether you freshly start from the ON keyword or (when you already have one of the columns typed/selected/whatever) after typing '='. However, while the code generated for the first case is valid, the one you get for the second case is not. That column is preserved instead of being overwritten and that makes the code syntactically invalid. Note that this only happens when picking from the column pairs in the list. If you choose a single column further down the list, everything is alright.

Check this short video here.

I'd expect pairs not to be displayed after typing '='. After all, one of the columns is already there. But since they can be chosen, I'd also expect selecting a pair to 'override' the column already present.

Many thanks for the detailed description and video. I submitted a new defect with number #SA0041645