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 151510

Summary: Adding Table inserts 8,000,000 blank spaces
Product: obsolete Reporter: uvicpaul <uvicpaul>
Component: visualwebAssignee: John Baker <jbaker>
Status: NEW ---    
Severity: blocker CC: romanmostyka
Priority: P2    
Version: 6.x   
Hardware: Other   
OS: Linux   
Issue Type: DEFECT Exception Reporter:

Description uvicpaul 2008-10-27 18:16:33 UTC 
When I add a table to a query, and then click "off" many of the columns in that table leaving only those I want in the
query, the SQL editor seems to insert up to 8 million blank spaces at the end of the query.  This almost takes down the
entire IDE and certainly makes it impossible to open the SessionBean1.java file.  I end up using command line Emacs to
edit that source file, strip out the extra spaces, and then reload things into NetBeans.  I did search for this bug but
did not see it.
Comment 1 David Vancouvering 2008-10-27 18:28:21 UTC 
This sounds problematic, if it's reproducible.  As the user says, the only way they can edit the query is in emacs.

uvicpaul:  did you try creating the query in the SQL editor?  This might be easier than emacs because it provides
completion for column names and table names and you can execute the query right there to see if it works.
Comment 2 uvicpaul 2008-10-28 20:33:12 UTC 
I had replied to David through email...but thought it may be more beneficial to add it as an additional comment.

The SQL query started life by dragging the database table on to the visual JSF table component.  Then I use the visual
SQL editor to add the additional table, slowly click the checkboxes (either in the little table window up top or in the
middle columns section - tried both) to remove the unwanted columns, and finally add a criteria to join the two tables.
 The criteria is always a join such as public.assocation_domains.domain_id = public.domain.domain_id.  I have done this
at at least a half dozen times in the last week and the editor has added anywhere from 100,000 to 8 million blank spaces
after the end-quote of the query (perhaps it depends on how many columns I get rid of?).  In the SQL editor at the
bottom, I don't see the spaces, and have edited the SQL in there just to see if it fixes the problem, but it doesn't
seem to. So while I have *edited* the SQL in the editor, I haven't *created* it that way.
Comment 3 Petr Blaha 2008-11-18 13:17:43 UTC 
Move visualsqleditor subcomponents below visualweb
Comment 4 Peter Zavadsky 2008-12-16 20:28:03 UTC 
This one needs a closer look of the owner.