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

Summary: No code completion for keyword TRUNCATE TABLE
Product: db Reporter: Christian Lenz <chrizzly>
Component: SQL EditorAssignee: Libor Fischmeistr <lfischmeistr>
Status: NEW ---    
Severity: normal    
Priority: P3    
Version: 8.2   
Hardware: PC   
OS: Other   
Issue Type: DEFECT Exception Reporter:

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