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
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 ]