[teiid-issues] [JBoss JIRA] (TEIID-3881) time date function doesn't return value without sorting
Steven Hawkins (JIRA)
issues at jboss.org
Thu Jan 7 16:47:00 EST 2016
[ https://issues.jboss.org/browse/TEIID-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-3881.
-----------------------------------
Resolution: Rejected
> 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)
More information about the teiid-issues
mailing list