dolthub / dolthub/dolt

GroupBy validation not able to recognize aliased column is a literal

Open
#9,717 0 comments 0 reactions 0 assignees View on GitHub
analyzer bug correctness
Dominant language
Go
Stars
24.4k
Forks
873
Avg merge
1d 5h
Merged PRs (30d)
108

Description

This test `column_alias_queries.go` is currently skipped
```
{
// GMS returns "expression 'dt.two' doesn't appear in the group by expressions", but MySQL will execute
// this query.
Query: "select 1 as a, one + 1 as mod1, dt.* from mytable as t1, (select 1, 2 from mytable) as dt (one, two) where dt.one > 0 group by one;",
// column names: a, mod1, one, two
Expected: []sql.Row{{1, 2, 1, 2}},
}
```

It seems like we're currently unable to see that dt.two resolves to a Literal

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.