[JBoss JIRA] Created: (TEIID-1643) Teiid not qualifying returned result data element when AS used in query
9:01 p.m.
Teiid not qualifying returned result data element when AS used in query
-----------------------------------------------------------------------
Key: TEIID-1643
URL: https://issues.jboss.org/browse/TEIID-1643
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.5
Reporter: Warren Gibson
Assignee: Steven Hawkins
Attachments: QT_MySql50_Push.vdb
Not qualifying result data element when AS used in query. Example query below.
SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey FROM
BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey WHERE
(BQT1.SmallA.IntKey >= 0) AND (BQT1.SmallA.IntKey <= 15) AND
(BQT2.MediumB.IntKey >= 5) AND (BQT2.MediumB.IntKey <= 20) ORDER BY
SmallA_IntKey, MediumB_IntKey
Actual Results:
<dataElement type="integer">IntKey</dataElement>
<dataElement type="integer">IntKey</dataElement>
Expected Results:
<dataElement type="integer">SmallA_IntKey</dataElement>
<dataElement type="integer">MediumB_IntKey</dataElement>
VDB attached.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:01 p.m.
New subject: [JBoss JIRA] Updated: (TEIID-1643) Teiid not qualifying returned result data element when AS used in query
[
https://issues.jboss.org/browse/TEIID-1643?page=com.atlassian.jira.plugin...
]
Warren Gibson updated TEIID-1643:
---------------------------------
Attachment: QT_MySql50_Push.vdb
Teiid not qualifying returned result data element when AS used in
query
-----------------------------------------------------------------------
Key: TEIID-1643
URL: https://issues.jboss.org/browse/TEIID-1643
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.5
Reporter: Warren Gibson
Assignee: Steven Hawkins
Attachments: QT_MySql50_Push.vdb
Not qualifying result data element when AS used in query. Example query below.
SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey FROM
BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey WHERE
(BQT1.SmallA.IntKey >= 0) AND (BQT1.SmallA.IntKey <= 15) AND
(BQT2.MediumB.IntKey >= 5) AND (BQT2.MediumB.IntKey <= 20) ORDER BY
SmallA_IntKey, MediumB_IntKey
Actual Results:
<dataElement type="integer">IntKey</dataElement>
<dataElement type="integer">IntKey</dataElement>
Expected Results:
<dataElement type="integer">SmallA_IntKey</dataElement>
<dataElement type="integer">MediumB_IntKey</dataElement>
VDB attached.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 p.m.
New subject: [JBoss JIRA] Resolved: (TEIID-1643) Teiid not qualifying returned result data element when AS used in query
[
https://issues.jboss.org/browse/TEIID-1643?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1643.
-----------------------------------
Resolution: Rejected
7.4 fixed the notion of column name vs. column label. CTC is using the column name which
is the non-aliased form.
Teiid not qualifying returned result data element when AS used in
query
-----------------------------------------------------------------------
Key: TEIID-1643
URL: https://issues.jboss.org/browse/TEIID-1643
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.5
Reporter: Warren Gibson
Assignee: Steven Hawkins
Attachments: QT_MySql50_Push.vdb
Not qualifying result data element when AS used in query. Example query below.
SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey FROM
BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey WHERE
(BQT1.SmallA.IntKey >= 0) AND (BQT1.SmallA.IntKey <= 15) AND
(BQT2.MediumB.IntKey >= 5) AND (BQT2.MediumB.IntKey <= 20) ORDER BY
SmallA_IntKey, MediumB_IntKey
Actual Results:
<dataElement type="integer">IntKey</dataElement>
<dataElement type="integer">IntKey</dataElement>
Expected Results:
<dataElement type="integer">SmallA_IntKey</dataElement>
<dataElement type="integer">MediumB_IntKey</dataElement>
VDB attached.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:07 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1643) Teiid not qualifying returned result data element when AS used in query
[
https://issues.jboss.org/browse/TEIID-1643?page=com.atlassian.jira.plugin...
]
Paul Nittel commented on TEIID-1643:
------------------------------------
Steve, to be clear, I ran this from SQuirreL (Teiid 7.5 Alpha 1) and it returned a column
with a heading of "id". I expected "mad_dog".
select id as max_dog from wx where mailFrom like '%gov' limit 5
Teiid not qualifying returned result data element when AS used in
query
-----------------------------------------------------------------------
Key: TEIID-1643
URL: https://issues.jboss.org/browse/TEIID-1643
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.5
Reporter: Warren Gibson
Assignee: Steven Hawkins
Attachments: QT_MySql50_Push.vdb
Not qualifying result data element when AS used in query. Example query below.
SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey FROM
BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey WHERE
(BQT1.SmallA.IntKey >= 0) AND (BQT1.SmallA.IntKey <= 15) AND
(BQT2.MediumB.IntKey >= 5) AND (BQT2.MediumB.IntKey <= 20) ORDER BY
SmallA_IntKey, MediumB_IntKey
Actual Results:
<dataElement type="integer">IntKey</dataElement>
<dataElement type="integer">IntKey</dataElement>
Expected Results:
<dataElement type="integer">SmallA_IntKey</dataElement>
<dataElement type="integer">MediumB_IntKey</dataElement>
VDB attached.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:09 a.m.
New subject: [JBoss JIRA] Commented: (TEIID-1643) Teiid not qualifying returned result data element when AS used in query
[
https://issues.jboss.org/browse/TEIID-1643?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1643:
---------------------------------------
To be clearer, it matters if you are asking for the column name or the column label. The
name in your example is id, the label is mad_dog.
Teiid not qualifying returned result data element when AS used in
query
-----------------------------------------------------------------------
Key: TEIID-1643
URL: https://issues.jboss.org/browse/TEIID-1643
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.5
Reporter: Warren Gibson
Assignee: Steven Hawkins
Attachments: QT_MySql50_Push.vdb
Not qualifying result data element when AS used in query. Example query below.
SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey FROM
BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey WHERE
(BQT1.SmallA.IntKey >= 0) AND (BQT1.SmallA.IntKey <= 15) AND
(BQT2.MediumB.IntKey >= 5) AND (BQT2.MediumB.IntKey <= 20) ORDER BY
SmallA_IntKey, MediumB_IntKey
Actual Results:
<dataElement type="integer">IntKey</dataElement>
<dataElement type="integer">IntKey</dataElement>
Expected Results:
<dataElement type="integer">SmallA_IntKey</dataElement>
<dataElement type="integer">MediumB_IntKey</dataElement>
VDB attached.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:07 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1643) Teiid not qualifying returned result data element when AS used in query
[
https://issues.jboss.org/browse/TEIID-1643?page=com.atlassian.jira.plugin...
]
Paul Nittel commented on TEIID-1643:
------------------------------------
Is there a connection option, like useJDBC4ColumnNameAndLabelSemantics, which allows Teiid
to act like it did in prior releases? Would help those for whom this different behavior is
a problem.
Teiid not qualifying returned result data element when AS used in
query
-----------------------------------------------------------------------
Key: TEIID-1643
URL: https://issues.jboss.org/browse/TEIID-1643
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.5
Reporter: Warren Gibson
Assignee: Steven Hawkins
Attachments: QT_MySql50_Push.vdb
Not qualifying result data element when AS used in query. Example query below.
SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey FROM
BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey WHERE
(BQT1.SmallA.IntKey >= 0) AND (BQT1.SmallA.IntKey <= 15) AND
(BQT2.MediumB.IntKey >= 5) AND (BQT2.MediumB.IntKey <= 20) ORDER BY
SmallA_IntKey, MediumB_IntKey
Actual Results:
<dataElement type="integer">IntKey</dataElement>
<dataElement type="integer">IntKey</dataElement>
Expected Results:
<dataElement type="integer">SmallA_IntKey</dataElement>
<dataElement type="integer">MediumB_IntKey</dataElement>
VDB attached.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:51 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1643) Teiid not qualifying returned result data element when AS used in query
[
https://issues.jboss.org/browse/TEIID-1643?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1643:
---------------------------------------
I don't see this as a backwards compatibility issue. If users want the column label,
then they should call getColumnLabel.
Teiid not qualifying returned result data element when AS used in
query
-----------------------------------------------------------------------
Key: TEIID-1643
URL: https://issues.jboss.org/browse/TEIID-1643
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.5
Reporter: Warren Gibson
Assignee: Steven Hawkins
Attachments: QT_MySql50_Push.vdb
Not qualifying result data element when AS used in query. Example query below.
SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey FROM
BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey WHERE
(BQT1.SmallA.IntKey >= 0) AND (BQT1.SmallA.IntKey <= 15) AND
(BQT2.MediumB.IntKey >= 5) AND (BQT2.MediumB.IntKey <= 20) ORDER BY
SmallA_IntKey, MediumB_IntKey
Actual Results:
<dataElement type="integer">IntKey</dataElement>
<dataElement type="integer">IntKey</dataElement>
Expected Results:
<dataElement type="integer">SmallA_IntKey</dataElement>
<dataElement type="integer">MediumB_IntKey</dataElement>
VDB attached.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:46 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1643) Teiid not qualifying returned result data element when AS used in query
[
https://issues.jboss.org/browse/TEIID-1643?page=com.atlassian.jira.plugin...
]
Paul Nittel commented on TEIID-1643:
------------------------------------
Not meaning to flog this pretty dead horse, but what if the user's software is some
proprietary gizmo over which they have no control? I'm just sayin'...
Teiid not qualifying returned result data element when AS used in
query
-----------------------------------------------------------------------
Key: TEIID-1643
URL: https://issues.jboss.org/browse/TEIID-1643
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.5
Reporter: Warren Gibson
Assignee: Steven Hawkins
Attachments: QT_MySql50_Push.vdb
Not qualifying result data element when AS used in query. Example query below.
SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey FROM
BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey WHERE
(BQT1.SmallA.IntKey >= 0) AND (BQT1.SmallA.IntKey <= 15) AND
(BQT2.MediumB.IntKey >= 5) AND (BQT2.MediumB.IntKey <= 20) ORDER BY
SmallA_IntKey, MediumB_IntKey
Actual Results:
<dataElement type="integer">IntKey</dataElement>
<dataElement type="integer">IntKey</dataElement>
Expected Results:
<dataElement type="integer">SmallA_IntKey</dataElement>
<dataElement type="integer">MediumB_IntKey</dataElement>
VDB attached.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:24 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1643) Teiid not qualifying returned result data element when AS used in query
[
https://issues.jboss.org/browse/TEIID-1643?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1643:
---------------------------------------
Then they would probably want what they are asking for - the column name, not the column
label. Patches are welcome for treating column names as column labels via a connection
property.
Teiid not qualifying returned result data element when AS used in
query
-----------------------------------------------------------------------
Key: TEIID-1643
URL: https://issues.jboss.org/browse/TEIID-1643
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.5
Reporter: Warren Gibson
Assignee: Steven Hawkins
Attachments: QT_MySql50_Push.vdb
Not qualifying result data element when AS used in query. Example query below.
SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey FROM
BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey WHERE
(BQT1.SmallA.IntKey >= 0) AND (BQT1.SmallA.IntKey <= 15) AND
(BQT2.MediumB.IntKey >= 5) AND (BQT2.MediumB.IntKey <= 20) ORDER BY
SmallA_IntKey, MediumB_IntKey
Actual Results:
<dataElement type="integer">IntKey</dataElement>
<dataElement type="integer">IntKey</dataElement>
Expected Results:
<dataElement type="integer">SmallA_IntKey</dataElement>
<dataElement type="integer">MediumB_IntKey</dataElement>
VDB attached.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:34 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1643) Teiid not qualifying returned result data element when AS used in query
[
https://issues.jboss.org/browse/TEIID-1643?page=com.atlassian.jira.plugin...
]
Warren Gibson commented on TEIID-1643:
--------------------------------------
Customers (vendors or clients) using metadata in their application will be impacted by
this. Backward compatibility is broken by the simple fact that we now require them to
change to use us.
Teiid not qualifying returned result data element when AS used in
query
-----------------------------------------------------------------------
Key: TEIID-1643
URL: https://issues.jboss.org/browse/TEIID-1643
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.5
Reporter: Warren Gibson
Assignee: Steven Hawkins
Attachments: QT_MySql50_Push.vdb
Not qualifying result data element when AS used in query. Example query below.
SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey FROM
BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey WHERE
(BQT1.SmallA.IntKey >= 0) AND (BQT1.SmallA.IntKey <= 15) AND
(BQT2.MediumB.IntKey >= 5) AND (BQT2.MediumB.IntKey <= 20) ORDER BY
SmallA_IntKey, MediumB_IntKey
Actual Results:
<dataElement type="integer">IntKey</dataElement>
<dataElement type="integer">IntKey</dataElement>
Expected Results:
<dataElement type="integer">SmallA_IntKey</dataElement>
<dataElement type="integer">MediumB_IntKey</dataElement>
VDB attached.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:51 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1643) Teiid not qualifying returned result data element when AS used in query
[
https://issues.jboss.org/browse/TEIID-1643?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1643:
---------------------------------------
You are expecting that:
a) the vendor/client wants the column label
b) the vendor/client expects getColumnName to report the column label - even though this
is not the case for other drivers
c) the vendor/client cannot change the call to getColumnLabel
It's not a question of whether that could happen, it's just a question of
prioritization. In general for other bugs we typically don't ask ourself if anyone is
dependent upon incorrect behavior. It seems needlessly proactive to offer a backwards
compatibility mode that no one may ever use given the workaround.
But just as I said above, if someone else provides a patch with docs, etc. then we can
certainly include it.
Teiid not qualifying returned result data element when AS used in
query
-----------------------------------------------------------------------
Key: TEIID-1643
URL: https://issues.jboss.org/browse/TEIID-1643
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.5
Reporter: Warren Gibson
Assignee: Steven Hawkins
Attachments: QT_MySql50_Push.vdb
Not qualifying result data element when AS used in query. Example query below.
SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey FROM
BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey WHERE
(BQT1.SmallA.IntKey >= 0) AND (BQT1.SmallA.IntKey <= 15) AND
(BQT2.MediumB.IntKey >= 5) AND (BQT2.MediumB.IntKey <= 20) ORDER BY
SmallA_IntKey, MediumB_IntKey
Actual Results:
<dataElement type="integer">IntKey</dataElement>
<dataElement type="integer">IntKey</dataElement>
Expected Results:
<dataElement type="integer">SmallA_IntKey</dataElement>
<dataElement type="integer">MediumB_IntKey</dataElement>
VDB attached.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:57 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1643) Teiid not qualifying returned result data element when AS used in query
[
https://issues.jboss.org/browse/TEIID-1643?page=com.atlassian.jira.plugin...
]
Steve Jacobs commented on TEIID-1643:
-------------------------------------
After a quick Google search, it looks like several products are using
useJDBC4ColumnNameAndLabelSemantics as a property to control this behavior. What would it
take to patch this? Something Van could contribute to 7.4.1?
Teiid not qualifying returned result data element when AS used in
query
-----------------------------------------------------------------------
Key: TEIID-1643
URL: https://issues.jboss.org/browse/TEIID-1643
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.5
Reporter: Warren Gibson
Assignee: Steven Hawkins
Attachments: QT_MySql50_Push.vdb
Not qualifying result data element when AS used in query. Example query below.
SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey FROM
BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey WHERE
(BQT1.SmallA.IntKey >= 0) AND (BQT1.SmallA.IntKey <= 15) AND
(BQT2.MediumB.IntKey >= 5) AND (BQT2.MediumB.IntKey <= 20) ORDER BY
SmallA_IntKey, MediumB_IntKey
Actual Results:
<dataElement type="integer">IntKey</dataElement>
<dataElement type="integer">IntKey</dataElement>
Expected Results:
<dataElement type="integer">SmallA_IntKey</dataElement>
<dataElement type="integer">MediumB_IntKey</dataElement>
VDB attached.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:03 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1643) Teiid not qualifying returned result data element when AS used in query
[
https://issues.jboss.org/browse/TEIID-1643?page=com.atlassian.jira.plugin...
]
Van Halbert commented on TEIID-1643:
------------------------------------
This property option should probably be available in 7.5 and forward as well.
Teiid not qualifying returned result data element when AS used in
query
-----------------------------------------------------------------------
Key: TEIID-1643
URL: https://issues.jboss.org/browse/TEIID-1643
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.5
Reporter: Warren Gibson
Assignee: Steven Hawkins
Attachments: QT_MySql50_Push.vdb
Not qualifying result data element when AS used in query. Example query below.
SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey FROM
BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey WHERE
(BQT1.SmallA.IntKey >= 0) AND (BQT1.SmallA.IntKey <= 15) AND
(BQT2.MediumB.IntKey >= 5) AND (BQT2.MediumB.IntKey <= 20) ORDER BY
SmallA_IntKey, MediumB_IntKey
Actual Results:
<dataElement type="integer">IntKey</dataElement>
<dataElement type="integer">IntKey</dataElement>
Expected Results:
<dataElement type="integer">SmallA_IntKey</dataElement>
<dataElement type="integer">MediumB_IntKey</dataElement>
VDB attached.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:37 p.m.
New subject: [JBoss JIRA] Closed: (TEIID-1643) Teiid not qualifying returned result data element when AS used in query
[
https://issues.jboss.org/browse/TEIID-1643?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1643.
---------------------------------
Teiid not qualifying returned result data element when AS used in
query
-----------------------------------------------------------------------
Key: TEIID-1643
URL: https://issues.jboss.org/browse/TEIID-1643
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.5
Reporter: Warren Gibson
Assignee: Steven Hawkins
Attachments: QT_MySql50_Push.vdb
Not qualifying result data element when AS used in query. Example query below.
SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey FROM
BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey WHERE
(BQT1.SmallA.IntKey >= 0) AND (BQT1.SmallA.IntKey <= 15) AND
(BQT2.MediumB.IntKey >= 5) AND (BQT2.MediumB.IntKey <= 20) ORDER BY
SmallA_IntKey, MediumB_IntKey
Actual Results:
<dataElement type="integer">IntKey</dataElement>
<dataElement type="integer">IntKey</dataElement>
Expected Results:
<dataElement type="integer">SmallA_IntKey</dataElement>
<dataElement type="integer">MediumB_IntKey</dataElement>
VDB attached.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4703
days inactive
4761
days old
13 comments
5 participants
participants (5)
-
Paul Nittel (JIRA) -
Steve Jacobs (JIRA)
-
Steven Hawkins (JIRA)
-
Van Halbert (JIRA)
-
Warren Gibson (JIRA)