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:
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
[AIorK4yKBQQn]
ARIEL ABADI
Direct: +54 11 5279.2054
Mobile: +54 9 11 6050.0101
Email: aabadi@starbi.com
Web: www.starbi.com
_______________________________________________ users-list mailing list -- users-list@monetdb.org To unsubscribe send an email to users-list-leave@monetdb.org
-- 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