schema s1(user_id:ty0, parent_id:ty0, ??);
table users(s1);
query q1
`SELECT user.user_id as id
FROM users u
JOIN users AS p
ON p.user_id = u.parent_id
WHERE u.user_id = u.user_id`;
query q2
`SELECT user.user_id as id
FROM users u
JOIN users AS p
ON p.user_id = u.parent_id
WHERE u.user_id = u.user_id`;
verify q1 q2;
Cosette returns a syntax error pointing to users on the line of the the JOIN.
With this query,
Cosette returns a syntax error pointing to
users
on the line of the theJOIN
.