[teiid-issues] [JBoss JIRA] Closed: (TEIID-894) Query inexplicably failing Query Testing only with MySQL

[Steve Hawkins (JIRA)]

     [ https://jira.jboss.org/browse/TEIID-894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Hawkins closed TEIID-894.
-------------------------------



> Query inexplicably failing Query Testing only with MySQL
> --------------------------------------------------------
>
>                 Key: TEIID-894
>                 URL: https://jira.jboss.org/browse/TEIID-894
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.0
>         Environment: Fedora 10, Teiid 7.0.0 M1
>            Reporter: Paul Nittel
>            Assignee: Steven Hawkins
>             Fix For: 7.0
>
>         Attachments: QT_MySql41.vdb, teiid.log
>
>
> Series 9000, #7 fails with MySql and passes with all the other sources.
> Original Query
> SELECT BQT1.SmallA.IntKey, BQT2.SmallB.FloatNum FROM BQT1.SmallA, BQT2.SmallB WHERE BQT1.SmallA.IntKey = BQT2.SmallB.FloatNum AND BQT1.SmallA.IntKey >= 0 AND BQT2.SmallB.IntKey >= 0 ORDER BY BQT1.SmallA.IntKey;
> It's supposed to return 25 rows, but returns 0. Let's ignore the "ORDER BY" since it just adds to the code (and doesn't factor into the issue since it works the same with or without).
> If I remove the "AND BQT2.SmallB.IntKey >= 0", it works! I get 25 rows.
> SELECT BQT1.SmallA.IntKey, BQT2.SmallB.FloatNum FROM BQT1.SmallA, BQT2.SmallB WHERE BQT1.SmallA.IntKey = BQT2.SmallB.FloatNum AND BQT1.SmallA.IntKey >= 0;
> If I switch it so the first condition is removed and the second remains, it FAILS
> SELECT BQT1.SmallA.IntKey, BQT2.SmallB.FloatNum FROM BQT1.SmallA, BQT2.SmallB WHERE BQT1.SmallA.IntKey = BQT2.SmallB.FloatNum AND BQT2.SmallB.IntKey >= 0;
> What doesn't it like about "BQT2.SmallB >= 0" ?? I ran this query--and the one with only "BQT1.SmallA >= 0"--with OPTION DEBUG.
> Stuff is attached.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira