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 107173

Summary:	Error parsing mysql query within project
Product:	obsolete	Reporter:	Alexey Butenko <alexeybutenko>
Component:	visualweb	Assignee:	_ jimdavidson <jimdavidson>
Status:	RESOLVED FIXED
Severity:	blocker
Priority:	P1
Version:	6.x
Hardware:	All
OS:	All
Issue Type:	DEFECT	Exception Reporter:
Bug Depends on:
Bug Blocks:	106402
Attachments:	error

Description Alexey Butenko 2007-06-19 12:03:27 UTC

Netbeans IDE Dev 070618

I created new issue because it differ from 106822

- Create VW project
- Add mysql person table on designer
- Open it in Query Editor by double click on personRowSet under SessionBean1 node in Navigator window
- Run Query
Query processing error occured (see attached)

Comment 1 Alexey Butenko 2007-06-19 12:06:06 UTC

Created attachment 43949 [details]
error

Comment 2 _ jimdavidson 2007-06-20 22:06:11 UTC

Probably a duplicate of 106822, but I'll leave it separate for now.

Comment 3 _ jimdavidson 2007-06-22 20:43:53 UTC

Extended the VisualSQLEditorMetaData api to provide information about the quote character used for SQL delimited
identifiers.

Modified the Query Editor to use that information when generating a delimited identifier.

Note that another workaround is to run the MySQL server in ANSI_QUOTES mode, so that it complies with the #$%^&* standard.

Comment 4 Peter Pis 2007-06-26 08:16:20 UTC

To Reporter: Could you please verify this issue? Thanks.

Comment 5 Petr Blaha 2008-11-18 13:18:53 UTC

Move visualsqleditor subcomponents below visualweb