September 2009 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-788) Change internal handling of insert with query expression

by Steven Hawkins (JIRA)

Change internal handling of insert with query expression -------------------------------------------------------- Key: TEIID-788 URL: https://jira.jboss.org/jira/browse/TEIID-788 Project: Teiid Issue Type: Sub-task Components: Query Engine Affects Versions: 6.2.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.3.0 An insert with a query expression should be our dominant internal model. Select into should be rewritten as it instead of the other way around. -- 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

15 years, 4 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-853) Dynamic command projection should be positional

by Steven Hawkins (JIRA)

Dynamic command projection should be positional ----------------------------------------------- Key: TEIID-853 URL: https://jira.jboss.org/jira/browse/TEIID-853 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.3 Dynamic commands using the as clause should match with the dynamic command based upon position, rather than name. For example exec string 'select x, y ...' as a string, b string; should work since the right number of symbols are projected. -- 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

15 years, 4 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-728) Pushing blank-padded literals to source may fail to return correct results

by Paul Nittel (JIRA)

Pushing blank-padded literals to source may fail to return correct results -------------------------------------------------------------------------- Key: TEIID-728 URL: https://jira.jboss.org/jira/browse/TEIID-728 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.2.0 Environment: fedora 10, JDK 1.6, Teiid from 7/16/2009 Reporter: Paul Nittel Assignee: Steven Hawkins While reviewing possible CTC errors, it was noticed that SPACE(n) was not returning the number of spaces specified. We did see that going directly to Oracle worked correctly. Steve H. believes Oracle is returning a CHAR type and Teiid is trimming the values as a result. (It would not have if the return type was VARCHAR, like SQL Server returns.) -- 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

15 years, 4 months

3
5
0 / 0

[JBoss JIRA] Created: (TEIID-850) Misspellings in Teiid Reference Guide

by Paul Nittel (JIRA)

Misspellings in Teiid Reference Guide ------------------------------------- Key: TEIID-850 URL: https://jira.jboss.org/jira/browse/TEIID-850 Project: Teiid Issue Type: Bug Environment: Ref Guide PDF, dated 6/11/2009 Reporter: Paul Nittel Assignee: Steven Hawkins Section 5.2.3's title reads, "Examle Virtual Procedures" Table 6.2 contains the word "PESSIMITIC" There are possibly more; I just happened to spot these. I'm sure Docbook XML editors have excellent spelling checkers ;-) -- 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

15 years, 4 months

3
4
0 / 0

[JBoss JIRA] Created: (TEIID-849) subquery as input to procedure fails

by Steven Hawkins (JIRA)

subquery as input to procedure fails ------------------------------------ Key: TEIID-849 URL: https://jira.jboss.org/jira/browse/TEIID-849 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.3.0 A subquery as an input to a procedure (exec) will fail because it is never resolved. Also within the scope of a procedure something like: select e1 into #t1 from pm1.g1; select e2 from (exec pm1.sq2((select max(e1) from #t1))) x; will fail since the temp table store is not known inside the procedure plan that is evaluating the input parameters. -- 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

15 years, 4 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-822) Add hsql translator

by Steven Hawkins (JIRA)

Add hsql translator ------------------- Key: TEIID-822 URL: https://jira.jboss.org/jira/browse/TEIID-822 Project: Teiid Issue Type: Feature Request Components: JDBC Connector Affects Versions: 6.3.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.3.0 We should add default translators for hsql (and probably h2 as well). -- 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

15 years, 4 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-563) Exporting the configuration, via console or utility, the configuration system properties now contains everything in the system, not just defined by the Configuration component type

by Van Halbert (JIRA)

Exporting the configuration, via console or utility, the configuration system properties now contains everything in the system, not just defined by the Configuration component type ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Key: TEIID-563 URL: https://jira.jboss.org/jira/browse/TEIID-563 Project: Teiid Issue Type: Bug Components: Common Affects Versions: 6.1.0 Reporter: Van Halbert Assignee: Steven Hawkins When exporting the configuration, using either the console or the configexport utility, the configuration properties segment now contains all the properties that exist when calling System.getProperties(), instead only what is defined by the Configuration component type. -- 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

15 years, 4 months

4
5
0 / 0

[JBoss JIRA] Created: (TEIID-845) AdminShell needs to be able to produce and display a Query Plan

by Paul Nittel (JIRA)

AdminShell needs to be able to produce and display a Query Plan --------------------------------------------------------------- Key: TEIID-845 URL: https://jira.jboss.org/jira/browse/TEIID-845 Project: Teiid Issue Type: Feature Request Components: Tools Affects Versions: 6.2.0 Reporter: Paul Nittel Assignee: Steven Hawkins AdminShell needs to be able to produce and display query plans for the user. Since QueryBuilder is no more, the Designer is the only mechanism we have to produce query plans. That may not always be possible or convenient for the user, so I'd like to see this ability added to the adminAPI / AdminShell. -- 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

15 years, 4 months

3
3
0 / 0

[JBoss JIRA] Created: (TEIID-830) AdminShell row count is not accurate

by Steven Hawkins (JIRA)

AdminShell row count is not accurate ------------------------------------ Key: TEIID-830 URL: https://jira.jboss.org/jira/browse/TEIID-830 Project: Teiid Issue Type: Bug Components: Tools Affects Versions: 6.0.0 Reporter: Steven Hawkins Priority: Optional Fix For: 6.3.0 AdminShell reports rows produced as the number of lines, so it is off for xml or any string containing new lines. -- 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

15 years, 4 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-811) Float/Double to BigInteger conversion bug

by Steven Hawkins (JIRA)

Float/Double to BigInteger conversion bug ----------------------------------------- Key: TEIID-811 URL: https://jira.jboss.org/jira/browse/TEIID-811 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.2.0 Float/Double values with toString forms in engineering notation will fail to convert correctly because of the truncation logic. -- 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

15 years, 4 months

2
2
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues September 2009