/
krasninja
/
querycat
Обзор
Документация
Войти
/
krasninja
/
querycat
Код
Пакеты
0
Релизы
0
Аналитика
Безопасность
develop
src/QueryCat.IntegrationTests/Tests/SelectComplex1.yaml
14 строк
343 B
Ivan Kozhin
Correct sort and limit for compound select
29 окт 2022, 18:49
29 окт 2022, 18:49
210c3a9
Код
Авторство
О чём код?
expected: | 2,City Sochi,test 1,City Krasnoyarsk,test query: | select abs(id - 2), 'City ' || city, (select 'test') as 'test' from 'Simple2.csv' where id * 2 / 2 > 0 and id in (1, 2, 3, 4, 5) group by city || ' City' having sum(balance) + 1 >= 1000 + 800 order by id + 1 desc, city asc offset 1 - 1 fetch 10 * 2;