An NPE is seen under 7.4.1, however in 7.7.1/8.1 it is an indexoutofbounds exception. 7.4.1 may have an intervening issue, such as ~~TEIID-2041~~. The underlying cause is RuleMergeVirtual not correcting the order by above the union.
Change By:	Steven Hawkins (27/Jun/12 12:38 PM)
Fix Version/s:	8.1
Description:	Adding ORDER BY when querying a VIEW made up of a VIEW using 3+ UNION ALL statements using GROUP BY in the source VIEWS causes a NPE an error .
Bugzilla References:	https://bugzilla.redhat.com/show_bug.cgi?id=835896
Steps to Reproduce:	1. Deploy the attached VDB (no sources needed) 2. Attach to Unified.vdb 3. Run the following: SELECT status FROM unified.view_unified WHERE enterprise_id = 102 order by status Actual results: NPE Expected results: Not an NPE

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators.
For more information on JIRA, see: http://www.atlassian.com/software/jira