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 167101 - SQL Code Complete should show Views and View Columns
Summary: SQL Code Complete should show Views and View Columns
Status: NEW
Alias: None
Product: php
Classification: Unclassified
Component: Editor (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker with 1 vote (vote)
Assignee: Ondrej Brejla
URL:
Keywords:
: 168077 (view as bug list)
Depends on:
Blocks:
 
Reported: 2009-06-15 13:24 UTC by jan_ac
Modified: 2017-03-09 13:49 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description jan_ac 2009-06-15 13:24:51 UTC 
SQL Code Complete works nice for tables and their columns. But it would be very nice to have views and their columns
available in sql code complete to.

I am connecting via postgres jdbc4 driver to postgres 8.3, the service tab -> databases shows all views and tables correct.
Comment 1 rros 2009-07-03 09:45:39 UTC 
*** Issue 168077 has been marked as a duplicate of this issue. ***
Comment 2 rros 2009-07-03 09:47:36 UTC 
I would also like to have this feature and completion for the CALL statement and stored procedures
Comment 3 Tomasz Slota 2010-02-10 08:46:37 UTC 
reassigning to default owner
Comment 4 Filip Zamboj 2010-09-15 12:29:13 UTC 
batch reassigning
Comment 5 Xenos 2017-03-09 13:49:10 UTC 
Support for MySQL VIEWS works for me in NB 8.2 
SELECT * FROM `local`.ecs_import AS i WHERE i.|CTRL+SP shows the view's column (since ecs_import is a view here)

But it seems that CALL is still not supported. It's not even in the list of the 6 MySQL Keywords on an empty SQL file (SELECT,INSERT,UPDATE,DELETE,CREATE,DROP), event if it's recognized as a MySQL keyword