SNOW-859832: DataFrame.agg() duplicates columns

[martin-frydl]

With following Java code:

Updatable latestIdTable = session.table("test_table");
DataFrame latestIdQuery = latestIdTable.where(latestIdTable.col("status").equal_to(functions.lit("ready")))
                .groupBy(new Column[] {latestIdTable.col("name")})
                .agg(new Column[] {latestIdTable.col("name"), functions.max(latestIdTable.col("id")).as("LATEST_ID")});
latestIdQuery.explain();

I get query:

SELECT
  "NAME", <------ here the column is doubled
  "NAME",
  max("ID") AS "LATEST_ID"
FROM  ( SELECT * FROM (SELECT * FROM (test_table)) WHERE ("STATUS" = 'ready') )
GROUP BY "NAME"

Snowpark version 1.6.2 works fine, "NAME" is present only once.

[sfc-gh-jfreeberg]

@martin-frydl -- You mentioned this behavior doesn't occur in v1.6.2. Which version are you using in this code sample? 1.8.0?

[martin-frydl]

The code is the same in both versions but the resulting query is from 1.8.0. When run in 1.6.2, the query will have one "NAME" replaced by autogenerated name as a result of rename of conflicting column name.