Capture storage cannot be fetched

[Nefarious46]

Description
fetching storages for capture results in an error.

[Nefarious46]

Apparently there has been brainfart with the checking if capture_id exists.
File R__Procedure_Retrieve_Capture_Storages.sql has null check where

  if (select count(id) from cfe_18.capture_def_x_flow_targets where capture_def_id = capture_id = 0) then
        SELECT JSON_OBJECT('id', capture_id, 'message', 'Capture storage does not exist with given ID') into @cs;
        signal sqlstate '45000' set message_text = @cs;

should be

    if ((select count(id) from cfe_18.capture_def_x_flow_targets where capture_def_id=capture_id)= 0) then
        SELECT JSON_OBJECT('id', capture_id, 'message', 'Capture storage does not exist with given ID') into @cs;
        signal sqlstate '45000' set message_text = @cs;

NOTICE missing parentheses from when count is taken from existing records. Above code snippet results always on TRUE due to assigning the value and not handling the count correctly.

This is currently applied locally but different pull request should be created where this is fixed.

[Nefarious46]

There appears to be unit test that checks this functionality but it does not seem to catch the error...?

File StorageControllerTest.java, Line:403

Should investigate why such error is not caught and implement such measures to other unit tests aswell.