/
githubmirror
/
sqlc
Обзор
Документация
Войти
/
githubmirror
/
sqlc
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
internal/endtoend/testdata/join_clauses_order/postgresql/query.sql
27 строк
627 B
Kyle Gray
test(endtoend): Split shema and queries (#2803)
04 окт 2023, 19:13
Не верифицирован
04 окт 2023, 19:13
5664224
Код
Авторство
О чём код?
-- name: TestLeftInner :many SELECT a.a, b.b, c.c FROM a LEFT JOIN b ON b.a_id = a.id INNER JOIN c ON c.a_id = a.id; -- name: TestInnerLeft :many SELECT a.a, b.b, c.c FROM a INNER JOIN b ON b.a_id = a.id LEFT JOIN c ON c.a_id = a.id; -- name: TestLeftInnerLeftInner :many SELECT a.a, b.b, c.c, d.d, e.e FROM a LEFT JOIN b ON b.a_id = a.id INNER JOIN c ON c.a_id = a.id LEFT JOIN d ON d.a_id = a.id INNER JOIN e ON e.a_id = a.id; -- name: TestInnerLeftInnerLeft :many SELECT a.a, b.b, c.c, d.d, e.e FROM a INNER JOIN b ON b.a_id = a.id LEFT JOIN c ON c.a_id = a.id INNER JOIN d ON d.a_id = a.id LEFT JOIN e ON e.a_id = a.id;