Changing the order of Result Objects effects nbr of rows

We are on Sybase 12.5
If I change the order of objects in Query panel, the number of rows fetched vary drastically.

The query joins 6 tables (including aliases).
Changing the order of objects changes the join conditions on tables. Some LEFT OUTER joins are converted to RIGHT OUTER joins. :crazy_face: :crazy_face:
One query fetches 42 rows while other fetches 725 rows and takes ages to run. :reallymad:

Has anyone noticed this earlier?


mkumar (BOB member since 2002-08-26)

Eek! Are both the left and right outer joins defined in your universe? Or is BO just making one of them up? What version of BO is this?


Nick Daniels :uk: (BOB member since 2002-08-15)

What version of BO?


Steve Krandel :us: (BOB member since 2002-06-25)

I have a company table and ext_company table

Affiliate_co is an alias of company
Affiliate_company is an alias of ext_comany

In universe I have outer join box checked on Affiliate_company while defining the join between Affiliate_company and Affiliate_co.

One particular order of objects in Query panel results in following join condition in BO generated query.


(company  Affiliate_co RIGHT OUTER JOIN ext_company  Affiliate_company ON(Affiliate_company.company_id = Affiliate_co.company_id) )

If I change the order of objects in query, the join between these two table becomes

 LEFT OUTER JOIN company  Affiliate_co ON (Affiliate_company.company_id=Affiliate_co.company_id) )

It is BO 6.0.1


mkumar (BOB member since 2002-08-26)

You’re not really using 6.0.1 are you?

Nothing would surprise me with 6.0.x. You need to try 6.1b and see if this helps.


Steve Krandel :us: (BOB member since 2002-06-25)

As we are not using WebI yet, so there is not much push for upgradation.

We are going online in Sept with WebI and SSO. That time we will be upgrading to the latest version. :yesnod: :yesnod:


mkumar (BOB member since 2002-08-26)

If I recall, the placement of the tables in the Designer will also exhibit this same behavior (of joins Changing from Right to Left outer, etc). You may want to check your Universe to see if that has any effect.


digpen :us: (BOB member since 2002-08-15)