Loading...

XML

Word

Printable

Steps to Reproduce:

Hide

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

Show
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
Bugzilla References:
https://bugzilla.redhat.com/show_bug.cgi?id=835896, https://bugzilla.redhat.com/show_bug.cgi?id=836552, https://bugzilla.redhat.com/show_bug.cgi?id=854995

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 an error.