This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 269391 - No code completion for keyword TRUNCATE TABLE
Summary: No code completion for keyword TRUNCATE TABLE
Status: NEW
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 8.2
Hardware: PC Other
: P3 normal (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-12-19 10:28 UTC by Christian Lenz
Modified: 2016-12-19 10:28 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Christian Lenz 2016-12-19 10:28:57 UTC
When I type TRU and hit Ctrl + Space, there is no code completion comes up. Truncate has the same color of the table name and not the color of a reserved keyword.

My SQL is:
TRUNCATE TABLE myTable;

TRUNCATE (Color: violet) TABLE (Color: orange) myTable (Color: violet)

I expect TRUNCATE as a keyword.
Same happens for TABLE. It is orange as a keyword but it is not inside the code completion.


When I hit ctrl + space I see this keywords:

CREATE
DELETE
DROP
INSERT
SELECT
UPDATE

But I think there are many more. Of course some are context specific like WHERE and LIMIT and so on, but TRUNCATE should be there too.

Please check the SQL Keywords again to add some others


Regards

Chris