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.
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.
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.
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.
Move visualsqleditor subcomponents below visualweb
This one needs a closer look of the owner.