[teiid-issues] [JBoss JIRA] (TEIID-3881) time date function doesn't return value without sorting

[Ivan Chan (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ivan Chan closed TEIID-3881.
----------------------------
    Resolution: Done


> time date function doesn't return value without sorting
> -------------------------------------------------------
>
>                 Key: TEIID-3881
>                 URL: https://issues.jboss.org/browse/TEIID-3881
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.12.3
>         Environment: Teiid 8.12.3 and PostgreSQL 9.3.2
>            Reporter: Ivan Chan
>            Assignee: Steven Hawkins
>              Labels: teiid-engine
>
> HOUR(), MINUTE(), SECOND(), DAYOFMONTH(), DAYOFWEEK(), DAYOFYEAR(), MONTH(),
> QUARTER(), WEEK(), YEAR() are returning null unless sql is ordered by date time function.
> Not working query:
> select MONTH("birth_date") as "MONTH_birth_date", 
> MONTH("birth_date") as "Month_Field", 
> "birth_date"
> from "FoodmartDataSource_public"."employee"
> order by "birth_date"
>  limit 200001 
> Working query:
> select MONTH("birth_date") as "MONTH_birth_date", 
> MONTH("birth_date") as "Month_Field", 
> "birth_date"
> from "FoodmartDataSource_public"."employee"
> order by "birth_date", "Month_Field"
>  limit 200001 



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)