/
krasninja
/
querycat
Обзор
Документация
Войти
/
krasninja
/
querycat
Код
Пакеты
0
Релизы
0
Аналитика
Безопасность
develop
src/QueryCat.IntegrationTests/Tests/SelectGroup1.yaml
13 строк
324 B
Ivan Kozhin
Fix column resolve in subquery when it is not part of group clause
11 фев 2023, 10:40
11 фев 2023, 10:40
8ac6489
Код
Авторство
О чём код?
expected: | Krasnoyarsk,1,1 Sochi,4,1 query: | -- This is not the standard case, because t1.id is not available since it is not in group clause. select city, t1.id, (select count(*) from (select * from 'Simple2.csv' t2 where t1.id = t2.id) ) as 'result' from 'Simple2.csv' t1 group by city