Generated SQL does not match UBE data selection

[ddichev]

Hello
I have a UBE in which the data selection requires the LT column from a business view to be equal to "AA" (not equal to or empty or anything else, just "equal to"), but I was getting other entries as well, so I went on to check the SQL query that is generated on execution, and and the part about the LT column is wrong - instead of LT = :Key3 (the Key3 being "AA" in this case), I get LT = :Key3 OR LT = NULL. Why does it accept the null values, when I explicitly tell it to only look for a certain value? Is there a particular reason for this behavior, or is it some sort of bug? Any help will be appreciated.

 

[craig_welton]

Sounds like you are using an outer join and the where clause is on a column in the outer table. You can change the join type to SQL 92 Outer in the BSVW designer to stop that behaviour.

Craig

 

[ddichev]

Thank you very much Craig, right on target. Should have looked harder at the query - I didn't notice the connection between the old Oracle syntax and the result.