[
https://issues.jboss.org/browse/TEIID-3877?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-3877:
---------------------------------------
One option is use an anonymous procedure instead of the just a simple query:
begin
insert into #temp select ...;
select * from #temp order by ...;
end
Putting the responsibility on the test tool is possible as well, but you'd likely want
to do just a lexical sort.
Sort result set before BQT comparison
-------------------------------------
Key: TEIID-3877
URL:
https://issues.jboss.org/browse/TEIID-3877
Project: Teiid
Issue Type: Feature Request
Components: Tools
Environment: BQT 2.2.0
JBoss DV 6.2
Reporter: Jean-Pierre Matsumoto
Assignee: Van Halbert
Priority: Minor
Currently it is not possible to ask to BQT to sort result set before it compares to
reference. When an SQL query returns rows in a random order, the BQT test fails because of
the different order of rows.
I know I could use ORDER BY in the SQL but I don't like much this solution because it
impacts the query plan.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)