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 94490

Summary:	Invalid JOIN notation
Product:	obsolete	Reporter:	bugbridge <bugbridge>
Component:	visualweb	Assignee:	John Baker <jbaker>
Status:	NEW ---
Severity:	blocker	CC:	mikhailmatveev, romanmostyka
Priority:	P3
Version:	5.x
Hardware:	PC
OS:	Windows XP
Issue Type:	DEFECT	Exception Reporter:
Bug Depends on:
Bug Blocks:	152776

Description bugbridge 2007-02-05 19:59:05 UTC

Original status: 5-Cause Known; Suggested Status: NEW

Original Target Release: mako_dev; Suggested Target Milestone : Dev


Original submitter: mikhailmatveev

Description:
0. Open rowset for TRIP table of Sybase TRAVEL or DB2 schema.
1. Add TRIPTYPE table.
2. Add PERSON table.
Result: only first JOIN is displayed as INNER JOIN in SQL pane. Second (PERSON
--> TRIP) is displayed as
  WHERE dbo.Trip.PersonID = dbo.Person.PersonID 

Further operations give consequent errors.
3. Select join arrow between PERSON and TRIP.
4. Change its type from INNER to LEFT OUTER.
Result: no effect in SQL pane.
5. Remove TRIPTYPE table from query via diagram pane.
6. Select join arrow between PERSON and TRIP.
Result: join has no TYPE property at all (Type property is one of INNER, LEFT
OUTER, RIGHT OUTER).

Evaluation:
Fixing for Thresher is risky.

Comment 1 John Baker 2008-03-28 19:28:29 UTC

Still same invalid behavior.   Should fix for the next release, but risky to fix for 6.1.

Workaround is to edit the SQL that is generated.

Comment 2 Petr Blaha 2008-11-18 13:23:04 UTC

Move visualsqleditor subcomponents below visualweb