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
URL:
Keywords:
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:

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 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