Details
-
Bug
-
Status: Resolved
-
Critical
-
Resolution: Fixed
-
Impala 2.0
-
None
Description
The following query should return 0 rows, however 8 rows are returned.
SELECT * FROM alltypestiny t1 INNER JOIN chars_tiny t2 ON t2.vc = t1.string_col FULL OUTER JOIN alltypestiny t3 ON t3.string_col = TRIM(t2.cs) WHERE t1.date_string_col = t2.vc
Attachments
Issue Links
- is related to
-
IMPALA-1387 On-clause conjuncts of anti joins must be evaluated by the anti join.
- Resolved