[CALCITE-3762] AggregateProjectPullUpConstantsRule causes fields to be out of order

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.10.0, 1.16.0
• Component/s: core
• Assignee: Unassigned
• Reporter: hezhang
• Created: 31/Jan/20 17:12
• Updated: 20/Feb/20 05:40

Description

the sql:

select * FROM( SELECT plat, category, rid, populary_num FROM panda_com.crawler_anchor WHERE
                                             par_date = '20180819'
                                     AND     plat = 'huya'
                                     AND     rid = 'meijiao'
                    ) a
     JOIN
             (
                     SELECT DISTINCT
                             'huya' plat         ,
                             edwin.privatehost ,
                             edwin.profileroom
                     FROM
                             panda_com.ol_huya_isOnline edwin
                     WHERE
                             par_date = '20180819' ) m9
     ON
             a.rid= m9.privatehost
     AND     a.plat = m9.plat

the result:

 

huya yule meijiao 30 huya 10001242 meijiao

 

but the desired result is:

 

huya yule meijiao 30 huya meijiao 10001242  

 

cause:

hepPlanner use AggregateProjectPullUpConstantsRule:

after add fix patch: