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