1. Connect to DB.
2. Open SQL Editor and type "select " from travel.person p".
3. Place cursor after 'select "' and press Ctrl+Space.
Result: The code completion list appears, but there is no alias in it.
Not fixable currently. The CC lexer sees the quote after SELECT as the beginning of a quoted identifier which extends up
to the end of the statement. Perhaps the CC lexer should be different from the highlighting lexer and should send tokens
such as QUOTED_ID_START and QUOTED_ID_END. That would at least allow the CC to do some heuristic.
*** Issue 142460 has been marked as a duplicate of this issue. ***
*** Issue 143308 has been marked as a duplicate of this issue. ***
I can still reproduce using
select ab. from "actor" ab
- no completion after the '.'
Reassigned to new owner.
If quote is typed, it is completed by second quote. Thus it preserves validity of statement and SQL code completion
works. If pair quote is removed it still doesn't work but it is a corner case.
To verify type " and Ctrl+Space in
select ab.| from "CUSTOMER" ab
This will not work
select ab."| from "CUSTOMER" ab
Integrated into 'main-golden', will be available in build *200908220201* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
User: Jiri Skrivanek <firstname.lastname@example.org>
Log: #142459 - If quote is typed, it is completed by second quote. Thus it preserves validity of statement and SQL code completion works. Also if completion is called within closed quotes, it doesn't add redundant quotes.