Issue Details (XML | Word | Printable)

Key: PLSQL-189
Type: New Feature New Feature
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dinesh Bolkensteyn
Reporter: Olivier Gaudin
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
PL/SQL

Rule: do not join on more than X tables

Created: 03/Feb/12 10:28 AM   Updated: 02/Mar/12 02:59 PM   Resolved: 28/Feb/12 01:33 PM
Component/s: Rules
Affects Version/s: None
Fix Version/s: 1.14


Sort Order: Ascending order - Click to sort in descending order
[ Permalink | « Hide ]
Dinesh Bolkensteyn added a comment - 28/Feb/12 08:40 AM

Joins are explained here: http://docs.oracle.com/cd/B19306_01/server.102/b14200/queries006.htm


[ Permalink | « Hide ]
Dinesh Bolkensteyn added a comment - 28/Feb/12 12:53 PM

This rule does not make sense on UPDATe or DELETE queries, which operate on a single table and cannot handle joins.


[ Permalink | « Hide ]
Dinesh Bolkensteyn added a comment - 28/Feb/12 12:54 PM

I set the default to 3, more than 3 joins will trigger this checks.


[ Permalink | « Hide ]
Dinesh Bolkensteyn added a comment - 28/Feb/12 01:33 PM

Done, should trigger on both SELECT (unreachable for now) and SELECT .. INTO


[ Permalink | « Hide ]
Olivier Gaudin added a comment - 29/Feb/12 08:35 PM

Tested
Bug tracking, issue tracking and project management software powered by Atlassian JIRA (v4.0#466) | Report a problem | Request a feature | Contact administrators