[KYLIN-2670] Fix CASE WHEN issue in orderby clause

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: v2.0.0
• Fix Version/s: v2.1.0
• Component/s: Query Engine
• Labels: focus scope
• Flags: Important
• Assignee: liyang
• Reporter: zhou degao
• Created: 15/Jun/17 02:07
• Updated: 17/Aug/17 15:03
• Resolved: 04/Aug/17 01:10

Description

Following query failed in kylin 2.0 but succeeded in kylin 1.6
select "fact_pv_data_alias"."PRODUCT_NAME" as "c0", "fact_pv_data_alias"."PLATFORM" as "c1" from "CSDNBI"."FACT_PV_DATA" as "fact_pv_data_alias" group by "fact_pv_data_alias"."PRODUCT_NAME", "fact_pv_data_alias"."PLATFORM" order by CASE WHEN "fact_pv_data_alias"."PRODUCT_NAME" IS NULL THEN 1 ELSE 0 END, "fact_pv_data_alias"."PRODUCT_NAME" ASC, CASE WHEN "fact_pv_data_alias"."PLATFORM" IS NULL THEN 1 ELSE 0 END, "fact_pv_data_alias"."PLATFORM" ASC

Reported error in kylin 2.0:
Error while executing SQL "select "fact_pv_data_alias"."PRODUCT_NAME" as "c0", "fact_pv_data_alias"."PLATFORM" as "c1" from "CSDNBI"."FACT_PV_DATA" as "fact_pv_data_alias" group by "fact_pv_data_alias"."PRODUCT_NAME", "fact_pv_data_alias"."PLATFORM" order by CASE WHEN "fact_pv_data_alias"."PRODUCT_NAME" IS NULL THEN 1 ELSE 0 END, "fact_pv_data_alias"."PRODUCT_NAME" ASC, CASE WHEN "fact_pv_data_alias"."PLATFORM" IS NULL THEN 1 ELSE 0 END, "fact_pv_data_alias"."PLATFORM" ASC LIMIT 50000": index (2) must be less than size (2)