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 in rse\invalidate_child_rpbs for recursive queies [CORE1146] #1568
Comments
Modified by: @hvladstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.1 [ 10041 ] |
Commented by: @pcisar Fix confirmed for 2.1 Alpha 1. Test added. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Commented by: @pcisar Reopened to update ticket information. |
Modified by: @pcisarWorkflow: jira [ 11651 ] => Firebird [ 15199 ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Labels
Submitted by: @hvlad
Is related to QA46
Reported by Dmitry Voroshin
CREATE TABLE C (
ID INTEGER,
NAME VARCHAR(100)
);
CREATE TABLE T (
ID INTEGER,
OWNERCODE INTEGER,
CODE INTEGER
);
COMMIT;
WITH RECURSIVE X (ID, OWNERCODE, CODE, OWNCLASS, CLASS) AS
(
SELECT http://T.ID, OWNERCODE, CODE, http://C2.NAME AS OWNCLASS, http://C1.NAME AS CLASS
FROM T INNER JOIN C C1 ON http://C1.ID = CODE
LEFT JOIN C C2 ON http://C2.ID = OWNERCODE
WHERE OWNERCODE = 0
UNION ALL
SELECT http://T.ID, OWNERCODE, CODE, http://C2.NAME AS OWNCLASS, http://C1.NAME AS CLASS
FROM T INNER JOIN C C1 ON http://C1.ID = CODE
LEFT JOIN C C2 ON http://C2.ID = OWNERCODE
INNER JOIN X ON T.OWNERCODE = X.CODE
)
SELECT * FROM X
Commits: af5ef6a
The text was updated successfully, but these errors were encountered: