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 189863 - Selfformating sql results in broken query
Summary: Selfformating sql results in broken query
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: All All
: P3 normal (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-08-25 16:44 UTC by mk2king
Modified: 2010-11-01 14:11 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
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 mk2king 2010-08-25 16:44:13 UTC 
Product Version = NetBeans IDE 6.9 (Build 201007282301)
Operating System = Linux version 2.6.32-24-generic running on i386
Java; VM; Vendor = 1.6.0_20
Runtime = Java HotSpot(TM) Client VM 16.3-b01

Having a query all in one line like this 
	"SELECT * FROM table.column LIMIT 10" works 
but having a query formated like this
	"SELECT * FROM table.column
	LIMIT 10"
results in an errorneous SQL query. Tested with a MySQL database.
Comment 1 Peter Pis 2010-08-26 07:26:08 UTC 
Reassigning.
Comment 2 Jiri Rechtacek 2010-08-26 08:00:12 UTC 
I guess it's fixed in NB6.10 already but I cannot recall issue number.
Comment 3 Jiri Rechtacek 2010-11-01 14:11:57 UTC 
Fixed in NB7.0M2