Hi All! I used to have a query that was working in a prior version (11.39.13), but now that I have upgraded to the newest version (11.45.13) this same query is not working any more. The query is the following: SELECT nrm_tim_date AS nrm_tim_date, ( (SELECT SUM(nrm_rse_amount_usd * exc.exc_rate) from sb_glob.exc_exchange exc where exc.exc_currency = 'USD') ) AS net_profit, SUM(nrm_rse_amount_usd) AS nrm_rse_amount_usd FROM sb_traf.cubm_202303 AS nrm GROUP BY nrm_tim_date The error Im having is "SQL Error [42000]: SELECT: subquery uses ungrouped column "nrm.nrm_rse_amount_usd" from outer query" This exact same query does work on version 11.39.13. Can someone help me with this? Thks a lot in advance ARIEL ABADI Direct: +54 11 5279.2054 Mobile: +54 9 11 6050.0101 *Email*: aabadi@starbi.com *Web*: www.starbi.com
Ariel We restricted the subquery handling. So no this isn't a bug but a feature. Niels On Mon, Mar 06, 2023 at 09:44:04AM -0300, Ariel Abadi wrote:
-- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands url: https://www.cwi.nl/people/716 e-mail: Niels.Nes@cwi.nl
participants (2)
-
Ariel Abadi -
Niels Nes