|
If you were logged in you would be able to see more operations.
|
|
|
|
Issue Links:
|
Relate
|
|
This issue relate to:
|
|
|
CORE-6187 Length of INPUT parameter in SQLDA depends on whether it is enclosed in COALESCE() or no.
|
|
|
|
|
|
|
|
| QA Status: |
Done successfully
|
| Test Details: |
Don't close until 3.0.x will be fixed (4.x now is OK).
|
|
Test case:
SET TERM ^ ;
CREATE OR ALTER procedure TEST_PROC (
P_DATE date)
returns (
OUT_VALUE date)
as
begin
OUT_VALUE = P_DATE;
suspend;
end^
SET TERM ; ^
SELECT OUT_VALUE
FROM TEST_PROC('2019-'|| COALESCE(:ID_MES, 1) ||'-01');
/*
FB2.5 - OK
FB3.0.4.33054-0_x64- Raises
Invalid token.
SQL error code = -104.
Datatypes are not comparable in expression .
*/
|
|
Description
|
Test case:
SET TERM ^ ;
CREATE OR ALTER procedure TEST_PROC (
P_DATE date)
returns (
OUT_VALUE date)
as
begin
OUT_VALUE = P_DATE;
suspend;
end^
SET TERM ; ^
SELECT OUT_VALUE
FROM TEST_PROC('2019-'|| COALESCE(:ID_MES, 1) ||'-01');
/*
FB2.5 - OK
FB3.0.4.33054-0_x64- Raises
Invalid token.
SQL error code = -104.
Datatypes are not comparable in expression .
*/
|
Show » |
|
Bug
Resolved
