[JBoss JIRA] (TEIID-4252) BigInteger is being presented as BigDecimal
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4252?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4252:
---------------------------------------
Biginteger is not a valid postresql type. Also are you importing the metadata in Designer or with Teiid? Generally BigInteger is not a source datatype, rather it usually maps to the widest possible precision decimal with 0 scale. Then the import process should consider the scale and represent the value in Teiid as BigInteger, but can fall back on BigDecimal depending upon the particulars of the import.
> BigInteger is being presented as BigDecimal
> -------------------------------------------
>
> Key: TEIID-4252
> URL: https://issues.jboss.org/browse/TEIID-4252
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.12
> Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA
> Reporter: dalex dalex
> Assignee: Steven Hawkins
>
> Fields of a table with BigInteger types are being presented as fields with BigDecimal types.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 10 months
[JBoss JIRA] (TEIID-4252) BigInteger is being presented as BigDecimal
by dalex dalex (JIRA)
dalex dalex created TEIID-4252:
----------------------------------
Summary: BigInteger is being presented as BigDecimal
Key: TEIID-4252
URL: https://issues.jboss.org/browse/TEIID-4252
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.12
Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA
Reporter: dalex dalex
Assignee: Steven Hawkins
Fields of a table with BigInteger types are being presented as fields with BigDecimal types.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 10 months
[JBoss JIRA] (TEIID-3854) Impala translator - ORDER BY clause using incorrect columns when not in SELECT list
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3854?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3854.
---------------------------------
> Impala translator - ORDER BY clause using incorrect columns when not in SELECT list
> -----------------------------------------------------------------------------------
>
> Key: TEIID-3854
> URL: https://issues.jboss.org/browse/TEIID-3854
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.12.1, 8.12.2
> Environment: Ubuntu Trusty on AWS
> Reporter: Don Krapohl
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 8.12.3, 8.13
>
>
> We have a scenario in which users want to see month and day names but the data should be sorted by month and day NUMBER. The translated query comes back sorted the wrong column. Oddly in the ORDER clause the translator uses the month name column alias when we specify the month number, day name when we specify day number.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 10 months
[JBoss JIRA] (TEIID-3858) Planning error with unrelated sort columns and view removal
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3858?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3858.
---------------------------------
> Planning error with unrelated sort columns and view removal
> -----------------------------------------------------------
>
> Key: TEIID-3858
> URL: https://issues.jboss.org/browse/TEIID-3858
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.12
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.12.3, 8.13
>
>
> There is an array index out of bounds in rule merge virtual correct order by when there is an unrelated sort over a query with a grouping:
> select a from (SELECT intkey as a, stringkey as b FROM BQT1.SmallA group by intkey, stringkey union all SELECT intkey as a, stringkey as b FROM BQT1.Smallb group by intkey, stringkey) as v order by b
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 10 months