Issue Details (XML | Word | Printable)

Key: CORE-6108
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Gilberto Ximenes
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
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
 

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: Ascending order - Click to sort in descending order
There are no subversion log entries for this issue yet.