This SQL should not compile
---------------------------
Key: CORE-6156
URL: http://tracker.firebirdsql.org/browse/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.
SELECT
e.emp_no
FROM employee e
JOIN employee_project p ON p.emp_no = e.emp_no
GROUP BY e.emp_no
HAVING MAX((SELECT
SUM(e2.salary)
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:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
