[JBoss JIRA] (TEIID-4323) Add support for first/last/absolute/relative "FETCH " syntax
by Debbie Steigner (JIRA)
Debbie Steigner created TEIID-4323:
--------------------------------------
Summary: Add support for first/last/absolute/relative "FETCH " syntax
Key: TEIID-4323
URL: https://issues.jboss.org/browse/TEIID-4323
Project: Teiid
Issue Type: Feature Request
Components: ODBC
Reporter: Debbie Steigner
Assignee: Steven Hawkins
Fix For: 9.1, 8.7.8.6_2
Add Support for the below FETCH syntax:
FETCH LAST FROM cursor_name
FETCH ABSOLUTE fetch_when FROM cursor_name
FETCH RELATIVE fetch_when FROM cursor_name
FETCH FIRST FROM cursor_name
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 5 months
[JBoss JIRA] (TEIID-4245) Add support for fetch syntax "FETCH cursorname"
by Debbie Steigner (JIRA)
[ https://issues.jboss.org/browse/TEIID-4245?page=com.atlassian.jira.plugin... ]
Debbie Steigner commented on TEIID-4245:
----------------------------------------
Steve - Can I make that 1 JIRA or do you want 1 for each first, last, absolute and relative?
> Add support for fetch syntax "FETCH cursorname"
> -----------------------------------------------
>
> Key: TEIID-4245
> URL: https://issues.jboss.org/browse/TEIID-4245
> Project: Teiid
> Issue Type: Feature Request
> Components: ODBC
> Reporter: Marc Shirley
> Assignee: Steven Hawkins
> Fix For: 9.1, 8.7.8.6_2
>
>
> Executing syntax "FETCH cursorname" results in parsing error like [1]. Instead, syntax like "FETCH 1 IN cursorname" has been used as a workaround.
> [1]
> org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]FETCH[*] mycursor" at line 1, column 1.
> Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ...
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 5 months
[JBoss JIRA] (TEIID-4255) Transformation exception when parsing time in SAP NW Gateway
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-4255?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-4255:
------------------------------------------------
Lucie Fabrikova <lfabriko(a)redhat.com> changed the Status of [bug 1343827|https://bugzilla.redhat.com/show_bug.cgi?id=1343827] from ON_QA to VERIFIED
> Transformation exception when parsing time in SAP NW Gateway
> ------------------------------------------------------------
>
> Key: TEIID-4255
> URL: https://issues.jboss.org/browse/TEIID-4255
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.x
> Reporter: Andrej Šmigala
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 9.0, 8.12.5
>
>
> When querying the SAP Sample Flight demo web service using the sap-nw-gateway, the following error is logged when the response contains time value in the form "PT11H00M00S"
> {noformat}
> org.teiid.jdbc.TeiidSQLException: TEIID10068 Failed to transform String to Time. Expected format = hh:mm:ss for PT11H00M00S at org.jboss.qe.dvqe.reproducers.Teiid3841Test.runTest(Teiid3841Test.java:61) Caused by: org.teiid.core.types.TransformationException: TEIID10068 Failed to transform String to Time. Expected format = hh:mm:ss for PT11H00M00S
> {noformat}
> This is likely a regression as that query works in DV 6.2 with latest patch.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 5 months
[JBoss JIRA] (TEIID-4245) Add support for fetch syntax "FETCH cursorname"
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4245?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4245:
---------------------------------------
Another JIRA would be needed to cover first/last/absolute/relative.
> Add support for fetch syntax "FETCH cursorname"
> -----------------------------------------------
>
> Key: TEIID-4245
> URL: https://issues.jboss.org/browse/TEIID-4245
> Project: Teiid
> Issue Type: Feature Request
> Components: ODBC
> Reporter: Marc Shirley
> Assignee: Steven Hawkins
> Fix For: 9.1, 8.7.8.6_2
>
>
> Executing syntax "FETCH cursorname" results in parsing error like [1]. Instead, syntax like "FETCH 1 IN cursorname" has been used as a workaround.
> [1]
> org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]FETCH[*] mycursor" at line 1, column 1.
> Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ...
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 5 months
[JBoss JIRA] (TEIID-4245) Add support for fetch syntax "FETCH cursorname"
by Debbie Steigner (JIRA)
[ https://issues.jboss.org/browse/TEIID-4245?page=com.atlassian.jira.plugin... ]
Debbie Steigner commented on TEIID-4245:
----------------------------------------
Customer requested all of the below syntax be supported, can these be added as well?
FETCH LAST FROM cursor_name
FETCH ABSOLUTE fetch_when FROM cursor_name
FETCH RELATIVE fetch_when FROM cursor_name
FETCH cursor_name
FETCH FIRST FROM cursor_name
> Add support for fetch syntax "FETCH cursorname"
> -----------------------------------------------
>
> Key: TEIID-4245
> URL: https://issues.jboss.org/browse/TEIID-4245
> Project: Teiid
> Issue Type: Feature Request
> Components: ODBC
> Reporter: Marc Shirley
> Assignee: Steven Hawkins
> Fix For: 9.1, 8.7.8.6_2
>
>
> Executing syntax "FETCH cursorname" results in parsing error like [1]. Instead, syntax like "FETCH 1 IN cursorname" has been used as a workaround.
> [1]
> org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]FETCH[*] mycursor" at line 1, column 1.
> Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ...
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 5 months