Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
2018-05, 2018-06, 2018-07, 2018-08
Description
This appears to return no data:
select
|
*
|
from table |
where
|
(CASE |
WHEN (COALESCE('0') = '0') THEN |
(CASE |
WHEN (COALESCE('ALL') = 'ALL') THEN 1=1 |
WHEN (COALESCE('ALL') IS NOT NULL) THEN company = 'AAA' |
ELSE 0=1 |
END) |
ELSE (CASE |
WHEN (COALESCE('ALL') = 'ALL') THEN 0=1 |
WHEN (COALESCE('ALL') IS NOT NULL) THEN company = 'AAA' |
ELSE 1=1 |
END) |
END); |