We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
Submitted by: @hvlad
Is related to QA273
This query make AV in engine
SELECT RDB$RELATION_ID, (WITH RECURSIVE NUM (ID) AS ( SELECT 1 FROM RDB$DATABASE
UNION ALL SELECT ID \+ 1 FROM NUM WHERE ID < 10 \) SELECT MAX\(ID\) FROM NUM \) AS NNN
FROM RDB$DATABASE ORDER BY NNN
There is workaround. This query is equal and works ok :
WITH RECURSIVE NUM (ID) AS ( SELECT 1 FROM RDB$DATABASE
UNION ALL SELECT ID \+ 1 FROM NUM WHERE ID < 10
) SELECT RDB$RELATION_ID, (SELECT MAX(ID) FROM NUM) AS NNN FROM RDB$DATABASE ORDER BY NNN
Commits: 8ef2bbd 5fa620a 1dc03fa
The text was updated successfully, but these errors were encountered:
assignee: Vlad Khorsun [ hvlad ]
Sorry, something went wrong.
status: Open [ 1 ] => In Progress [ 3 ]
Commented by: @hvlad
test mail #2
status: In Progress [ 3 ] => Resolved [ 5 ]
resolution: Fixed [ 1 ]
Fix Version: 2.5 RC2 [ 10372 ]
Fix Version: 2.1.4 [ 10361 ]
Fix Version: 3.0 Alpha 1 [ 10331 ]
Link: This issue is related to QA273 [ QA273 ]
Commented by: @pmakowski
Q/A test made
status: Resolved [ 5 ] => Closed [ 6 ]
status: Closed [ 6 ] => Closed [ 6 ]
QA Status: Done successfully
hvlad
No branches or pull requests
Submitted by: @hvlad
Is related to QA273
This query make AV in engine
SELECT RDB$RELATION_ID,
(WITH RECURSIVE
NUM (ID) AS
(
SELECT 1 FROM RDB$DATABASE
FROM RDB$DATABASE
ORDER BY NNN
There is workaround. This query is equal and works ok :
WITH RECURSIVE
NUM (ID) AS
(
SELECT 1 FROM RDB$DATABASE
)
SELECT RDB$RELATION_ID, (SELECT MAX(ID) FROM NUM) AS NNN
FROM RDB$DATABASE
ORDER BY NNN
Commits: 8ef2bbd 5fa620a 1dc03fa
The text was updated successfully, but these errors were encountered: