-
-
Notifications
You must be signed in to change notification settings - Fork 268
Unexpected results when using CASE WHEN with RIGHT JOIN #7993
Copy link
Copy link
Closed
Labels
affect-version: 3.0.11affect-version: 4.0.4affect-version: 5.0.0affect-version: 6.0 Initialcomponent: enginefix-version: 3.0.12fix-version: 4.0.5fix-version: 5.0.1fix-version: 6.0 Alpha 1qa: done successfullyrlsnotes60: noIntentionally not added to the Firebird 6.0 release notes.Intentionally not added to the Firebird 6.0 release notes.type: bug
Metadata
Metadata
Assignees
Labels
affect-version: 3.0.11affect-version: 4.0.4affect-version: 5.0.0affect-version: 6.0 Initialcomponent: enginefix-version: 3.0.12fix-version: 4.0.5fix-version: 5.0.1fix-version: 6.0 Alpha 1qa: done successfullyrlsnotes60: noIntentionally not added to the Firebird 6.0 release notes.Intentionally not added to the Firebird 6.0 release notes.type: bug
Considering the test case below.
The second
SELECTreturns an unexpected result: if the result of theCASEexpression isNULL, the value of theWHEREclause in the second should beNULL, and thus the second query should return empty result. Additionally, the output of the second query, containing aWHEREcondition, must not include rows that differ from those returned by the first query.I found this in version LI-T6.0.0.247 where I built from source code da67351
Besides, I have one question considering an error:
Too many concurrent executions of the same request [SQLState:54001, ISC error code:335544663]. Does this mean that we couldn't send many same queries (e.g.SELECT * FROM t0) to the server at the same time?