This SQL should not compile

                 Key: CORE-6156
             Project: Firebird Core
          Issue Type: Bug
            Reporter: Attila Molnár

We have a similar structura SQL in our code, I rewrite it to EMPLOYEE.FDB.

FROM employee e
    JOIN employee_project p ON p.emp_no = e.emp_no
GROUP BY e.emp_no
            FROM employee e2
                JOIN employee_project p2 ON p2.emp_no = e2.emp_no
            WHERE e2.emp_no = e.emp_no AND
                  p2.proj_id IS NOT DISTINCT FROM p.proj_id)) <> 0

Why this is compiles? In the subselect p.proj_id should not be accepted - group 
does not contains it, and has no aggregate on it. What value the current engine 
choose when it runs, and why?

Thank you!

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:


Firebird-Devel mailing list, web interface at

Reply via email to