Menu

#21 AND conditions in joins are messed

open
nobody
None
5
2009-12-22
2009-12-22
No

When (visually) defining a query with multiple joins, the AND conditions are messed. For instance, defining a query such as:

SELECT *
FROM tabA
INNER JOIN tabB ON condition1 AND condition2
INNER JOIN tabC ON condition3

this may result in:

SELECT *
FROM tabA
INNER JOIN tabB ON condition1
INNER JOIN tabC ON condition3 AND condition2
Description
When (visually) defining a query with multiple joins, the AND conditions are messed. For instance, defining a query such as: SELECT * FROM tabA INNER JOIN tabB ON condition1 AND condition2 INNER JOIN tabC ON condition3 this may result in: SELECT * FROM tabA INNER JOIN tabB ON condition1 INNER JOIN tabC ON condition3 AND condition2
Show »

@see http://jira.pentaho.com/browse/PRD-2381

Discussion


Log in to post a comment.

MongoDB Logo MongoDB