October 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3547) Oracle and postgres translators - date/time format letters are not translated correctly if pattern ends with non-pattern/non-letter character

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3547?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3547. --------------------------------- > Oracle and postgres translators - date/time format letters are not translated correctly if pattern ends with non-pattern/non-letter character > --------------------------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-3547 > URL: https://issues.jboss.org/browse/TEIID-3547 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > Oracle translator seems to support translation of patterns from SimpleDateFormat to oracle's patterns [1], but not for all of them [2]. If Teiid is not able to translate format then it retrieves date/time/timestamp field and format it [2]. However, if pattern ends with non-pattern/non-letter character, pattern is translated only partially and passed to Oracle DB [3] - I have tried number, *, /, \, etc. Similar behavior with postgresql translator > [1] > *Query:* select formattimestamp(timestampvalue, 'y') from bqt1.smalla where intkey=1; > *Source-specific command:* SELECT TO_CHAR(g_0."TIMESTAMPVALUE", 'YYYY') FROM "DV"."SMALLA" g_0 WHERE trunc(g_0."INTKEY") = 1 > [2] > *Query:* select formattimestamp(timestampvalue, 'D') from bqt1.smalla where intkey=1; > *Source-specific command:* SELECT g_0."TIMESTAMPVALUE" FROM "DV"."SMALLA" g_0 WHERE trunc(g_0."INTKEY") = 1 > [3] > *Query:* select formattimestamp(timestampvalue, 'G-y-M-w-W-D-d-F-E-a-H-k-K-h-m-s') from bqt1.smalla where intkey=1; > *Source-specific command:* SELECT g_0."TIMESTAMPVALUE" FROM "DV"."SMALLA" g_0 WHERE trunc(g_0."INTKEY") = 1 > *Query:* select formattimestamp(timestampvalue, 'G-y-M-w-W-D-d-F-E-a-H-k-K-h-m-s-') from bqt1.smalla where intkey=1; > *Source-specific command:* SELECT TO_CHAR(g_0."TIMESTAMPVALUE", 'AD-YYYY-------Dy-AM-------') FROM "DV"."SMALLA" g_0 WHERE trunc(g_0."INTKEY") = 1 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3358) Issues with entity set names

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3358?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3358. --------------------------------- > Issues with entity set names > ---------------------------- > > Key: TEIID-3358 > URL: https://issues.jboss.org/browse/TEIID-3358 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Labels: Alpha1 > Fix For: 8.7.1.6_2, 8.11, 8.7.3 > > > The entity set name used for sql generation should be the fully qualified name. If there is for example two table with the same names in schemas visible to odata, but one of the tables does not have a key, then an ambiguous name exception will be thrown if an odata url is used with only the base table name. > It also appears that the URI link in the results metadata uses the non-qualified table name, which will have issues in the scenario above. > We may also need to document or add an additional check for ambiguity as the OData4j findEdmEntitySet logic will return the first matching entity, which is generally against our approach to resolving. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3524) Database Logging not working

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3524?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3524. --------------------------------- > Database Logging not working > ---------------------------- > > Key: TEIID-3524 > URL: https://issues.jboss.org/browse/TEIID-3524 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Reporter: Jan Stastny > Assignee: Van Halbert > Fix For: 8.7.1.6_2, 8.11 > > > When using db logging in Teiid, nothing gets inserted into the db. Logs appear at server.log, but not in the db. > I set up the logging as follows: > Created java:/teiid-log-ds datasource. > Added these to logging subsystem: > {code:xml} > <async-handler name="TEIID_COMMAND_LOG"> > <level name="DEBUG"/> > <queue-length value="50"/> > <overflow-action value="block"/> > <subhandlers> > <handler name="TEIID_JPA_LOG"/> > </subhandlers> > </async-handler> > <async-handler name="TEIID_AUDIT_LOG"> > <level name="DEBUG"/> > <queue-length value="50"/> > <overflow-action value="block"/> > <subhandlers> > <handler name="TEIID_JPA_LOG"/> > </subhandlers> > </async-handler> > <custom-handler name="TEIID_JPA_LOG" class="org.teiid.logger.DatabaseAppender" module="org.jboss.teiid.extensions"> > <level name="DEBUG"/> > </custom-handler> > <logger category="org.teiid.COMMAND_LOG"> > <level name="DEBUG"/> > <handlers> > <handler name="TEIID_COMMAND_LOG"/> > </handlers> > </logger> > <logger category="org.teiid.AUDIT_LOG"> > <level name="DEBUG"/> > <handlers> > <handler name="TEIID_AUDIT_LOG"/> > </handlers> > </logger> > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3579) Hive 0.13.1 JDBC jars makes queries run slow in DV runtime

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3579?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3579. --------------------------------- > Hive 0.13.1 JDBC jars makes queries run slow in DV runtime > ---------------------------------------------------------- > > Key: TEIID-3579 > URL: https://issues.jboss.org/browse/TEIID-3579 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver > Environment: Mac OS X Yosemite 10.10.4, JBoss Developer Studio 8.1.0 GA, JBoss Data Virtualization 6.1.0 > Reporter: Vijay Bhaskar Chintalapati > Assignee: Steven Hawkins > > When using the JDBC jars for Hive 0.13.1 running on HDP 2.1, queries executed against table 'default.sample_07' takes approximately 20-30 seconds to return. > The Hive JDBC jars for version 0.13.1 can be found here : > https://github.com/vchintal/hive-jdbc-jars-archive > Alternatively a ready-to-go modules can be downloaded from here for testing: > https://drive.google.com/file/d/0BxJhoZ1V34QHSmgzTlBRVktZaGM/ > Use the following driver snippet when using the above mentioned module: > <driver name="hive" module="org.apache.hadoop.hive:0.13.1"> > <driver-class>org.apache.hive.jdbc.HiveDriver</driver-class> > </driver> -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3570) Infinispan-dsl-cache translator: Incorrect ordering of NULL values

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3570?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3570. --------------------------------- > Infinispan-dsl-cache translator: Incorrect ordering of NULL values > ------------------------------------------------------------------ > > Key: TEIID-3570 > URL: https://issues.jboss.org/browse/TEIID-3570 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Filip Elias > Assignee: Van Halbert > Attachments: serverLog.txt > > > NULL values are sorted oddly when using order by clause. > Numeric NULL values seems to be considered as zero. > Date/TimeStamp/Time NULL values are at the beginning, but String NULL values are at the end when sorted. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3407) Clarify in the README's for each quickstart regarding how to start the server

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3407?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3407. --------------------------------- > Clarify in the README's for each quickstart regarding how to start the server > ----------------------------------------------------------------------------- > > Key: TEIID-3407 > URL: https://issues.jboss.org/browse/TEIID-3407 > Project: Teiid > Issue Type: Enhancement > Components: Quick Starts > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Trivial > > Change the start command in the README's to be the following: > To start the server, open a command line and navigate to the "bin" directory under the root directory of the JBoss server and run: > > For Linux: ./standalone.sh > for Windows: standalone.bat > append the following to the command to indicate which configuration to use if Teiid isn't configured in the default configuration > > -c standalone-teiid.xml -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3584) NoSuchMethodError when issuing show plan request -IBM JDK 1.6

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3584?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3584. --------------------------------- > NoSuchMethodError when issuing show plan request -IBM JDK 1.6 > ------------------------------------------------------------- > > Key: TEIID-3584 > URL: https://issues.jboss.org/browse/TEIID-3584 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver > Affects Versions: 8.7.1 > Environment: IBM JDK 1.6 > Reporter: Filip Elias > Assignee: Steven Hawkins > > Teiid client throws an error[1] when processing "show plan;" request. This issue exist only on IBM jdk 1.6. The error is thrown at client side. > [1] > {code} > Exception in thread "main" java.lang.NoSuchMethodError: javax/xml/stream/XMLOutputFactory.newFactory()Ljavax/xml/stream/XMLOutputFactory; > at org.teiid.client.plan.PlanNode.toXml(PlanNode.java:175) > at org.teiid.jdbc.StatementImpl.executeShow(StatementImpl.java:556) > at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:502) > at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:393) > at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:327) > at JDBCClient.execute(JDBCClient.java:93) > at JDBCClient.main(JDBCClient.java:47) > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3419) Add ability to set a default role across all VDBs

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3419?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3419. --------------------------------- > Add ability to set a default role across all VDBs > ------------------------------------------------- > > Key: TEIID-3419 > URL: https://issues.jboss.org/browse/TEIID-3419 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 8.11 > > > There should be an ability to either set a default role across the server, or to restrict access by default. For example, all VDBs have a default user role that is applied before the VDB specific roles are. Alternatively, there could be a system wide flag that toggles the behavior of VDBs when no roles are defined between accessible to all or denied to all. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3566) insert value pushed inappropriately

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3566?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3566. --------------------------------- > insert value pushed inappropriately > ----------------------------------- > > Key: TEIID-3566 > URL: https://issues.jboss.org/browse/TEIID-3566 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12 > > > An insert with a subquery or other non-pushable construct: > Insert into pm1.g1 (e1) values ((select current_database())) > Will have the subquery pushed to the source query - even if the source does not support it. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3475) Add a separate example module for embedded examples

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3475?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3475. --------------------------------- > Add a separate example module for embedded examples > ---------------------------------------------------- > > Key: TEIID-3475 > URL: https://issues.jboss.org/browse/TEIID-3475 > Project: Teiid > Issue Type: Feature Request > Components: Embedded > Affects Versions: 8.11 > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 8.11 > > Attachments: drools-examples.png > > > Add a separate example module for embedded examples, it will contain a runnable jar, which will load all available examples, it will also contain transaction manager, etc. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2015