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 - Invalid JOIN notation
Summary: Invalid JOIN notation
Status: NEW
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 5.x
Hardware: PC Windows XP
: P3 blocker (vote)
Assignee: John Baker
Depends on:
Blocks: 152776
  Show dependency tree
Reported: 2007-02-05 19:59 UTC by bugbridge
Modified: 2009-05-25 21:07 UTC (History)
2 users (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 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

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

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