New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
AV preparing a query with aggregate over derived table [CORE2416] #2834
Comments
Modified by: @hvladassignee: Vlad Khorsun [ hvlad ] |
Commented by: @hvlad Case for FB 2.0.x SELECT t4.f2, t4.f1_p |
Modified by: @hvladVersion: 2.1.2 [ 10270 ] Version: 2.0.5 [ 10222 ] Version: 2.5 Alpha 1 [ 10224 ] Version: 2.0.4 [ 10211 ] Version: 2.1.0 [ 10041 ] Version: 2.0.3 [ 10200 ] Version: 2.0.2 [ 10130 ] Version: 2.0.1 [ 10090 ] Version: 2.0.0 [ 10091 ] Version: 2.1.1 [ 10223 ] |
Commented by: @pcisar Well, I can't reproduce this problem with neither 2.1.1 or 2.0.5 (both 64-bit SS Linux version). Do I miss something here? |
Commented by: @hvlad Just reproduced it with 2.0.0 and 2.0.6, both Win32 SS |
Commented by: @hvlad Found very old 2.1.0 RC2 - Win32 SS crashed while Win64 SS don't |
Commented by: @pcisar I can confirm it too with Win32 version too. So it seems strictly 32-bit related. |
Commented by: @pcisar QA test added. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovstatus: Closed [ 6 ] => Closed [ 6 ] QA Status: No test => Done successfully |
Submitted by: @hvlad
Is related to QA235
WITH
t0 AS (
SELECT 1 AS f0, date '01.03.09' AS f1, 'Event1' AS f2
FROM rdb$database
),
t1 (f1) AS (
SELECT MIN(t2.f1) AS f1 FROM t0 AS t2 WHERE t2.f0 > t3.f0 AND t2.f1 >= t3.f1 AND t2.f2 = t3.f2
)
SELECT t4.f2, t4.f1_p
FROM (SELECT t3.f0, t3.f1, t3.f2, CAST((SELECT t1.f1 FROM t1) - t3.f1 AS INTEGER) AS f1_p
FROM t0 AS t3
) AS t4
WHERE t4.f1_p IS NOT NULL
GROUP BY t4.f2, t4.f1_p
Commits: b1e58c9 8f8472f
The text was updated successfully, but these errors were encountered: