11:17 a.m.
Query inexplicably failing Query Testing only with MySQL
--------------------------------------------------------
Key: TEIID-894
URL: https://jira.jboss.org/jira/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
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/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:19 a.m.
New subject: [JBoss JIRA] Updated: (TEIID-894) Query inexplicably failing Query Testing only with MySQL
[
https://jira.jboss.org/jira/browse/TEIID-894?page=com.atlassian.jira.plug...
]
Paul Nittel updated TEIID-894:
------------------------------
Attachment: QT_MySql41.vdb
teiid.log
This is the VDB I used and the log it produced when run with OPTION DEBUG.
Query inexplicably failing Query Testing only with MySQL
--------------------------------------------------------
Key: TEIID-894
URL: https://jira.jboss.org/jira/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
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/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:36 a.m.
New subject: [JBoss JIRA] Commented: (TEIID-894) Query inexplicably failing Query Testing only with MySQL
[
https://jira.jboss.org/jira/browse/TEIID-894?page=com.atlassian.jira.plug...
]
Paul Nittel commented on TEIID-894:
-----------------------------------
BTW, if I flip the query elements (BQT1.SmallA becomes BQT2.SmallB and vice versa), the
same things happen. (I tried adding the IntKey from the WHERE clause to the SELECT and it
still returned 0 rows.
Query inexplicably failing Query Testing only with MySQL
--------------------------------------------------------
Key: TEIID-894
URL: https://jira.jboss.org/jira/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
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/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:05 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-894) Query inexplicably failing Query Testing only with MySQL
[
https://jira.jboss.org/jira/browse/TEIID-894?page=com.atlassian.jira.plug...
]
Steven Hawkins commented on TEIID-894:
--------------------------------------
What are the values in BQT2.SmallB.Intkey, and what is it's transformation?
Query inexplicably failing Query Testing only with MySQL
--------------------------------------------------------
Key: TEIID-894
URL: https://jira.jboss.org/jira/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
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/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:42 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-894) Query inexplicably failing Query Testing only with MySQL
[
https://jira.jboss.org/jira/browse/TEIID-894?page=com.atlassian.jira.plug...
]
Paul Nittel commented on TEIID-894:
-----------------------------------
IntKey is a biginteger in the source and undergoes "convert(Intkey, integer) as
IntKey" in the transformation.
The values of IntKey are 0 through 49 (50 rows)
Query inexplicably failing Query Testing only with MySQL
--------------------------------------------------------
Key: TEIID-894
URL: https://jira.jboss.org/jira/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
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/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:37 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-894) Query inexplicably failing Query Testing only with MySQL
[
https://jira.jboss.org/jira/browse/TEIID-894?page=com.atlassian.jira.plug...
]
Steven Hawkins commented on TEIID-894:
--------------------------------------
Can you attach the log for the failing case?
Query inexplicably failing Query Testing only with MySQL
--------------------------------------------------------
Key: TEIID-894
URL: https://jira.jboss.org/jira/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
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/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:47 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-894) Query inexplicably failing Query Testing only with MySQL
[
https://jira.jboss.org/jira/browse/TEIID-894?page=com.atlassian.jira.plug...
]
Paul Nittel commented on TEIID-894:
-----------------------------------
Steve, I believe the attached log shows both successful and failed attempts.
Query inexplicably failing Query Testing only with MySQL
--------------------------------------------------------
Key: TEIID-894
URL: https://jira.jboss.org/jira/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
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/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:51 p.m.
New subject: [JBoss JIRA] Updated: (TEIID-894) Query inexplicably failing Query Testing only with MySQL
[
https://jira.jboss.org/jira/browse/TEIID-894?page=com.atlassian.jira.plug...
]
Steven Hawkins updated TEIID-894:
---------------------------------
Fix Version/s: 7.0
Complexity: Low
There are two issues on our side. The resolving logic is inappropriately considering the
common type between float and int as bigdecimal, then the comparison logic for depdentsets
uses Java's equals method for bigdecimal, which considers precision and scale.
Query inexplicably failing Query Testing only with MySQL
--------------------------------------------------------
Key: TEIID-894
URL: https://jira.jboss.org/jira/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/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:09 p.m.
New subject: [JBoss JIRA] Resolved: (TEIID-894) Query inexplicably failing Query Testing only with MySQL
[
https://jira.jboss.org/jira/browse/TEIID-894?page=com.atlassian.jira.plug...
]
Steven Hawkins resolved TEIID-894.
----------------------------------
Resolution: Done
Corrected the datatypemanager to return the appropriate implicit types. Also changed the
evaluator to use a linear search with compare over bigdecimal values. We really need to
introduce our own type value class or type class to handle this consistently...
Query inexplicably failing Query Testing only with MySQL
--------------------------------------------------------
Key: TEIID-894
URL: https://jira.jboss.org/jira/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/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:09 a.m.
New subject: [JBoss JIRA] Closed: (TEIID-894) Query inexplicably failing Query Testing only with MySQL
[
https://jira.jboss.org/browse/TEIID-894?page=com.atlassian.jira.plugin.sy...
]
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
5122
days inactive
5321
days old
9 comments
3 participants
participants (3)
-
Paul Nittel (JIRA) -
Steve Hawkins (JIRA)
-
Steven Hawkins (JIRA)