jayzhan211 commented on code in PR #10375: URL: https://github.com/apache/datafusion/pull/10375#discussion_r1589915206
########## datafusion/sqllogictest/test_files/expr.slt: ########## @@ -2325,28 +2325,142 @@ host3 3.3 # can have an aggregate function with an inner CASE WHEN query TR -select t2."struct(t1.time,t1.load1,t1.load2,t1.host)"['c3'] as host, sum((case when t2."struct(t1.time,t1.load1,t1.load2,t1.host)"['c3'] is not null then t2."struct(t1.time,t1.load1,t1.load2,t1.host)" end)['c2']) from (select struct(time,load1,load2,host) from t1) t2 where t2."struct(t1.time,t1.load1,t1.load2,t1.host)"['c3'] IS NOT NULL group by t2."struct(t1.time,t1.load1,t1.load2,t1.host)"['c3'] order by host; +select + t2.server_host as host, + sum(( + case when t2.server_host is not null + then t2.server_load2 + end + )) + from ( + select + struct(time,load1,load2,host)['c2'] as server_load2, + struct(time,load1,load2,host)['c3'] as server_host + from t1 + ) t2 + where server_host IS NOT NULL + group by server_host order by host; ---- host1 101 host2 202 host3 303 +# TODO: Issue tracked in https://github.com/apache/datafusion/issues/10364 Review Comment: This is the issue from #10364, not a regression caused by this change. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
