August 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4245) Add support for fetch syntax "FETCH cursorname"

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4245?page=com.atlassian.jira.plugin... ] Johnathon Lee closed TEIID-4245. -------------------------------- Resolution: Done > 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, 8.12.6.6_3 > > > 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)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4323) Add support for first/last/absolute/relative "FETCH " syntax

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4323?page=com.atlassian.jira.plugin... ] Johnathon Lee reopened TEIID-4323: ---------------------------------- > 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)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4289) Add transaction command support for syntax BEGIN/ROLLBACK/COMMIT WORK

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4289?page=com.atlassian.jira.plugin... ] Johnathon Lee closed TEIID-4289. -------------------------------- Resolution: Done > Add transaction command support for syntax BEGIN/ROLLBACK/COMMIT WORK > --------------------------------------------------------------------- > > Key: TEIID-4289 > URL: https://issues.jboss.org/browse/TEIID-4289 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.7.6.6_2 > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.8.6_2, 8.12.6.6_3 > > > This request appears to be an expansion of TEIID-1701 to add syntax like the below as an alias for transactional commands. This would be in line to make commands portable from other vendor DBs such as PostgreSQL/SQL Server/DB2/MySQL. > BEGIN WORK > ROLLBACK WORK > COMMIT WORK -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4289) Add transaction command support for syntax BEGIN/ROLLBACK/COMMIT WORK

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4289?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4289: --------------------------------- Fix Version/s: 8.12.6.6_3 > Add transaction command support for syntax BEGIN/ROLLBACK/COMMIT WORK > --------------------------------------------------------------------- > > Key: TEIID-4289 > URL: https://issues.jboss.org/browse/TEIID-4289 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.7.6.6_2 > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.8.6_2, 8.12.6.6_3 > > > This request appears to be an expansion of TEIID-1701 to add syntax like the below as an alias for transactional commands. This would be in line to make commands portable from other vendor DBs such as PostgreSQL/SQL Server/DB2/MySQL. > BEGIN WORK > ROLLBACK WORK > COMMIT WORK -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4245) Add support for fetch syntax "FETCH cursorname"

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4245?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4245: --------------------------------- Fix Version/s: 8.12.6.6_3 > 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, 8.12.6.6_3 > > > 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)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4398) Write a utility to convert a .VDB with Index file into -vdb.xml or DDL format

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-4398: ----------------------------------- Summary: Write a utility to convert a .VDB with Index file into -vdb.xml or DDL format Key: TEIID-4398 URL: https://issues.jboss.org/browse/TEIID-4398 Project: Teiid Issue Type: Task Components: Build/Kits Reporter: Ramesh Reddy Assignee: Ramesh Reddy Write a command line utility and provide in "bin" directory to convert the Designer based .vdb file with index metadata into -vdb.xml file and/or newer DDL format. This can be used to migrate the older VDBs mach easier to newer formats without use of Designer tooling. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4245) Add support for fetch syntax "FETCH cursorname"

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4245?page=com.atlassian.jira.plugin... ] Johnathon Lee reopened TEIID-4245: ---------------------------------- > 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)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4238) Remove need for quotes around cursor name declarations/fetches

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4238?page=com.atlassian.jira.plugin... ] Johnathon Lee closed TEIID-4238. -------------------------------- Resolution: Done > Remove need for quotes around cursor name declarations/fetches > -------------------------------------------------------------- > > Key: TEIID-4238 > URL: https://issues.jboss.org/browse/TEIID-4238 > Project: Teiid > Issue Type: Enhancement > Components: ODBC > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.8.6_2, 8.12.6.6_3 > > > Attempting to declare a cursor without quotes results in an error similar to[1]. The quotes should be optional except in special cases, as this seems to match later standards (SQL2003). Performing fetch operations against the cursor have the same issue, where if the cursorname is not quoted, parsing errors occur. > [1] Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]DECLARE[*] cursorname CURSOR" 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)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4238) Remove need for quotes around cursor name declarations/fetches

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4238?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4238: --------------------------------- Fix Version/s: 8.12.6.6_3 > Remove need for quotes around cursor name declarations/fetches > -------------------------------------------------------------- > > Key: TEIID-4238 > URL: https://issues.jboss.org/browse/TEIID-4238 > Project: Teiid > Issue Type: Enhancement > Components: ODBC > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.8.6_2, 8.12.6.6_3 > > > Attempting to declare a cursor without quotes results in an error similar to[1]. The quotes should be optional except in special cases, as this seems to match later standards (SQL2003). Performing fetch operations against the cursor have the same issue, where if the cursorname is not quoted, parsing errors occur. > [1] Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]DECLARE[*] cursorname CURSOR" 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)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4238) Remove need for quotes around cursor name declarations/fetches

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4238?page=com.atlassian.jira.plugin... ] Johnathon Lee reopened TEIID-4238: ---------------------------------- > Remove need for quotes around cursor name declarations/fetches > -------------------------------------------------------------- > > Key: TEIID-4238 > URL: https://issues.jboss.org/browse/TEIID-4238 > Project: Teiid > Issue Type: Enhancement > Components: ODBC > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.8.6_2 > > > Attempting to declare a cursor without quotes results in an error similar to[1]. The quotes should be optional except in special cases, as this seems to match later standards (SQL2003). Performing fetch operations against the cursor have the same issue, where if the cursorname is not quoted, parsing errors occur. > [1] Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]DECLARE[*] cursorname CURSOR" 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)

9 years, 7 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues August 2016