December 2011 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-1859) Add a capability to restrict comparisons

by Steven Hawkins (Created) (JIRA)

Add a capability to restrict comparisons ---------------------------------------- Key: TEIID-1859 URL: https://issues.jboss.org/browse/TEIID-1859 Project: Teiid Issue Type: Enhancement Components: Connector API, Query Engine Affects Versions: 8.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.0 Some sources such as Salesforce do not support non-join comparison between columns. e.g. table.col1 = table.col2 is not allowed, but table.col1 = 'val' is. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 7 months

3
2
0 / 0

[JBoss JIRA] Created: (TEIID-1268) Add support for using the case insensitive metadata

by Steven Hawkins (JIRA)

Add support for using the case insensitive metadata --------------------------------------------------- Key: TEIID-1268 URL: https://jira.jboss.org/browse/TEIID-1268 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 8.0 We currently capture whether the source is case sensitive and thus have a place holder on both physical and virtual models, but we do not use this information in performing comparisons in teiid. -- 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

12 years, 9 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-1680) issues with correlation and aggregation

by Steven Hawkins (JIRA)

issues with correlation and aggregation --------------------------------------- Key: TEIID-1680 URL: https://issues.jboss.org/browse/TEIID-1680 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins subqueries used in the having/select clause of a query with grouping only understand correlated element symbols - not correlated grouping expressions or correlated aggregate values. If a nested aggregate contains only outer references, then it should be treated as a correlated value. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 9 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1715) Simplify ODBC buffers

by Steven Hawkins (JIRA)

Simplify ODBC buffers --------------------- Key: TEIID-1715 URL: https://issues.jboss.org/browse/TEIID-1715 Project: Teiid Issue Type: Quality Risk Components: ODBC Affects Versions: 7.4.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4.1, 7.5 The results message is being built separately then copied into results buffer. These should use a single buffer. Also we are mistakenly using direct buffers. Beyond the possible memory implications in heavy usage scenarios, direct buffers cannot grow which means that any result over the ODBCPacketSize (such as a lob) will cause an exception. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1765) Incorrect comparison method in CancellationTimer

by Steven Hawkins (JIRA)

Incorrect comparison method in CancellationTimer ------------------------------------------------ Key: TEIID-1765 URL: https://issues.jboss.org/browse/TEIID-1765 Project: Teiid Issue Type: Bug Components: JDBC Driver Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4.1, 7.6 The comparison logic is invalid, which can lead to the queue retaining an entry and thus getting into a busy loop. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
3
0 / 0

[JBoss JIRA] Created: (TEIID-1731) Incorrect results with low memory streaming dup removal

by Steven Hawkins (JIRA)

Incorrect results with low memory streaming dup removal ------------------------------------------------------- Key: TEIID-1731 URL: https://issues.jboss.org/browse/TEIID-1731 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 7.4.1, 7.6 If the merge phase of sorting in a streaming dup removal (typical for top level union queries) cannot process all of the sublists in a single pass, then output may be wrong. This should be a somewhat rare combination of circumstances. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1682) Sort optimization with grouping does not preserve descending/null ordering

by Steven Hawkins (JIRA)

Sort optimization with grouping does not preserve descending/null ordering -------------------------------------------------------------------------- Key: TEIID-1682 URL: https://issues.jboss.org/browse/TEIID-1682 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4.1 If a sort operation is combined with grouping then any use of descending sort or a specific null ordering will be ignored. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
3
0 / 0

[JBoss JIRA] Created: (TEIID-1661) Not all expression types are validated for grouping columns

by Steven Hawkins (JIRA)

Not all expression types are validated for grouping columns ----------------------------------------------------------- Key: TEIID-1661 URL: https://issues.jboss.org/browse/TEIID-1661 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4.1 Grouping columns are allowed to contain expressions, but not all expression types are covered in the validator. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1718) Object type is not handled well in ODBC

by Steven Hawkins (JIRA)

Object type is not handled well in ODBC --------------------------------------- Key: TEIID-1718 URL: https://issues.jboss.org/browse/TEIID-1718 Project: Teiid Issue Type: Bug Components: ODBC Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4.1, 7.5 For anything other than a non resultset procedure parameter, the equivalent PG type should be unknown - rather than null (which initially caused an NPE in 7.5). For non resultset procedure parameters object should map to anyelement. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

1
2
0 / 0

[JBoss JIRA] (TEIID-1830) Perl client using DBD:Pg hangs with resultset > 512 rows

by Graeme Gillies (Created) (JIRA)

Perl client using DBD:Pg hangs with resultset > 512 rows -------------------------------------------------------- Key: TEIID-1830 URL: https://issues.jboss.org/browse/TEIID-1830 Project: Teiid Issue Type: Bug Affects Versions: 7.5 Environment: java version "1.6.0_20" OpenJDK Runtime Environment (IcedTea6 1.9.10) (rhel-1.23.1.9.10.el5_7-x86_64) OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode) on Red Hat Enterprise Linux Server release 5.7 (Tikanga) Teiid 7.5 with a patch applied for issue TEIID-1812 Perl client running on either Fedora 16 or RHEL 5.7 Using perl-DBD-Pg-2.18.0-3.fc16.x86_64 Reporter: Graeme Gillies Assignee: Steven Hawkins We are using a simple perl script to connect to teiid and run a query, spitting out the results. Unfortunately we find that the perl client hangs forever when trying to execture/return a resultset > 512 rows, but 512 or less it runs fine The code for a test script is as follows {code} #! /usr/bin/perl use strict; use warnings; use DBI; my $db_type = 'Pg'; my $db_name = 'EngVDBF'; my $db_host = 'vdb.engineering.redhat.com'; my $db_port = 35432; my $user = 'teiid'; my $pass = 'teiid'; my $attr = { AutoCommit => 0, RaiseError => 1 }; my $dsn = sprintf( "dbi:%s:dbname=%s;host=%s;port=%s", $db_type, $db_name, $db_host, $db_port ); my $dbh = DBI->connect( $dsn, $user, $pass, $attr ); my $limit = ( $ARGV[0] ) ? "limit $ARGV[0]" : ""; my $query = <<QUERY; select bugs.bug_id, bugs.priority, bugs.bug_severity from BugzillaS.bugs bugs $limit QUERY my $sth = $dbh->prepare($query); $sth->execute(); while ( my @row = $sth->fetchrow_array() ) { print join( ',', map {"\"$_\""} @row ) . "\n"; } $sth->finish(); $dbh->disconnect(); {code} When running {noformat} ./teiid.pl 512 {noformat} Query runs fine, when we run {noformat} ./teiid.pl 513 {noformat} Client just sits there forever (the query actually has about 1800 odd rows returning). -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

6
5
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues December 2011