Github user dongjoon-hyun commented on a diff in the pull request: https://github.com/apache/spark/pull/22582#discussion_r221409258 --- Diff: sql/core/src/test/resources/sql-tests/inputs/pivot.sql --- @@ -297,3 +297,13 @@ PIVOT ( sum(earnings) FOR course IN ('dotNET', 'Java') ); + +-- correctly handle pivot columns with different cases +SELECT * FROM ( + SELECT course, earnings, "a" as a, "z" as z, "b" as b, "y" as y, "c" as c, "x" as x, "d" as d, "w" as w + FROM courseSales +) +PIVOT ( + sum(Earnings) --- End diff -- You can update the comment at line 291, too.
--- --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org