[jira] [Created] (TRAFODION-416) LP Bug: 1339156 - query with subqueries occasionally return wrong results

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-416:
------------------------------------

             Summary: LP Bug: 1339156 - query with subqueries occasionally return wrong results
                 Key: TRAFODION-416
                 URL: https://issues.apache.org/jira/browse/TRAFODION-416
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Apache Trafodion
            Assignee: justin.du@hp.com
            Priority: Critical


Test compGeneral/TEST011 randomly fails. The text of the query that is occasionally failing is:

prepare XX from
 Select t40.a
 From t40
 Where (select max (t41.b)
          From t41
          Where  t40.c = t41.c) = (select max (t42.b) from t42  where t40.d = t42.d)
          order by t40.a;

The problem shows up very randomly. I rerun the test around 20 times and only seen the issue twice or three times. I can see that when the issue happens the plan does not change.  The problem is that a row is missing from the result set and the missing row is different every time the test fails.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)