If I create a view with an derby db, and I hit refresh, the "Views" Tree element within the "Servers" tab is correctly
However, if I drop the view (no refresh) and recreate it with an additional column, the "views" tree elemnt is not
updated: The additional column does not show up.
If I close the connection and reconnect, the "Views" will show the additional column.
Not sure if it is derby, java 1.6., netbeans 6.1 or windows xp specific.
oflebbe the following works for me. If you have any additional information, please add it to this issue
Using the sample table [app on APP]
1) Right-click on Views - the Create View dialog opens
2) Enter a name for the view:
and enter a SQL:
SELECT CUSTOMER_ID, NAME FROM CUSTOMER
- the CUST view is created under the VIEWS node
3) Right-click and choose Delete to drop CUST
4) Repeat step 2 but this time include another column:
SELECT CUSTOMER_ID, NAME, CITY FROM CUSTOMER
5) Expand the Views node and CUST
- there are 3 columns: CUSTOMER_ID, NAME and CITY
We were not able to get to these issues before code freeze - changing target
milestone to 'future'
oflebbe, can You update this issue? Are You still able to reproduce this issue?
We can't work on this issue since we don't have enough information. If this issue isn't updated and still in INCOMPLETE
state, then we will think that it isn't valid anymore (probably was fixed with another issue) and this issue will be closed.
We haven't got any new info in a month, so I'm closing this issue as FIXED.
Please reopen this issue if it is still valid and add some more information.