June 2010 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-756) Oracle Connector is not producing the correct queries when using a LIMIT clause

by Larry O'Leary (JIRA)

Oracle Connector is not producing the correct queries when using a LIMIT clause ------------------------------------------------------------------------------- Key: TEIID-756 URL: https://jira.jboss.org/jira/browse/TEIID-756 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 6.1.0, 6.0.0, 6.2.0 Reporter: Larry O'Leary Assignee: Steven Hawkins When using a LIMIT clause in a query, the Oracle Connector rewrites it to something that Oracle will understand. The problem is that the rewritten version of the query is not returning the expected results. For example: SELECT INTKEY FROM BQT1.MEDIUMA LIMIT 50, 100 Should return 50 rows starting at row 100 but instead returns 0 rows when executed via the Oracle Connector. Currently the above query is rewritten as: SELECT * FROM (SELECT VIEW_FOR_LIMIT.*, ROWNUM ROWNUM_ FROM (SELECT MediumA.IntKey FROM MediumA) VIEW_FOR_LIMIT WHERE ROWNUM <= 150) WHERE ROWNUM_ > 50 Further more, the rewritten version of the query is also projecting a column named ROWNUM_ which would be invalid based on our query processing. -- 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

14 years, 7 months

3
4
0 / 0

[JBoss JIRA] Commented: (TEIID-315) Add JDBC Connector developers guide

by Ramesh Reddy (JIRA)

