[ https://issues.jboss.org/browse/TEIID-4520?page=com.atlassian.jira.plugin... ] Rafal Korytkowski commented on TEIID-4520: ------------------------------------------ [~rareddy], do you basically disagree with [~shawkins]? Let's try to get it straight. Here are the options for handling NullOrder.LAST as defaultNullOrder: 1. SELECT IntNum FROM BQT1.SmallA ORDER BY IntNum will be rewritten to SELECT IntNum FROM BQT1.SmallA ORDER BY IntNum NULLS FIRST to match Teiid's expected ordering. 2. SELECT IntNum FROM BQT1.SmallA ORDER BY IntNum will not be rewritten and NULLS will be returned last. a) SELECT IntNum FROM BQT1.SmallA ORDER BY convert(IntNum, bigdecimal) will return NULLS as first since Teiid's internal sort will be applied. b) SELECT IntNum FROM BQT1.SmallA ORDER BY convert(IntNum, bigdecimal) will return NULLs as last since Teiid's will respect defaultNullOrder when doing internal sort. 2a is the current behavior, which I don't think is quite right. IMO 1. would be the most expected behavior, however 2b is also acceptable. -- This message was sent by Atlassian JIRA (v7.5.0#75005)