[JBoss JIRA] (TEIID-1776) Ingres as source - Source Error Codes 2118, 2501, and 263071 being returned
by Steven Hawkins (Commented) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1776?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-1776:
---------------------------------------
1) Other sources such as Oracle/MySQL (TEIID-1008) have issues with certain subqueries. This scenario is simpler than TEIID-1008. Do any queries with subqueries work? What about nested subqueries?
2/3)it doesn't like the cast to time with time zone. That should be straight-forward to address.
4) Ingres believes this to be an invalid query. We could set widening numeric conversion to implicit (to simplify the join condition) and see if it likes it then, otherwise this would have to be a KI.
> Ingres as source - Source Error Codes 2118, 2501, and 263071 being returned
> ---------------------------------------------------------------------------
>
> Key: TEIID-1776
> URL: https://issues.jboss.org/browse/TEIID-1776
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 7.4.1
> Reporter: Warren Gibson
> Assignee: Steven Hawkins
>
> EDS Query Testing is getting unexpected results on 4 queries. The queries are
> listed below:
> SELECT TIMEVALUE, BYTENUM, (SELECT B.FLOATNUM FROM BQT1.SMALLA AS B WHERE (B.INTKEY = (SELECT A.INTKEY FROM BQT1.SMALLA AS A WHERE (A.STRINGNUM > 10) AND (A.INTKEY = B.INTKEY))) AND (B.INTKEY = A.INTKEY)) FROM bqt1.smalla AS a
> Error Code:2118 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:2118 Message:Source: Error Code:2118 Message:'Invalid qualifier 'g_1'. 'g_1' must be declared in the FROM clause or equivalent. If used in a target list, 'g_1' must be declared at the current scope.' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.timevalue, cast(g_0.bytenum AS tinyint), (SELECT g_1.floatnum FROM smalla AS g_1 WHERE g_1.intkey = g_0.intkey AND g_1.intkey = (SELECT g_2.intkey FROM smalla AS g_2 WHERE g_2.stringnum > '10' AND g_2.intkey = g_1.intkey)) FROM smalla AS g_0]
> ********************************************************
> SELECT BQT1.SmallA.TimeValue, BQT2.SmallB.TimestampValue FROM BQT1.SmallA, BQT2.SmallB WHERE BQT1.SmallA.TimeValue = convert(BQT2.SmallB.TimestampValue, time) AND BQT1.SmallA.IntKey >= 0 AND BQT2.SmallB.IntKey >= 0 ORDER BY BQT1.SmallA.TimeValue
> Error Code:2501 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:2501 Message:Source: Error Code:2501 Message:'line 1, Syntax error on 'with time'. The correct syntax is: SELECT [ALL|DISTINCT] target_list FROM table(s) [WHERE search_cond] [GROUP BY col(s)] [HAVING search_cond] [UNION subselect] [ORDER BY col(s)]' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.timevalue AS c_0, g_1.timestampvalue AS c_1 FROM smalla AS g_0, smallb AS g_1 WHERE g_0.timevalue = cast(g_1.timestampvalue AS time with time zone) AND g_0.intkey >= 0 AND g_1.intkey >= 0 ORDER BY c_0]
> ********************************************************
> SELECT BQT1.SmallA.TimeValue, BQT1.SmallB.TimestampValue FROM BQT1.SmallA, BQT1.SmallB WHERE BQT1.SmallA.TimeValue = convert(BQT1.SmallB.TimestampValue, time) AND BQT1.SmallA.IntKey >= 0 AND BQT1.SmallB.IntKey >= 0 ORDER BY BQT1.SmallA.TimeValue
> Error Code:2501 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:2501 Message:Source: Error Code:2501 Message:'line 1, Syntax error on 'with time'. The correct syntax is: SELECT [ALL|DISTINCT] target_list FROM table(s) [WHERE search_cond] [GROUP BY col(s)] [HAVING search_cond] [UNION subselect] [ORDER BY col(s)]' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.timevalue AS c_0, g_1.timestampvalue AS c_1 FROM smalla AS g_0, smallb AS g_1 WHERE g_0.timevalue = cast(g_1.timestampvalue AS time with time zone) AND g_0.intkey >= 0 AND g_1.intkey >= 0 ORDER BY c_0]
> *******************************************************
> SELECT intkey, stringkey, floatnum, bytenum, (SELECT bytenum FROM bqt1.smalla AS b WHERE (bytenum = a.longnum) AND (intkey = '10')) AS longnum FROM bqt1.smalla AS a
> Error Code:263071 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:263071 Message:Source: Error Code:263071 Message:'consistency check - all elements of boolean factor do not have same join id' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey, g_0.stringkey, g_0.floatnum, cast(g_0.bytenum AS tinyint), (SELECT cast(g_1.bytenum AS tinyint) FROM smalla AS g_1 WHERE cast(cast(g_1.bytenum AS tinyint) AS bigint) = g_0.longnum AND g_1.intkey = 10) FROM smalla AS g_0]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 7 months
[JBoss JIRA] (TEIID-1775) Ingres as source - WHERE CLAUSE is not returning expected results in some cases
by Steven Hawkins (Commented) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1775?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-1775:
---------------------------------------
1/4) is probably the same thing as TEIID-1774. We are not doing anything special to columns that are typed as time so either the native type is wrong or we'll have to KI/workaround the native issue.
2/3) we already KI that queries of that form are dangerous. The string form of a floating point number can vary platform to platform. What is the native type of floatnum and what is the output of the string form of floatnum vs. the expected. It is highly likely we would KI this.
> Ingres as source - WHERE CLAUSE is not returning expected results in some cases
> -------------------------------------------------------------------------------
>
> Key: TEIID-1775
> URL: https://issues.jboss.org/browse/TEIID-1775
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 7.4.1
> Reporter: Warren Gibson
> Assignee: Steven Hawkins
>
> EDS Query Testing is getting unexpected results on 24 queries involving WHERE CLAUSE. A few examples queries are given below:
> SELECT BQT1.SmallA.TimeValue FROM BQT1.SmallA WHERE BQT1.SmallA.TimeValue > '17:00:00' ORDER BY TimeValue (Expected 11 records but received 23)
> SELECT INTKEY, FLOATNUM FROM BQT1.SmallA WHERE RIGHT(FLOATNUM, 1) <> 0 ORDER BY INTKEY (Expected 43 records but received only 0)
> SELECT BQT1.SmallA.StringKey, BQT2.SmallB.FloatNum FROM BQT1.SmallA, BQT2.SmallB WHERE BQT1.SmallA.StringKey = convert(BQT2.SmallB.FloatNum, string) AND BQT1.SmallA.IntKey >= 0 AND BQT2.SmallB.IntKey >= 0 ORDER BY BQT1.SmallA.StringKey (Expected 25 records but received only 0)
> SELECT IntKey, TimeValue FROM (SELECT IntKey, TimeValue FROM BQT2.SmallA WHERE IntKey > 5) AS x WHERE TimeValue >= '17:00:00' ( Expected 13 records but received 20)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 7 months
[JBoss JIRA] (TEIID-1774) Ingres as source - ORDER BY on TimeValue not properly ordering results as expected
by Steven Hawkins (Commented) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1774?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-1774:
---------------------------------------
What is the native type of the time column?
> Ingres as source - ORDER BY on TimeValue not properly ordering results as expected
> ----------------------------------------------------------------------------------
>
> Key: TEIID-1774
> URL: https://issues.jboss.org/browse/TEIID-1774
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 7.4.1
> Reporter: Warren Gibson
> Assignee: Steven Hawkins
>
> EDS Query Testing is getting unexpected results on 68 queries involving ORDER BY on TimeValue. When an ORDER BY is placed on TimeValue the returned results are not ordered as expected.
> An example query is: SELECT BQT1.SmallA.TimeValue FROM BQT1.SmallA ORDER BY TimeValue
> The returned results are:
> TimeValue
> 05:00:00
> 05:00:00
> 06:00:00
> 06:00:00
> 07:00:00
> 08:00:00
> 08:00:00
> 09:00:00
> 09:00:00
> 10:00:00
> 10:00:00
> 11:00:00
> 11:00:00
> 12:00:00
> 12:00:00
> 13:00:00
> 13:00:00
> 14:00:00
> 14:00:00
> 15:00:00
> 16:00:00
> 16:00:00
> 17:00:00
> 17:00:00
> 18:00:00
> 18:00:00
> 19:00:00
> 19:00:00
> 20:00:00
> 20:00:00
> 21:00:00
> 21:00:00
> 22:00:00
> 22:00:00
> 23:00:00
> 00:00:00
> 00:00:00
> 00:00:00
> 01:00:00
> 01:00:00
> 01:00:00
> 02:00:00
> 02:00:00
> 03:00:00
> 03:00:00
> 04:00:00
> 04:00:00
> <null>
> <null>
> <null>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 7 months
[JBoss JIRA] (TEIID-1776) Ingres as source - Source Error Codes 2118, 2501, and 263071 being returned
by Van Halbert (Moved) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1776?page=com.atlassian.jira.plugin... ]
Van Halbert moved SOA-3459 to TEIID-1776:
-----------------------------------------
Project: Teiid (was: JBoss Enterprise SOA Platform)
Key: TEIID-1776 (was: SOA-3459)
Affects Version/s: 7.4.1
(was: 5.2.0.ER4)
Component/s: Misc. Connectors
(was: EDS)
Security: (was: Public)
> Ingres as source - Source Error Codes 2118, 2501, and 263071 being returned
> ---------------------------------------------------------------------------
>
> Key: TEIID-1776
> URL: https://issues.jboss.org/browse/TEIID-1776
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 7.4.1
> Reporter: Warren Gibson
> Assignee: Van Halbert
>
> EDS Query Testing is getting unexpected results on 4 queries. The queries are
> listed below:
> SELECT TIMEVALUE, BYTENUM, (SELECT B.FLOATNUM FROM BQT1.SMALLA AS B WHERE (B.INTKEY = (SELECT A.INTKEY FROM BQT1.SMALLA AS A WHERE (A.STRINGNUM > 10) AND (A.INTKEY = B.INTKEY))) AND (B.INTKEY = A.INTKEY)) FROM bqt1.smalla AS a
> Error Code:2118 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:2118 Message:Source: Error Code:2118 Message:'Invalid qualifier 'g_1'. 'g_1' must be declared in the FROM clause or equivalent. If used in a target list, 'g_1' must be declared at the current scope.' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.timevalue, cast(g_0.bytenum AS tinyint), (SELECT g_1.floatnum FROM smalla AS g_1 WHERE g_1.intkey = g_0.intkey AND g_1.intkey = (SELECT g_2.intkey FROM smalla AS g_2 WHERE g_2.stringnum > '10' AND g_2.intkey = g_1.intkey)) FROM smalla AS g_0]
> ********************************************************
> SELECT BQT1.SmallA.TimeValue, BQT2.SmallB.TimestampValue FROM BQT1.SmallA, BQT2.SmallB WHERE BQT1.SmallA.TimeValue = convert(BQT2.SmallB.TimestampValue, time) AND BQT1.SmallA.IntKey >= 0 AND BQT2.SmallB.IntKey >= 0 ORDER BY BQT1.SmallA.TimeValue
> Error Code:2501 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:2501 Message:Source: Error Code:2501 Message:'line 1, Syntax error on 'with time'. The correct syntax is: SELECT [ALL|DISTINCT] target_list FROM table(s) [WHERE search_cond] [GROUP BY col(s)] [HAVING search_cond] [UNION subselect] [ORDER BY col(s)]' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.timevalue AS c_0, g_1.timestampvalue AS c_1 FROM smalla AS g_0, smallb AS g_1 WHERE g_0.timevalue = cast(g_1.timestampvalue AS time with time zone) AND g_0.intkey >= 0 AND g_1.intkey >= 0 ORDER BY c_0]
> ********************************************************
> SELECT BQT1.SmallA.TimeValue, BQT1.SmallB.TimestampValue FROM BQT1.SmallA, BQT1.SmallB WHERE BQT1.SmallA.TimeValue = convert(BQT1.SmallB.TimestampValue, time) AND BQT1.SmallA.IntKey >= 0 AND BQT1.SmallB.IntKey >= 0 ORDER BY BQT1.SmallA.TimeValue
> Error Code:2501 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:2501 Message:Source: Error Code:2501 Message:'line 1, Syntax error on 'with time'. The correct syntax is: SELECT [ALL|DISTINCT] target_list FROM table(s) [WHERE search_cond] [GROUP BY col(s)] [HAVING search_cond] [UNION subselect] [ORDER BY col(s)]' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.timevalue AS c_0, g_1.timestampvalue AS c_1 FROM smalla AS g_0, smallb AS g_1 WHERE g_0.timevalue = cast(g_1.timestampvalue AS time with time zone) AND g_0.intkey >= 0 AND g_1.intkey >= 0 ORDER BY c_0]
> *******************************************************
> SELECT intkey, stringkey, floatnum, bytenum, (SELECT bytenum FROM bqt1.smalla AS b WHERE (bytenum = a.longnum) AND (intkey = '10')) AS longnum FROM bqt1.smalla AS a
> Error Code:263071 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:263071 Message:Source: Error Code:263071 Message:'consistency check - all elements of boolean factor do not have same join id' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey, g_0.stringkey, g_0.floatnum, cast(g_0.bytenum AS tinyint), (SELECT cast(g_1.bytenum AS tinyint) FROM smalla AS g_1 WHERE cast(cast(g_1.bytenum AS tinyint) AS bigint) = g_0.longnum AND g_1.intkey = 10) FROM smalla AS g_0]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 7 months
[JBoss JIRA] (TEIID-1776) Ingres as source - Source Error Codes 2118, 2501, and 263071 being returned
by Van Halbert (Assigned) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1776?page=com.atlassian.jira.plugin... ]
Van Halbert reassigned TEIID-1776:
----------------------------------
Assignee: Steven Hawkins (was: Van Halbert)
> Ingres as source - Source Error Codes 2118, 2501, and 263071 being returned
> ---------------------------------------------------------------------------
>
> Key: TEIID-1776
> URL: https://issues.jboss.org/browse/TEIID-1776
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 7.4.1
> Reporter: Warren Gibson
> Assignee: Steven Hawkins
>
> EDS Query Testing is getting unexpected results on 4 queries. The queries are
> listed below:
> SELECT TIMEVALUE, BYTENUM, (SELECT B.FLOATNUM FROM BQT1.SMALLA AS B WHERE (B.INTKEY = (SELECT A.INTKEY FROM BQT1.SMALLA AS A WHERE (A.STRINGNUM > 10) AND (A.INTKEY = B.INTKEY))) AND (B.INTKEY = A.INTKEY)) FROM bqt1.smalla AS a
> Error Code:2118 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:2118 Message:Source: Error Code:2118 Message:'Invalid qualifier 'g_1'. 'g_1' must be declared in the FROM clause or equivalent. If used in a target list, 'g_1' must be declared at the current scope.' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.timevalue, cast(g_0.bytenum AS tinyint), (SELECT g_1.floatnum FROM smalla AS g_1 WHERE g_1.intkey = g_0.intkey AND g_1.intkey = (SELECT g_2.intkey FROM smalla AS g_2 WHERE g_2.stringnum > '10' AND g_2.intkey = g_1.intkey)) FROM smalla AS g_0]
> ********************************************************
> SELECT BQT1.SmallA.TimeValue, BQT2.SmallB.TimestampValue FROM BQT1.SmallA, BQT2.SmallB WHERE BQT1.SmallA.TimeValue = convert(BQT2.SmallB.TimestampValue, time) AND BQT1.SmallA.IntKey >= 0 AND BQT2.SmallB.IntKey >= 0 ORDER BY BQT1.SmallA.TimeValue
> Error Code:2501 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:2501 Message:Source: Error Code:2501 Message:'line 1, Syntax error on 'with time'. The correct syntax is: SELECT [ALL|DISTINCT] target_list FROM table(s) [WHERE search_cond] [GROUP BY col(s)] [HAVING search_cond] [UNION subselect] [ORDER BY col(s)]' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.timevalue AS c_0, g_1.timestampvalue AS c_1 FROM smalla AS g_0, smallb AS g_1 WHERE g_0.timevalue = cast(g_1.timestampvalue AS time with time zone) AND g_0.intkey >= 0 AND g_1.intkey >= 0 ORDER BY c_0]
> ********************************************************
> SELECT BQT1.SmallA.TimeValue, BQT1.SmallB.TimestampValue FROM BQT1.SmallA, BQT1.SmallB WHERE BQT1.SmallA.TimeValue = convert(BQT1.SmallB.TimestampValue, time) AND BQT1.SmallA.IntKey >= 0 AND BQT1.SmallB.IntKey >= 0 ORDER BY BQT1.SmallA.TimeValue
> Error Code:2501 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:2501 Message:Source: Error Code:2501 Message:'line 1, Syntax error on 'with time'. The correct syntax is: SELECT [ALL|DISTINCT] target_list FROM table(s) [WHERE search_cond] [GROUP BY col(s)] [HAVING search_cond] [UNION subselect] [ORDER BY col(s)]' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.timevalue AS c_0, g_1.timestampvalue AS c_1 FROM smalla AS g_0, smallb AS g_1 WHERE g_0.timevalue = cast(g_1.timestampvalue AS time with time zone) AND g_0.intkey >= 0 AND g_1.intkey >= 0 ORDER BY c_0]
> *******************************************************
> SELECT intkey, stringkey, floatnum, bytenum, (SELECT bytenum FROM bqt1.smalla AS b WHERE (bytenum = a.longnum) AND (intkey = '10')) AS longnum FROM bqt1.smalla AS a
> Error Code:263071 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:263071 Message:Source: Error Code:263071 Message:'consistency check - all elements of boolean factor do not have same join id' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey, g_0.stringkey, g_0.floatnum, cast(g_0.bytenum AS tinyint), (SELECT cast(g_1.bytenum AS tinyint) FROM smalla AS g_1 WHERE cast(cast(g_1.bytenum AS tinyint) AS bigint) = g_0.longnum AND g_1.intkey = 10) FROM smalla AS g_0]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 7 months
[JBoss JIRA] (TEIID-1775) Ingres as source - WHERE CLAUSE is not returning expected results in some cases
by Van Halbert (Assigned) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1775?page=com.atlassian.jira.plugin... ]
Van Halbert reassigned TEIID-1775:
----------------------------------
Assignee: Steven Hawkins (was: Van Halbert)
> Ingres as source - WHERE CLAUSE is not returning expected results in some cases
> -------------------------------------------------------------------------------
>
> Key: TEIID-1775
> URL: https://issues.jboss.org/browse/TEIID-1775
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 7.4.1
> Reporter: Warren Gibson
> Assignee: Steven Hawkins
>
> EDS Query Testing is getting unexpected results on 24 queries involving WHERE CLAUSE. A few examples queries are given below:
> SELECT BQT1.SmallA.TimeValue FROM BQT1.SmallA WHERE BQT1.SmallA.TimeValue > '17:00:00' ORDER BY TimeValue (Expected 11 records but received 23)
> SELECT INTKEY, FLOATNUM FROM BQT1.SmallA WHERE RIGHT(FLOATNUM, 1) <> 0 ORDER BY INTKEY (Expected 43 records but received only 0)
> SELECT BQT1.SmallA.StringKey, BQT2.SmallB.FloatNum FROM BQT1.SmallA, BQT2.SmallB WHERE BQT1.SmallA.StringKey = convert(BQT2.SmallB.FloatNum, string) AND BQT1.SmallA.IntKey >= 0 AND BQT2.SmallB.IntKey >= 0 ORDER BY BQT1.SmallA.StringKey (Expected 25 records but received only 0)
> SELECT IntKey, TimeValue FROM (SELECT IntKey, TimeValue FROM BQT2.SmallA WHERE IntKey > 5) AS x WHERE TimeValue >= '17:00:00' ( Expected 13 records but received 20)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 7 months
[JBoss JIRA] (TEIID-1775) Ingres as source - WHERE CLAUSE is not returning expected results in some cases
by Van Halbert (Moved) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1775?page=com.atlassian.jira.plugin... ]
Van Halbert moved SOA-3458 to TEIID-1775:
-----------------------------------------
Project: Teiid (was: JBoss Enterprise SOA Platform)
Key: TEIID-1775 (was: SOA-3458)
Affects Version/s: 7.4.1
(was: 5.2.0.ER4)
Component/s: Misc. Connectors
(was: EDS)
Security: (was: Public)
> Ingres as source - WHERE CLAUSE is not returning expected results in some cases
> -------------------------------------------------------------------------------
>
> Key: TEIID-1775
> URL: https://issues.jboss.org/browse/TEIID-1775
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 7.4.1
> Reporter: Warren Gibson
> Assignee: Van Halbert
>
> EDS Query Testing is getting unexpected results on 24 queries involving WHERE CLAUSE. A few examples queries are given below:
> SELECT BQT1.SmallA.TimeValue FROM BQT1.SmallA WHERE BQT1.SmallA.TimeValue > '17:00:00' ORDER BY TimeValue (Expected 11 records but received 23)
> SELECT INTKEY, FLOATNUM FROM BQT1.SmallA WHERE RIGHT(FLOATNUM, 1) <> 0 ORDER BY INTKEY (Expected 43 records but received only 0)
> SELECT BQT1.SmallA.StringKey, BQT2.SmallB.FloatNum FROM BQT1.SmallA, BQT2.SmallB WHERE BQT1.SmallA.StringKey = convert(BQT2.SmallB.FloatNum, string) AND BQT1.SmallA.IntKey >= 0 AND BQT2.SmallB.IntKey >= 0 ORDER BY BQT1.SmallA.StringKey (Expected 25 records but received only 0)
> SELECT IntKey, TimeValue FROM (SELECT IntKey, TimeValue FROM BQT2.SmallA WHERE IntKey > 5) AS x WHERE TimeValue >= '17:00:00' ( Expected 13 records but received 20)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 7 months
[JBoss JIRA] (TEIID-1774) Ingres as source - ORDER BY on TimeValue not properly ordering results as expected
by Van Halbert (Assigned) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1774?page=com.atlassian.jira.plugin... ]
Van Halbert reassigned TEIID-1774:
----------------------------------
Assignee: Steven Hawkins (was: Van Halbert)
> Ingres as source - ORDER BY on TimeValue not properly ordering results as expected
> ----------------------------------------------------------------------------------
>
> Key: TEIID-1774
> URL: https://issues.jboss.org/browse/TEIID-1774
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 7.4.1
> Reporter: Warren Gibson
> Assignee: Steven Hawkins
>
> EDS Query Testing is getting unexpected results on 68 queries involving ORDER BY on TimeValue. When an ORDER BY is placed on TimeValue the returned results are not ordered as expected.
> An example query is: SELECT BQT1.SmallA.TimeValue FROM BQT1.SmallA ORDER BY TimeValue
> The returned results are:
> TimeValue
> 05:00:00
> 05:00:00
> 06:00:00
> 06:00:00
> 07:00:00
> 08:00:00
> 08:00:00
> 09:00:00
> 09:00:00
> 10:00:00
> 10:00:00
> 11:00:00
> 11:00:00
> 12:00:00
> 12:00:00
> 13:00:00
> 13:00:00
> 14:00:00
> 14:00:00
> 15:00:00
> 16:00:00
> 16:00:00
> 17:00:00
> 17:00:00
> 18:00:00
> 18:00:00
> 19:00:00
> 19:00:00
> 20:00:00
> 20:00:00
> 21:00:00
> 21:00:00
> 22:00:00
> 22:00:00
> 23:00:00
> 00:00:00
> 00:00:00
> 00:00:00
> 01:00:00
> 01:00:00
> 01:00:00
> 02:00:00
> 02:00:00
> 03:00:00
> 03:00:00
> 04:00:00
> 04:00:00
> <null>
> <null>
> <null>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 7 months
[JBoss JIRA] (TEIID-1774) Ingres as source - ORDER BY on TimeValue not properly ordering results as expected
by Van Halbert (Moved) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1774?page=com.atlassian.jira.plugin... ]
Van Halbert moved SOA-3456 to TEIID-1774:
-----------------------------------------
Project: Teiid (was: JBoss Enterprise SOA Platform)
Key: TEIID-1774 (was: SOA-3456)
Affects Version/s: 7.4.1
(was: 5.2.0.ER4)
Component/s: Misc. Connectors
(was: EDS)
Security: (was: Public)
> Ingres as source - ORDER BY on TimeValue not properly ordering results as expected
> ----------------------------------------------------------------------------------
>
> Key: TEIID-1774
> URL: https://issues.jboss.org/browse/TEIID-1774
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 7.4.1
> Reporter: Warren Gibson
> Assignee: Van Halbert
>
> EDS Query Testing is getting unexpected results on 68 queries involving ORDER BY on TimeValue. When an ORDER BY is placed on TimeValue the returned results are not ordered as expected.
> An example query is: SELECT BQT1.SmallA.TimeValue FROM BQT1.SmallA ORDER BY TimeValue
> The returned results are:
> TimeValue
> 05:00:00
> 05:00:00
> 06:00:00
> 06:00:00
> 07:00:00
> 08:00:00
> 08:00:00
> 09:00:00
> 09:00:00
> 10:00:00
> 10:00:00
> 11:00:00
> 11:00:00
> 12:00:00
> 12:00:00
> 13:00:00
> 13:00:00
> 14:00:00
> 14:00:00
> 15:00:00
> 16:00:00
> 16:00:00
> 17:00:00
> 17:00:00
> 18:00:00
> 18:00:00
> 19:00:00
> 19:00:00
> 20:00:00
> 20:00:00
> 21:00:00
> 21:00:00
> 22:00:00
> 22:00:00
> 23:00:00
> 00:00:00
> 00:00:00
> 00:00:00
> 01:00:00
> 01:00:00
> 01:00:00
> 02:00:00
> 02:00:00
> 03:00:00
> 03:00:00
> 04:00:00
> 04:00:00
> <null>
> <null>
> <null>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 7 months
[JBoss JIRA] (TEIID-1773) Ingres as source - Query with LOCATE causing stackoverflow error
by Steven Hawkins (Resolved) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1773?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-1773.
-----------------------------------
Fix Version/s: 7.4.1
7.6
Resolution: Done
The locate modifier was returning a new locate function which the logic attempts to translate again, thus the stack overflow.
Our translation logic allows for passing back expressions that will be further modified, which means that when a non-null list is returned by a modifier we attempt to translate those results. We also maintain a identity map to guard against situations where the original object is passed back by the translator.
> Ingres as source - Query with LOCATE causing stackoverflow error
> ----------------------------------------------------------------
>
> Key: TEIID-1773
> URL: https://issues.jboss.org/browse/TEIID-1773
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 7.4.1
> Reporter: Warren Gibson
> Assignee: Steven Hawkins
> Fix For: 7.4.1, 7.6
>
>
> EDS Query Testing is getting unexpected results on 16 queries involving LOCATE. A couple examples queries are given below:
> SELECT INTKEY, LOCATE(1, STRINGNUM) FROM BQT1.SmallA ORDER BY intkey (Expected 50 records but received only 0)
> Remote org.teiid.core.TeiidProcessingException: Source: null
> see stackoverflow.log attached
> SELECT INTKEY FROM BQT1.SmallA WHERE LOCATE(1, INTKEY) = 1 ORDER BY INTKEY
> Remote org.teiid.core.TeiidProcessingException: Source: null
> Is also a stackoverflow error.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 7 months