Devart Forums

Typing a query such as this:

SELECT
*
FROM
TableList l
LEFT

when I type the space after left, the autocomplete window pops up with a list of JOIN phrases such as JOIN, OUTER, OUTER JOIN. If I use the arrow keys to highlight OUTER JOIN and press space, it just adds OUTER instead of OUTER JOIN. If I click on the phrase OUTER JOIN with the mouse it adds OUTER JOIN as expected.

Same thing happens with ORDER BY, GROUP BY which is where I would find it useful as it is usually the default popup option.

Such a behavior is by design. We made it to work this way for composite keywords intentionally.

Let's imagine that the user is typing the text quickly not paying attention to the suggestions list. Upon pressing, let's say, SPACE or TAB the user will get a phrase that they probably will not need. Therefore, we made the compound phrase insertion to occur on pressing ENTER only or selecting with the mouse cursor.