[#CORE-6108] Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters

Firebird Core

Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters

Created: 24/Jul/19 02:01 PM Updated: 17/Dec/19 08:36 AM

Component/s:

None

Affects Version/s:

3.0.4

Fix Version/s:

3.0.5, 4.0 Beta 2

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).

Description

« Hide

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 .
*/

All

Comments

Change History

Subversion Commits

Sort Order:

Gilberto Ximenes made changes - 24/Jul/19 04:35 PM

Field	Original Value	New Value
Summary	Regression(?) Throws "Datatypes are not comparable in expression" in procedure parameters	Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters
Security	Developers [ 10012 ]

Adriano dos Santos Fernandes made changes - 29/Jul/19 12:20 AM

Assignee

Adriano dos Santos Fernandes [ asfernandes ]

Adriano dos Santos Fernandes made changes - 06/Aug/19 03:27 PM

Status	Open [ 1 ]	Resolved [ 5 ]
Fix Version/s		4.0 Beta 2 [ 10888 ]
Resolution		Fixed [ 1 ]

Pavel Zotov made changes - 30/Aug/19 02:18 PM

Status	Resolved [ 5 ]	Resolved [ 5 ]
QA Status	No test	Done successfully

Pavel Zotov made changes - 30/Aug/19 02:19 PM

Status	Resolved [ 5 ]	Resolved [ 5 ]
Test Details		Don't close until 3.0.x will be fixed (4.x now is OK).

Adriano dos Santos Fernandes made changes - 03/Sep/19 03:50 PM

Fix Version/s

3.0.5 [ 10885 ]

Dmitry Yemanov made changes - 17/Dec/19 08:36 AM

Link

This issue relate to CORE-6187 [ CORE-6187 ]