| Subject | Re: [firebird-support] Why this SQL is correct? |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2019-10-14T10:00:29Z |
14.10.2019 11:47, ma_golyo@... [firebird-support] wrote:
--
WBR, SD.
> In the subselect p.proj_id should not be accepted - group does not contains it, and has noCurrent one. The subquery is executed for each record of master result set BEFORE grouping.
> aggregate on it. What value the engine choose when it runs, and why?
--
WBR, SD.