[teiid-issues] [JBoss JIRA] Commented: (TEIID-1603) BQT Query not returning expected row count

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-1603:
---------------------------------------

The rewriter should be rewriting <> ALL as NOT IN, but instead it is rewriting <> ANY as NOT IN.

> BQT Query not returning expected row count
> ------------------------------------------
>
>                 Key: TEIID-1603
>                 URL: https://issues.jboss.org/browse/TEIID-1603
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.4
>         Environment: Running BQT Query Suite against Teiid 7.4
>            Reporter: Warren Gibson
>            Assignee: Steven Hawkins
>         Attachments: RDBMS_Test_Queries_9600_TestQuery63.xml
>
>
> Teiid 7.4 - the following query is returning no rows but the expected row count is 47 rows.  This was tested with MySql50 and Teradata12.  I verified the query produced 47 rows with SOA-P 5.1 GA.  See expected query results file attached.  VDB can be made available if needed.
> SELECT INTKEY, DATEVALUE, BYTENUM FROM BQT1.SmallA WHERE DATEVALUE <> ANY (SELECT DATEVALUE FROM BQT1.SmallA WHERE BYTENUM >= '-108')
> The source query from the log file is:
> SELECT cast(g_0.INTKEY AS signed) AS c_0, g_0.DATEVALUE AS c_1, g_0.BYTENUM AS c_2 FROM smalla AS g_0 WHERE g_0.DATEVALUE NOT IN (SELECT g_1.DATEVALUE FROM smalla AS g_1 WHERE g_1.BYTENUM >= -108) LIMIT 100

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira