sleek
sleek copied to clipboard
FULL OUTER JOIN causes confusion
select *
from users u
full outer join departments d on u.deptid = d.id
gets transformed into
SELECT
*
FROM
users u FULL
OUTER JOIN departments d ON u.deptid = d.id
when it should get transformed into
SELECT
*
FROM
users u
FULL OUTER JOIN departments d ON u.deptid = d.id
sleek works correctly if that's a LEFT OUTER JOIN.
SELECT
*
FROM
users u
LEFT OUTER JOIN departments d ON u.deptid = d.id
The table aliases don't seem to affect it one way or the other.
SELECT
*
FROM
users FULL
OUTER JOIN departments ON users.deptid = departments.id