Bug with a simple case and a subquery [CORE1343]

[firebird-automations]

Submitted by: Maycon Ferraca (ferraca)

Relate to CORE2584
Is related to QA329

It seems to me a bug with a simple case and a subquery:

Example:

--works fine (searched case with a subquery)
SELECT
CASE
WHEN (SELECT 'A' FROM RDB$DATABASE) = 'A' THEN
'Y'
WHEN (SELECT 'A' FROM RDB$DATABASE) = 'B' THEN
'B'
ELSE
'N'
END
FROM RDB$DATABASE

--works fine (simple case without a subquery)
SELECT
CASE 'A'
WHEN 'A' THEN
'Y'
WHEN 'B' THEN
'N'
ELSE
'U'
END
FROM RDB$DATABASE

--don't work (simple case with a subquery)
SELECT
CASE (SELECT 'A' FROM RDB$DATABASE)
WHEN 'A' THEN
'Y'
WHEN 'B' THEN
'N'
ELSE
'U'
END
FROM RDB$DATABASE

/*
Invalid token.
invalid request BLR at offset 110.
context already in use (BLR error).
*/

Commits: 9150e6f e54682e

[firebird-automations]

Modified by: Maycon Ferraca (ferraca)

description: It seems to me a bug with a simple case and a subquery:

Example:

--works fine (searched case with a subquery)
SELECT
CASE
WHEN (SELECT 'A' FROM RDB$DATABASE) = 'A' THEN
'Y'
WHEN (SELECT 'A' FROM RDB$DATABASE) = 'B' THEN
'B'
ELSE
'N'
END
FROM RDB$DATABASE

--works fine (simple case without a subquery)
SELECT
CASE 'A'
WHEN 'A' THEN
'Y'
WHEN 'B' THEN
'N'
ELSE
'U'
END
FROM RDB$DATABASE

--don't work (simple case without a subquery)
SELECT
CASE (SELECT 'A' FROM RDB$DATABASE)
WHEN 'A' THEN
'Y'
WHEN 'B' THEN
'N'
ELSE
'U'
END
FROM RDB$DATABASE

/*
Invalid token.
invalid request BLR at offset 110.
context already in use (BLR error).
*/

=>

It seems to me a bug with a simple case and a subquery:

Example:

--works fine (searched case with a subquery)
SELECT
CASE
WHEN (SELECT 'A' FROM RDB$DATABASE) = 'A' THEN
'Y'
WHEN (SELECT 'A' FROM RDB$DATABASE) = 'B' THEN
'B'
ELSE
'N'
END
FROM RDB$DATABASE

--works fine (simple case without a subquery)
SELECT
CASE 'A'
WHEN 'A' THEN
'Y'
WHEN 'B' THEN
'N'
ELSE
'U'
END
FROM RDB$DATABASE

--don't work (simple case with a subquery)
SELECT
CASE (SELECT 'A' FROM RDB$DATABASE)
WHEN 'A' THEN
'Y'
WHEN 'B' THEN
'N'
ELSE
'U'
END
FROM RDB$DATABASE

/*
Invalid token.
invalid request BLR at offset 110.
context already in use (BLR error).
*/

[firebird-automations]

Modified by: @asfernandes

Version: 2.1 Alpha 1 [ 10150 ]

Version: 2.0.1 [ 10090 ]

Version: 2.0.0 [ 10091 ]

Version: 2.0.2 [ 10130 ]

[firebird-automations]

Commented by: Maycon Ferraca (ferraca)

Any chance to fix this issue?

Thanks

[firebird-automations]

Modified by: @pcisar

Workflow: jira [ 12492 ] => Firebird [ 15260 ]

[firebird-automations]

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5 Beta 1 [ 10251 ]

[firebird-automations]

Modified by: @asfernandes

Link: This issue relate to CORE2584 [ CORE2584 ]

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA329 [ QA329 ]

[firebird-automations]

Commented by: @pcisar

Test added.

[firebird-automations]

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test => Done successfully