
|
If you were logged in you would be able to see more operations.
|
|
|
| Planning Status: |
Unspecified
|
|
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
|
|
Description
|
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
|
Show » |
|