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

[Van Halbert (JIRA)]

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

Van Halbert commented on TEIID-3877:
------------------------------------

Jean-Pierre,

The BQT (SQLBulkQuery) has been deprecated and its replacement is: 

- github:  https://github.com/teiid/whipper
- jira: https://issues.jboss.org/browse/TEIIDWHIP

After using the new project and you still need this issue, this jira can be moved or another one created.

> 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)