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 - Adding Table inserts 8,000,000 blank spaces
Summary: Adding Table inserts 8,000,000 blank spaces
Status: NEW
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 6.x
Hardware: Other Linux
: P2 blocker (vote)
Assignee: John Baker
Depends on:
Reported: 2008-10-27 18:16 UTC by uvicpaul
Modified: 2008-12-16 20:28 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Note You need to log in before you can comment on or make changes to this bug.
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 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.