[teiid-issues] [JBoss JIRA] (TEIID-3877) Sort result set before BQT comparison

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3877?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13273661#comment-13273661 ] 

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)