[ https://jira.jboss.org/browse/TEIID-315?page=com.atlassian.jira.plugin.sy... ] Ramesh Reddy commented on TEIID-315: ------------------------------------ There will be no separate document, this is already folded into "Connector Developer's Guide". I will revise the this guide as part of this exercise. > Add JDBC Connector developers guide > ----------------------------------- > > Key: TEIID-315 > URL: https://jira.jboss.org/browse/TEIID-315 > Project: Teiid > Issue Type: Sub-task > Components: Documentation > Affects Versions: 6.0.0 > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Fix For: 7.0 > > -- 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

14 years, 7 months

1
0
0 / 0

[JBoss JIRA] Resolved: (TEIID-73) Directory validation in XML File connector too optimistic

by Steve Hawkins (JIRA)

[ https://jira.jboss.org/browse/TEIID-73?page=com.atlassian.jira.plugin.sys... ] Steve Hawkins resolved TEIID-73. -------------------------------- Resolution: Out of Date Files are provided through the file resource adapter. > Directory validation in XML File connector too optimistic > --------------------------------------------------------- > > Key: TEIID-73 > URL: https://jira.jboss.org/browse/TEIID-73 > Project: Teiid > Issue Type: Bug > Components: XML Connector > Affects Versions: 8.x > Reporter: Steven Hawkins > Priority: Optional > Fix For: 8.x > > > Defect Tracker #18724: When a directory is specified rather than a specific XML file, the directory validation logic has two problems: > 1. it neglects to filter out subdirectories, and > 2. if at least one file validates, it assumes all are good. -- 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

14 years, 7 months

1
0
0 / 0

[JBoss JIRA] Updated: (TEIID-962) Create new system function to dump temp table contents to file.

by Steve Hawkins (JIRA)

[ https://jira.jboss.org/browse/TEIID-962?page=com.atlassian.jira.plugin.sy... ] Steve Hawkins updated TEIID-962: -------------------------------- Fix Version/s: 7.1 Affects Version/s: 6.0.0 The file resource adapter will also have the ability to save. The save will be relative to the configured parent directory. I would also add a textagg aggregate function to handle the creation of a csv clob: textagg(expression [as name], ... [DELIMITER char] [QUOTE char] [HEADER] [order by ...]) when header is specified, then all expression must be column references or have names. usage example: <file model>.saveFile('newFile.csv', (select textagg(col1, col2, col3 HEADER) from t)) > Create new system function to dump temp table contents to file. > ----------------------------------------------------------------- > > Key: TEIID-962 > URL: https://jira.jboss.org/browse/TEIID-962 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 6.0.0 > Environment: All > Reporter: Ken Johnson > Assignee: Steve Hawkins > Fix For: 7.1 > > > A requirement to produce a CSV file reflecting the contents of a query result set so it can be subsequently FTP'd or email'd. In Nov 07 implemented this feature using the exec connector, a shell script and mods to JDBCISQL. > Suggested capability: function will take the following parameters: > - Temp table name as string > - Target file name (path qualified) as string > - Delimiter as string > When invoked, the specified temp table contents will be written out to the specified file using the specified delimiter to separate the column values. > This generic capability will allow the CSV file thats needed and subsequently process it with other UDF functionality as necessary. > Open questions: > 1. How does file path behave in a clustered environment? Is it relative to the MM Server install dir or fully qualified? > Suggest this feature remain undocumented for the short term. -- 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

14 years, 7 months

1
0
0 / 0

[JBoss JIRA] Assigned: (TEIID-962) Create new system function to dump temp table contents to file.

by Steve Hawkins (JIRA)

[ https://jira.jboss.org/browse/TEIID-962?page=com.atlassian.jira.plugin.sy... ] Steve Hawkins reassigned TEIID-962: ----------------------------------- Assignee: Steve Hawkins > Create new system function to dump temp table contents to file. > ----------------------------------------------------------------- > > Key: TEIID-962 > URL: https://jira.jboss.org/browse/TEIID-962 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Environment: All > Reporter: Ken Johnson > Assignee: Steve Hawkins > > A requirement to produce a CSV file reflecting the contents of a query result set so it can be subsequently FTP'd or email'd. In Nov 07 implemented this feature using the exec connector, a shell script and mods to JDBCISQL. > Suggested capability: function will take the following parameters: > - Temp table name as string > - Target file name (path qualified) as string > - Delimiter as string > When invoked, the specified temp table contents will be written out to the specified file using the specified delimiter to separate the column values. > This generic capability will allow the CSV file thats needed and subsequently process it with other UDF functionality as necessary. > Open questions: > 1. How does file path behave in a clustered environment? Is it relative to the MM Server install dir or fully qualified? > Suggest this feature remain undocumented for the short term. -- 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

14 years, 7 months

1
0
0 / 0

[JBoss JIRA] Resolved: (TEIID-974) XML-Relational connectors have trouble with reponse XMLs that contain DTD reference

by Ramesh Reddy (JIRA)

[ https://jira.jboss.org/browse/TEIID-974?page=com.atlassian.jira.plugin.sy... ] Ramesh Reddy resolved TEIID-974. -------------------------------- Resolution: Won't Fix The challenge here is by time the XML is parsed and loaded, the processing is happening at the "engine" level, where all the references to original URL location are not there to get it from the correct place. If we decide to do this at the connector level, then Teiid need to load the document, i.e memory hog. Since this is relatively low frequency use case with file and http connectors, the workaround is fine. We just need to document as KI. Reopen if you feel otherwise. > XML-Relational connectors have trouble with reponse XMLs that contain DTD reference > ----------------------------------------------------------------------------------- > > Key: TEIID-974 > URL: https://jira.jboss.org/browse/TEIID-974 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 6.2.0, 7.1 > Reporter: John Doyle > Assignee: Ramesh Reddy > Fix For: 7.0 > > > Whenever we tried to query the document with the XML-Relational HTTP Connector, the following error occured: > java.io.FileNotFoundException: <designer_home>/<docname>_XML.dtd (No such file or directory). > What it looks like is happening is that this XML document contains a relative reference to a DTD, but instead we look for it in the working directory. -- 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

14 years, 7 months

1
0
0 / 0

[JBoss JIRA] Commented: (TEIID-171) Add SQL/XML support

by Steve Hawkins (JIRA)

[ https://jira.jboss.org/browse/TEIID-171?page=com.atlassian.jira.plugin.sy... ] Steve Hawkins commented on TEIID-171: ------------------------------------- also added xmlserialize, xmltable, and xmlquery for 7.0. We also support entering xml literals through the standard escape syntax: {x '</a>'} - which is short hand for convert('</a>', xml) or xmlparse... > Add SQL/XML support > ------------------- > > Key: TEIID-171 > URL: https://jira.jboss.org/browse/TEIID-171 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 6.0.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 7.0 > > > We should add basic SQL./XML support to both create documents and extract rows from documents -- 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

14 years, 7 months

1
0
0 / 0

[JBoss JIRA] Updated: (TEIID-987) Problem regarding how often availability is called on the Facet

by Ted Jones (JIRA)

[ https://jira.jboss.org/browse/TEIID-987?page=com.atlassian.jira.plugin.sy... ] Ted Jones updated TEIID-987: ---------------------------- Fix Version/s: 7.1 (was: 7.0) > Problem regarding how often availability is called on the Facet > --------------------------------------------------------------- > > Key: TEIID-987 > URL: https://jira.jboss.org/browse/TEIID-987 > Project: Teiid > Issue Type: Bug > Components: Jopr Plugin > Affects Versions: 7.0 > Reporter: Van Halbert > Assignee: Ted Jones > Fix For: 7.1 > > > There's a problem where the Facet (resource) availability is being checked about 5 times consecutively for every resource. There is an embedded jopr issue regarding this issue (EMBJOPR-129) > However, until this can be fixed, we might have to add a system property to handle how often to allow availability to be checked to limit the calls. Otherwise, this could a large processing overhead. -- 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

14 years, 7 months

1
0
0 / 0

[JBoss JIRA] Updated: (TEIID-983) Getting Started With Designer kit needs updating to fix schema differences between SQL Server and MySQL

by Ramesh Reddy (JIRA)

[ https://jira.jboss.org/browse/TEIID-983?page=com.atlassian.jira.plugin.sy... ] Ramesh Reddy updated TEIID-983: ------------------------------- Fix Version/s: 7.1 > Getting Started With Designer kit needs updating to fix schema differences between SQL Server and MySQL > ------------------------------------------------------------------------------------------------------- > > Key: TEIID-983 > URL: https://jira.jboss.org/browse/TEIID-983 > Project: Teiid > Issue Type: Task > Components: Documentation > Affects Versions: 7.1 > Reporter: Larry O'Leary > Assignee: Van Halbert > Fix For: 7.1 > > > The Intro to Designer training was originally written to use the MMFinancials schema for SQL Server. It appears that some data types are not imported the same way when the MySQL schema is used. This results in data type differences between the written instructions and the MySQL schema that is most commonly used in the Getting Started kit. > For example, the ProductShares column in the AccountHoldings table is being imported as a biginteger when using SQL Server but as a bigdecimal when using MySQL. This difference then results in reconciler/transformation errors due to type incompatibility which require explicit conversions. -- 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

14 years, 7 months

1
0
0 / 0

[JBoss JIRA] Updated: (TEIID-886) Request for more statistical functions in Teiid

by Ramesh Reddy (JIRA)

[ https://jira.jboss.org/browse/TEIID-886?page=com.atlassian.jira.plugin.sy... ] Ramesh Reddy updated TEIID-886: ------------------------------- Fix Version/s: 7.1 > Request for more statistical functions in Teiid > ----------------------------------------------- > > Key: TEIID-886 > URL: https://jira.jboss.org/browse/TEIID-886 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 6.2.0 > Reporter: Debbie Steigner > Fix For: 7.1 > > > Please provide a richer set of aggregate functions, specifically statistical functions like population standard deviation, sample standard deviation, population standard variance, etc. -- 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

14 years, 7 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2010