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

[Ivan Chan (JIRA)]

Ivan Chan created TEIID-3881:
--------------------------------

             Summary: 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


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)